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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-20 : 08:17:51
|
| Kelvin Ng writes "i would like to create backup for these database ;1) master - daily full backup2) msdb - daily full backup3) model - daily full backup4) userdatabase - daily full backup + every 4 hours differential backup + every half hour transaction log backupthe problem is the backup for userdatabase is growing bigger & bigger (i choose append options), how do i schedule it to overwrite the the backup file for differential & transaction log after the full backup." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-20 : 08:38:58
|
| Once a day, use the WITH INIT arguement.Jay White{0} |
 |
|
|
|
|
|
SQL 7.0 Database Backup