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

SQL Server Administration (2008)

Truncate Transaction Log

Author

Topic

gavinjb
Starting Member

34 Posts

Posted - 2009-11-13 : 09:47:07

Hi,

I am trying to find away to truncate the Transaction Logs of a SQL 2008 Database. My problem is I need to have the recovery model set to Full as the database in question has mirroring enabled

in SQL 2005 I would have simply used


backup log [dbName]
with TRUNCATE_ONLY
dbcc shrinkfile(dbLogName_log, 40)

But as SQL 2008 doesnt support with TRUNCATE_ONLY I cant work out a simple solution for this, currently are backups are full nightly backups.

Thanks,

Gavin,

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-13 : 09:51:24

start doing transaction log backups

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-11-13 : 14:54:47

Even if 2008 allowed TRUNCATE_ONLY, if you did that you'd break mirroring.

Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources