May 5, 2014 at 11:58 am
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.
Thanks
R
May 5, 2014 at 2:56 pm
You can't specify a size for each backup file when backing up to multiple files but you can estimate their size based on the db size. So for a 200GB db spread across 4 files, they should all be roughly 50GB each. For example, if you have 100GB free on the C drive and 50GB free on the D and E drives you could do something like this:
BACKUP DATABASE [dbname] TO
DISK = N'C:\dbname1.bak',
DISK = N'C:\dbname2.bak',
DISK = N'D:\dbname3.bak',
DISK = N'E:\dbname4.bak'
GO
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply