July 5, 2016 at 2:54 pm
I have a DB with 64 GB of logfile. I shrunk the logfile to 20 GB, took a full backup. Backup file is 216 GB. I have 259 GB free space available but when I try to restore the DB, it says I need at least 311 GB to restore this DB. What am I missing here? Why it needs 311 GB and not 211, even if I add 20 GB of log file, that is still 236 GB and not 311. Am I missing something?
July 5, 2016 at 3:22 pm
Chitown (7/5/2016)
I have a DB with 64 GB of logfile. I shrunk the logfile to 20 GB, took a full backup. Backup file is 216 GB. I have 259 GB free space available but when I try to restore the DB, it says I need at least 311 GB to restore this DB. What am I missing here? Why it needs 311 GB and not 211, even if I add 20 GB of log file, that is still 236 GB and not 311. Am I missing something?
The backup file is likely much smaller than the actual database size because of backup compression.
The total size of the database is 311 GB. That;s what you are going to need to restore this database.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 5, 2016 at 3:34 pm
There was another file .ndf close to 78 Gb in size which I completely forgot about. Didn't even notice it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply