Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbaman
Starting Member
46 Posts |
 Posted - 2014-05-05 : 13:56:53
|
| I have one of the database on SQL Server 2000. The database is close to 200 GB. Any single local disks I have are not free enough to accommodate the entire backup. Is there a T-SQL script that I can run to specify the multiple backup file location with size so I can distribute my backup across multiple disks. Or Any other workaround someone wants to suugest? I tried the USB disks , however SQL Server wont use that to save the backup file.ThanksR |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-06 : 15:37:41
|
| I can't remember if SQL 2000 supports multiple files for backups, but it probably does. Those files are pretty much going to be equally sized. If you have a disk size limitation, then create more files and places multiple files on the locations where you have more storage.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-06 : 15:38:27
|
| You should also consider writing the backup directly to a network share, whether it be a NAS share or just another Windows server. That way if you lose your SQL Server, you still have the backups in another location.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
SQLServer 2000 Backup on Multiple Disks