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 |
|
SQL2000User
Starting Member
13 Posts |
 Posted - 2006-08-10 : 13:56:33
|
| IF we use SQL Server 2000 'Database Maintenance Plan' to create database backup and maintenance job, it will do create backup file first, then delete the old backup file as you indicate in wizard(such as 3 days old ) . Is there anyone who knows how to do if I want to delete the old backup file first then create new backup file?Thanks in advanceFlora |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-10 : 13:59:38
|
| You really should not do that.If you get an error before the backup completes, you would have no backup file to recover the database from.CODO ERGO SUM |
 |
|
|
SQL2000User
Starting Member
13 Posts |
Posted - 2006-08-11 : 09:32:03
|
| Hi, Thanks for your reply. Actually, it is because short of space in our server. And I think what you mentioned make the sense. so I maybe think about to keep less day's backup file as temp solution.Flora |
|
|
|
|
|
|
Q about 'Database Maintenance Plan'