SQL Server Gurus:<br><br>SQL Server DB Restore gives this error:<br><br>System.Data.SqlClient.SqlError: There is insufficient free space on disk volume &#39;C:\&#39; to create the database. The database requires 210068836352 additional free bytes, while only 209935310848 bytes are available. (Microsoft.SqlServer.Smo)<br>
<br>I understand the backup file is 121mb and the thing says it requires 195GB to restore. How 195 gig can be compressed into 121mb is beyond me so lets not go there.<br><br>Question: How can we resolve this?<br><br>Google suggests shrink the log first (which is the main culprit coz its demanding the 195gb). Shida ni its a backup. I dont think its possible to shrink a log file in a backup file (correction welcome)<br>
<br>If the original was available it would be easy to shrink the log file BEFORE taking the backup. <br><br>Am not physically at the site but I can relay the responses you guys give.<br><br>Thanx in advance<br><br><br><br>
<br>