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.
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.
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.