can you any body tell me the how to decrease the logfile

Question Posted / prasadhari_m@yahoo.com

4 Answers
4840 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can you any body tell me the how to decrease the logfile..

Answer / vani

The log files must be backed up, so that the inactive log
records are truncated after every checkpoint thus freeing
up the logspace to be reused.

Schrink your database (Database-All task-Schrink database)
leave 10% free and the size of the log will schrink

Is This Answer Correct ?

1 Yes

0 No

can you any body tell me the how to decrease the logfile..

Answer / prasadhari_m@yahoo.com

take a backup using this command
backup log dbname with no_log

Is This Answer Correct ?

1 Yes

0 No

can you any body tell me the how to decrease the logfile..

Answer / lekhrajdeshmukh

We have to decrease the size of a log file by shrinking the
large file.

Syntex:-
DBCC dbname
go
DBCC shrinkfile(filename,sizevalue)
go.
for eg I want to shrink the filename data of databse userdb
to 7 mb.

dbcc userdb
dbcc shrinkfile(data,7)

Is This Answer Correct ?

0 Yes

0 No

can you any body tell me the how to decrease the logfile..

Answer / rahul

dbcc shrinkfile ( 'databasename', 'size to be shrinked upto
(in mb)')

Is This Answer Correct ?

0 Yes

0 No

Post New Answer