my Log file size is 10GB....

[alagariya]

SQL log file size on 22/06/2007 shown as 10GB...now its showing as 20GB....but when taking backup...the backup file size is 4MB only......when restoring, it showing msg that there is no space, due to the file size of 10 GB..... any body can tell the solution for this?......plz urgent

[bharadwaj]

hi,
run the following commands.

1.dbcc sqlperf(logspace) . in the out put u can get the log size.
2.backup log <dbname> with truncate_only
3.dbcc shrinkdatabase(dbname,10)
4.dbcc shrinkfile(2) (2 means log file)

after these steps over execute step 1 again after 10 or 20 mins ,let me know the log size growth.
good luck
Bharat

[alagariya]

hi,
run the following commands.

1.dbcc sqlperf(logspace) . in the out put u can get the log size.
2.backup log <dbname> with truncate_only
3.dbcc shrinkdatabase(dbname,10)
4.dbcc shrinkfile(2) (2 means log file)

after these steps over execute step 1 again after 10 or 20 mins ,let me know the log size growth.
good luck
Bharat

=============

Hi Bharadwaj.
Thank you for your quickest solution. I will try and get back to you.

Good day.
Alagar