Team,
I have a 21 gig Transaction Log and need to reduce the size. Can someone
tell me the best way to reduce this? We are using SQL7 and my knowledge of
it is limited since it was forced upon me. Thanks for any help you can
provide.
ChrisRefer to this KB articles.
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
--
-Vishal
"Chris S" <csemones@.nuvox*nospam*_.com> wrote in message
news:vks4vqkm56o5f9@.corp.supernews.com...
> Team,
> I have a 21 gig Transaction Log and need to reduce the size. Can someone
> tell me the best way to reduce this? We are using SQL7 and my knowledge
of
> it is limited since it was forced upon me. Thanks for any help you can
> provide.
> Chris
>|||More info on this...I do a full backup every night and tried doing a log
backup today to see if it would reduce it but it did now work. The database
size is about 120 meg.
Thanks agian,
Chris
"Chris S" <csemones@.nuvox*nospam*_.com> wrote in message
news:vks4vqkm56o5f9@.corp.supernews.com...
> Team,
> I have a 21 gig Transaction Log and need to reduce the size. Can someone
> tell me the best way to reduce this? We are using SQL7 and my knowledge
of
> it is limited since it was forced upon me. Thanks for any help you can
> provide.
> Chris
>|||SQL Server can not truncte the log if the active portion of the transaction
log contains transactions that are still running and have not yet
completed.Backup log command does not physically shrink the size of the
transaction log file of the database. When old log records no longer
necessary for recovering or restoring a database they are deleted to make
way for new log records.This process of deleting these log records is
truncating the log.
To physically reduce the size of the tran. log you will have to run dbcc
shrinkfile.
You have various options to keep transaction log size manageable:
1.Keep taking transaction log backups at particular intervals this will help
you keep optimal transaction log size.
When SQL Server finishes backing up the transaction log, it automatically
truncates the inactive portion of the transaction log.
2.Keep transaction size as small as possible.
--
-Vishal
"Chris S" <csemones@.nuvox*nospam*_.com> wrote in message
news:vks5b26nrik79a@.corp.supernews.com...
> More info on this...I do a full backup every night and tried doing a log
> backup today to see if it would reduce it but it did now work. The
database
> size is about 120 meg.
> Thanks agian,
> Chris
>
> "Chris S" <csemones@.nuvox*nospam*_.com> wrote in message
> news:vks4vqkm56o5f9@.corp.supernews.com...
> > Team,
> > I have a 21 gig Transaction Log and need to reduce the size. Can
someone
> > tell me the best way to reduce this? We are using SQL7 and my knowledge
> of
> > it is limited since it was forced upon me. Thanks for any help you can
> > provide.
> > Chris
> >
> >
>
No comments:
Post a Comment