I have an Oracle account (schema) of a remote Oracle database. By using this account I can do all kinds of operations such as: query, update, delete and add. But I can't use exp or imp. Now my question is how can I dump all the data in this remote database schema, include table, view, function, procedure, package. ...
Please note this is not a question about online/hosted SVN services. I am working on a home based, solo developer, project that now has commercial significance and it is time to think about remote source code backup. There is no need for file level check in/out, all I need is once a day or once a week directory level snapshot to remote ...
My application needs to backup and restore .sdf files. There is a single dataSet the the whole application and some bindngSource and table adapters on forms using this same dataset. Just for a sake of test I tryied to copy the .sdf in runtime for a backup folder and back to restore it and I got my application not finding the file like i...
I have a backup file taken from a SQL Server 2000 database and I'm trying to restore it to a 2008 database. However, I'm getting this error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\M...
I have the following function: public void RestoreDatabase(String databaseName, String backUpFile, String serverName, String userName, String password) { SqlConnection.ClearAllPools(); ServerConnection connection = new ServerConnection(serverName, userName, password); Server sqlServer = new Server(connection); Restore rs...
Dear All, I need to take the backup of one folder of my SVN repository. for this i have tried with svndump and svndumpfilter commands but of no use. Can any one pls. explain how to do this with an example. Thanks Mohan ...
Hi, I am developing an application which needs to backup data between SQL Express 2005 and SQL Server 2008. My client runs with an installation of SQL express 2005 and needs to periodically back up data to a server database running on SQL Server 2008. The client db also receives some new data from server and needs to update itself. The ...
I'm trying to use PowerShell to create some backups, and then to copy these to a web folder (or, in other words, upload them to a WebDAV share). At first I thought I'd do the WebDAV stuff from within PowerShell, but it seems this still requires a fair amount of "manual labour", ie: constructing HTTP requests. I then settled for creating...
After having restored a database recently that contained the ASP.NET membership provider tables, I noticed the LastLoginDate and LastPasswordChangedDate are now right around the time of the restore. It doesn't look like these fields are auto calculated, so why are they recreated during the restore? ...
I'd like to make a backup of my SVN repo using tar and ftp from a cronjob once a day. This is quite easy, but I would like to make sure there's no commit etc. running while the backup is made. While there are times of the day / night where this is highly unlikely, but I'd rather not rely on that, because if I'm already up at night in som...
So here's the challenge. I need to use C# to back up a database locally from a remote database server and the only share we have is \\computer\c$. If the answer is to back up to a location on the remote database server and then copy that local, assume there is not a share on the remote location. Just b/c I have access to the database d...
When i try to get a dump of a mysql database, the dump stops when a row in it is updated. How can i prevent that? I already tried following options with no result: -f (forces continu even when error) -x (lock all tables) when i log any error, i get nothing Command i'm using: mysqldump --user=* --password=* --all-databases --log-e...
I take a backup of my root directory (/) during shutdown to the attached storage and then rsync back from the attached storage to / during booting. what's the rsync command I need to use during shutdown? Please tell me the list of directories to exclude whats the rsync command I need to use during booting ? If there are any new files ...
So I have a web system where every user gets a separate SQLite database which acts as a sort of their workspace. All of the database files are in a directory with database names that match up to the user ids. Many of these databases are created and rarely, if ever, edited. Others have many edits on a daily basis. To manage backups on t...
Hi, I run an office network and we have many servers. We try to give them nice server names regarding their functions, avoiding stupid names like 'dev01' or stuff like that. For testing our server is named 'pandora'. For development (where all stupid things happens) is named 'homer'. The question is, what's the best possible name...
I have multiple mercurial repositories and used hg clone to create backups of them on our file server. Now I want to write a batch file that updates them once a day by running hg pull -u on each subdirectory. I want to keep this backup script as generic as possible, so it should update all backup repositories stored in my H:\BACKUPS\REP...
I know of two ways to delete data from a database table DELETE it forever Use a flag like isActive/isDeleted Now the problem with isActive is that I have to track everywhere in my SQL queries that whether the record is active or not. Using DELETE however gets rid of the data forever. What would be the best way to backup this data? ...
We want to have our test servers databases updated from our production server databases on a nightly basis to ensure we're developing on the most recent data. We, however, want to ensure that any fn, sp, etc that we're currently working on in the development environment doesn't get overwritten by the backup process. What we were thinking...
Is there a way to back up a mercurial repository while preserving the files' timestamps? Right now, I'm using hg clone to copy the repository to a staging directory, and the backup program picks up the files from there. I'm not pointing the backup program directly at the repository because I don't want it to be changing (from commits) w...
I have one stored procedure to backup the database. It will backup metadata as well as data. Is there any option to back up the database with out data. ie, back up only the schema (Empty tables). I don't want to script the database. ...