Compassionate (6/9/2013)
I have executed shrink database option from MSMS.After this below are the stats1) LDF - 1024KB
2) MDF - 154MB
3) Recovery modle - simple
Now I have 83GB space to restore the db and the db which I am trying to restore is 73GB(backup files size) . But its still asking for more space now around 95GB.
Gail is correct especially when it comes to the logfile. That backup file for the logfile might be less than a megabyte but the restore size will be whatever size (could be absolutely huge) the logfile was (empty or not) at the time of the backup.
--Jeff Moden
Change is inevitable... Change for the better is not.