I have an application extension which I need to test. Part of the extension applies some updates to the application database schema (via the applications API). i want to test that given version 1 of the application when my class is run the schema becomes v1.1 and that certain queries for items which should exist in 1.1 return correctly...
Hi, I'm gonna get a backup with below method : void BackupDatabase(string sConnect, string dbName, string backUpPath) { using (SqlConnection cnn = new SqlConnection(sConnect)) { cnn.Open(); dbName = cnn.Database.ToString(); ServerConnection sc = new ServerConnection(cnn); Server sv = new Server(s...
Hi, I have a query regarding BackUp of third party application data on PC. I am developing an application which can store photos, text, recordings. The user can add number of photos or recordings. So at the runtime, size of application storage will go on increasing. User will never want to loose his data but storage is limited. Hence ...
When I began, I used pg_dump with the default plain format. I was unenlightened. Research revealed to me time and file size improvements with pg_dump -Fc | gzip -9 -c > dumpfile.gz. I was enlightened. When it came time to create the database anew, # create tablespace dbname location '/SAN/dbname'; # create database dbname tablespace...
I am considering backing up data from an iPhone application using the Google App Engine (GAE) - I was also considering using Python to build a RESTful app to deal with incoming/outgoing data. On the client side I am using Core Data to store the information I wish to back up, and retrieve using the GAE. I was wondering whether there we...
Hi all, Is it a bad idea to use DropBox as a backup system for Subversion repositories? Has anyone tried using Subversion with an an online file sharing utility like DropBox? What's your experiences? My concern is whether this will work - mainly because Subversion maintains locks and it's very specific about it. I'm not sure if DropB...
Is there any way to backup/restore iPhone adhoc build via iTunes? I tried different ways and manipulation and it seems to be impossible for me. But probably someone know any tricky solution to do so. I'm asking about this to test whether application works correct after restoring it backup on another device. I have live app in iTunes and...
Hi, This might be an easy one for some one but I haven't found a simple solution yet. I'm automating a larger process at the moment, and one step is to back up then drop the database, before recreating it from scratch. I've got a script that will do the back up and drop as follows: Use [Master] BACKUP DATABASE [databaseName] TO DI...
Hi, I have a SQL Server 2008 database that is hosted by a third party host (heart internet). How would I go about backing this up? I used SQL Server Management Studio Express 2008 to create the tables within the database, but the backup options within this app seem to be only of use if you have direct access to the server machine (whic...
I am using GIT on a relatively small project and I find that zipping the .git directory's contents might be a fine way to back up the project. But this is kind of weird because, when I restore, the first thing I need to do is git reset --hard. Are there any problems with backing up a GIT repo this way? Also, is there any better way to d...
I am in the process of backing up a filesystem and I need to make sure that the metadata is conserved (the file owner and creation time). The tarfile module in Python is really helpful, and I use it extensively in my solution. However, I cannot create the tar file with files conserving their metadata (presumably because copy and copy2 ...
I have a .bak file which contains backup sets of two different databases. It was made by sql server maintenance plan. Now I have to restore both databases. The problem is, that while the first database is restored ok (db_companies) the other database (db_data) gives an error: Restore failed for Server 'SBSERVER'. (Microsoft.SqlSer...
How can I backup my database to the sdcard automatically in my app? And afterward, how do I restore it? ...
When does data get restored for an app? What if I save data in the app's document directory. Then they sync with iTunes. Now iTunes has a backup. Will that data be populated to another device when they sync that new device to their iTunes or will they just get a clean install of my app? I'm trying to figure out how to keep track of a sub...
How can I backup and later restore (after a clean install) ALL resharper settings? ...
trying to implement a VSS backup solution similar to what is described here: http://stackoverflow.com/questions/692848/volume-shadow-copy-vss there is a new offering called data protection manager: http://www.microsoft.com/systemcenter/dataprotectionmanager/en/us/overview.aspx how different is this from VSS based solution? does it sol...
I created a backup disk image of my disk yesterday and the software told me to close all Windows programs to make sure the process finishes successfully. I did that, but I was wondering what happens when some program does write to the disk nevertheless during the process. Windows 7 is a complex system and surely various log files and su...
I need to take a backup of a MySQL database daily, and preferably have it email itself to an email address of my choosing. Is it possible to do this? What is the SQL to generate a backup file? How can I add this file as an "attachment" to the email which is sent? Thanks for the help, I really need to make these backups! I do know how...
I am trying to shrink my database log file. I have tried to run: USE databasename BACKUP log databasename WITH truncate_only DBCC shrinkfile (databasename_log, 1) I get the error message: Msg 155, Level 15, State 1, Line 3 'truncate_only' is not a recognized BACKUP option. Am I missing something? ...
hi Experts I want backup with RMAN and after that for example delete scott.dept and then restore it. but i can't :( I write it : 1)rman target sys/manager@db 2)in sql*plus shutdown immediate; startup mount exclusive; ALTER DATABASE ARCHIVELOG; 2)CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'g:\db\db_cf%F...