Size of Transaction Log file is too big

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 2008 Forums

SQL Server Administration (2008)

Size of Transaction Log file is too big

Author

Topic

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2012-01-23 : 11:28:18

Hi,

I have a transaction log file size of around 30GB and the free space is 99%. How can I reduce the File size?

Thanks,
Sandesh

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-23 : 11:40:48

Before you do that... How large does the log need to be for regular database activity (including index rebuilds)?

--
Gail Shaw
SQL Server MVP

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2012-01-23 : 12:13:23

around 3GB.

Thanks,
Sandesh

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-23 : 12:40:50

So what caused the log to grow to 30GB?

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources