Lawi,

The person on site should have done the truncation before doing the backup.

You can use this script to do the truncation of the logs;


BACKUP LOG [DATABASE_NAME] WITH TRUNCATE_ONLY

DBCC SHRINKDATABASE ( [DATABASE_NAME]  , TRUNCATEONLY )


Only alternative is for the user to get the hard disk space requested for so
that the restoration can be done.

Then carry out truncation after restoring.


Kind regards,

Kevin

On Thu, Sep 16, 2010 at 11:55 AM, Mr. Lawi <mail2lawi@gmail.com> wrote:
SQL Server Gurus:

SQL Server DB Restore gives this error:

System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 210068836352 additional free bytes, while only 209935310848 bytes are available. (Microsoft.SqlServer.Smo)

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.

Question: How can we resolve this?

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)

If the original was available it would be easy to shrink the log file BEFORE taking the backup.

Am not physically at the site but I can relay the responses you guys give.

Thanx in advance





_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke