I need to take db backup which is on Mssql 2005 and there is space constraint. We have tried taking the backup twice but to no avail.
Is there an option of taking a compressed backup? I could find the same for MSSQL 2008 but not MSSQL 2005.
Please also suggest if there is any other alternative.
Thanks and Regards,