I want to schedule a daily differential backup of a database such that I keep the last 3 backups. (ie The file xyz.bak would contain today's, yesterday's & the day before's differential backup). What is the best way of doing this? If I select 'Append to media' I don't seem to be able to set a lifetime for the backup.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL 2000 Backups
- Thread starter richgill
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
