Shrinking Transaction Logs - 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 2005 Forums

SQL Server Administration (2005)

Shrinking Transaction Logs

Author

Topic

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2008-06-12 : 01:06:53

Gurus
My logfile for a DB grows very rapidly and grows to more than 10gb every night,i have scheduled a job to shrink this file.
Now in job activity monitor it is showing me a yellow triangle in front of the job and status as successfull and it has ran only for 1 second
It is not shrinking the logs
I have transactional replication implemented
My point is when the logfile grows more than 10 gb the job does not shrink the logs
I have got around 8 steps in thos job and this is the 7th step

Please Advice
Thanks
Nitin

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-06-12 : 01:40:16

Try searching for the term, there are loads of posts and loads on google about this.

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2008-06-12 : 04:18:54

Thanks for the reply
"Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed"

I am getting thsi error message
Please Advice
Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-14 : 17:41:11

Don't run backup and shrink jobs at same time. By the way, what's db recovery model? Do you backup log if it's not in simple recovery model?

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-16 : 09:51:16

I would say if you have Tlog replication means it is full Recovery Mode. I am not sure how your transactions are going on. Check with if any open transaction are takeing the log space or not?. I would recommand you to take Full and Tlog backup and try to Shrink the Tlog only not the MDF.

Manoj
MCP, MCTS

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-16 : 13:45:46

nitin1353,

Do you realize you are creating a performance problem by shrinking the file down nightly?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-16 : 14:27:37

quote:
Originally posted by mdubey

I would say if you have Tlog replication means it is full Recovery Mode.

You can use simple recovery model with transactional replication.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources