Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunny_10
Yak Posting Veteran
72 Posts |
 Posted - 2014-03-04 : 10:03:23
|
| Hi How we can schedule automatic backup of Particular database . I am using Sql Server 2008 R2Thanks |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2014-03-04 : 11:45:44
|
| One way is to setup a job that executes the BACKUP DATABASE commanddjj |
 |
|
|
sunny_10
Yak Posting Veteran
72 Posts |
Posted - 2014-03-05 : 02:32:21
|
| Hi Is it possible that database backup should be saved as date wise automatically .Thanks |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-03-05 : 02:37:05
|
yes. it is possible. Use the backup database command with dynamic sqlselect @sql = N'Backup Database yourdb to disk = '''C:\yourdb' + convert(varchar(10), getdate(), 112) + ''''exec (@sql)
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
sunny_10
Yak Posting Veteran
72 Posts |
Posted - 2014-03-05 : 05:46:57
|
| Hi Khtan Where i should wrote this code so that it should run automatically.Thanks |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Automatic Backup