Downsizing Transaction Log - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Downsizing Transaction Log

Author

Topic

raja
Starting Member

18 Posts

Posted - 2005-02-17 : 03:39:27

Is it Possible to downsize the space allocated to the transaction log file ???

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-17 : 13:48:32

Yes. What is your database recovery model set to? If FULL, are you performing regular tlog backups?

Tara

raja
Starting Member

18 Posts

Posted - 2005-02-17 : 23:38:47

thanks i got it

dbcc shrinkfile(logfilename)
if the above doen't work then
backup transaction log
and again run shrink file

raja
Starting Member

18 Posts

Posted - 2005-02-17 : 23:39:47

thanks i got it

dbcc shrinkfile(logfilename)
if the above doen't work then
backup transaction log
and again run shrink file

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-19 : 02:19:15

So your recovery is set to FULL and you aren't performing regular tlog backups? If that is the case, then just change it to SIMPLE so this doesn't happen anymore.

Tara

raja
Starting Member

18 Posts

Posted - 2005-02-21 : 03:51:09

Thank u Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources