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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 7 database backup to multiple physical disks?

Status
Not open for further replies.

gman2002

MIS
Feb 11, 2002
6
US
Is it possible to backup a single database to multiple physical disks? I am getting close to filling up a drive with backup file, and was wondering if you can span multiple drives with backup. I have looked through online books and other resources and see no specific mention of multiple disks, just free space on disk.

Any thoughts/help would be appreciated.
 
I have not worked with SQL 7 but this is the way to in SQL2K:

Create multiple backupdevices and create a backup routine that uses each device. This will allow you to backup to multiple files/tapes.

Let me know if the same feature exists in SQL7.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top