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)
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With