Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Space utilization is huge when database backup file is restored in another PC

Tags:

sql-server

I'm trying to restore backup file(.bak) to my Sql Server, .bak file size is 40 MB. But after restoration to Sql Server 2012, it occupies 100 to 120 GB space in C drive. How to fix this?

(OS and SQL installed in C: drive)

like image 589
VSV AdityaSarma Avatar asked Dec 10 '25 10:12

VSV AdityaSarma


1 Answers

The restored database is as big as the database the backup was taken on. Reduce the size before taking the backup or reduce the size after restoring.

like image 57
usr Avatar answered Dec 15 '25 06:12

usr



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!