We have a SQL Server 2008 database of size over 200GB. There is no disk space on the server to take a backup. I really need to take a backup or make another copy of this database. what would be the best way to achieve this?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
If you do not have enough diskspace first confirm that you have backup compression enabled. This will greatly decrease the size of your database backup. If you still do not have enough space on your server to put your backup.
I see 3 options of achieving this
--> If you do not have enough space on a networkshare
--> If you still do not have enough space on any server/share/...