Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making backup overwrite instead of a new file each time
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01123319
Message ID:
01124332
Views:
17
>>How do I set up the SQL Server backup feature so that it overwrites the previous backup file, instead of creating a new one each night?
>
>You have guts! Spread your risk and get a few days of backups.

The backup is to another disk, that is then backed up to tape each night. So we do have daily copies on tape with the latest being the one on disk (for fast recovery).

>How are you making your backups now? holdover code from 2000 or did you code it in 2005 yourself?

Just the SQL Backup tool in Mgt Studio.
Previous
Reply
Map
View

Click here to load this message in the networking platform