I plan on using a database file for my site, how would I back it up if I were to make changes to my site?
From the sql server management studio, you can choose a backup option from the menus. Right-click on the database entry, choose Tasks, then Backup.
You can restore it using the Restore command.
Alternatively, you can Detach the database file, make a copy using windows, then reattach.
Can this be done on my site, if I use ftp, can I download the file?
Are you using a hosting provider? If you are, you will probably have to use their backup utility.
Once you use it, it will build a file that you should be able to ftp.
|||Using SQL DMO for automated Database Backup and Restore.
Or,
This code may help you:
public static void BackupDatabase() {string sConnect = Properties.Settings.Default.BackupConnectionString;string dbName;using (SqlConnection cnn =new SqlConnection(sConnect)) { cnn.Open(); dbName = cnn.Database.ToString(); ServerConnection sc =new ServerConnection(cnn); Server sv =new Server(sc);// Check that I'm connected to the user instance Console.WriteLine(sv.InstanceName.ToString());// Create backup device item for the backup BackupDeviceItem bdi =new BackupDeviceItem(@."C:\AppDataBackup\SampleBackup.bak", DeviceType.File);// Create the backup informaton Backup bk =new Backup(); bk.Devices.Add(bdi); bk.Action = BackupActionType.Database; bk.BackupSetDescription ="SQL Express is a great product!"; bk.BackupSetName ="SampleBackupSet"; bk.Database = dbName; bk.ExpirationDate =new DateTime(2007, 5, 1); bk.LogTruncation = BackupTruncateLogType.Truncate;// Run the backup bk.SqlBackup(sv); Console.WriteLine("Your backup is complete."); } }|||Sql server comes with the capability to do a batch job, so you can just tell it to run the backup program without having to write a program...
