Networks

Ask something
Question Locked

SQL Server 2000 - Backup Database

0 helpful
2 replies

by colmgdonnelly

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi, im running SQL server 2000 and have created a custom scheduled backup to run every night. I want this backup to create a new file each night, however i only have the option to "append" or "overwrite" the previous nights backup. Ideally want a separate backup (i.e. Monday, tuesday,...etc....

Thanks

2 replies

by bart777

Create a maintenance plan for each night that you want the backup on. that will allow you to point to different folders or use different names.

Best of luck.

This discussion is closed to new replies.