2 updated pls to please
source | link

I have a database of size 290 GB running on SQL Server 2005 (compression is not available) and disk space is z: drive 250 GB and Y: drive is 80 GB. 

How can I take a full backup in this scenario? How can I split full backup into different files in this ratio? Pls

Please suggest a method to do this.

I have a database of size 290 GB running on SQL Server 2005 (compression is not available) and disk space is z: drive 250 GB and Y: drive is 80 GB. How can I take a full backup in this scenario? How can I split full backup into different files in this ratio? Pls suggest a method to do this.

I have a database of size 290 GB running on SQL Server 2005 (compression is not available) and disk space is z: drive 250 GB and Y: drive is 80 GB. 

How can I take a full backup in this scenario? How can I split full backup into different files in this ratio?

Please suggest a method to do this.

    Post Migrated Here from stackoverflow.com
1
source | link

How to take SQL Server database under this scenario?

I have a database of size 290 GB running on SQL Server 2005 (compression is not available) and disk space is z: drive 250 GB and Y: drive is 80 GB. How can I take a full backup in this scenario? How can I split full backup into different files in this ratio? Pls suggest a method to do this.