470,596 Members | 1,211 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

my Log file size is 10GB....

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
Jun 29 '07 #1
2 1852
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
Jun 29 '07 #2
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
Jun 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Tom | last post: by
11 posts views Thread by Stephan Steiner | last post: by
26 posts views Thread by Ed L. | last post: by
40 posts views Thread by axwack | last post: by
6 posts views Thread by Martin | last post: by
6 posts views Thread by =?Utf-8?B?VGhvbWFzWg==?= | last post: by
3 posts views Thread by Paul Lemelle | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.