CODEWITHSUNDEEP
sql-server
Whistler
Whistler

Reputation: 1977

SQL Server Copy database to different server

I'm trying to take a copy of a database into another server. I usually been making backup, copy the backup file to another server and restore it. But the backup is 90GB, and the space left after copying the backup to the destination folder is only 26GB. As you probably understand by now I'm not able to restore the database as it doesn't have enough space. So my question is is possible to restore database by replacing backup file? Any other suggestions? Increasing the disc space is not an option as this is just a testing server and the space will be enough after restoring. Thank you

Upvotes: 0

Views: 108

Answers (1)

DBNinja
DBNinja

Reputation: 308

Depending on your SQL Server version have you tried enabling compressing during backup. You would be surprised by how small the backup file can get after compression. Also if your database is set to SIMPLE recovery you could look to reduce the log file size before you backup.

You can find some steps on how to enable compression during backup here https://sqlbak.com/blog/how-to-configure-backup-compression/

Upvotes: 1

Related Questions