asp.net c#

Question

copy databse from Sqlserver programically

Lalit M · Answer

try this link For Sql Bulk Copy

Lalit M · Answer

You can use this code sample to tack backup of sql server 2005 using C#.net. public void BackupDatabase( String databaseName, String userName, String password, String serverName, String destinationPath) { Backup sqlBackup = new Backup(); sqlBackup.Action = BackupActionType.Database; sqlBackup.BackupSetDescription = " ArchiveDataBase:" + DateTime.Now.ToShortDateString(); sqlBackup.BackupSetName = " Archive" ; sqlBackup.Database = databaseName; BackupDeviceItem deviceItem = new BackupDeviceItem(destinationPath, DeviceType.File); ServerConnection connection = new ServerConnection(serverName, userName, password); Server sqlServer = new Server(connection); Database db = sqlServer.Databases[databaseName]; sqlBackup.Initialize = true ; sqlBackup.Checksum = true ; sqlBackup.ContinueAfterError = true ; sqlBackup.Devices.Add(deviceItem); sqlBackup.Incremental = false ; sqlBackup.ExpirationDate = DateTime.Now.AddDays( 3 ); sqlBackup.LogTruncation = BackupTruncateLogType.Truncate; sqlBackup.FormatMedia = false ; sqlBackup.SqlBackup(sqlServer); } for reference

asp.net c#

Answers (2)