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.