General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only