October 6, 2010 at 5:05 am
In SQL Server 2005 I used to
dump tran MyDatabaseName with no_log
DBCC SHRINKDATABASE ('MyDatabaseName')
This syntax does not work in SQL server 2008.
What is the correct syntax
Thanks
October 6, 2010 at 5:13 am
The correct syntax aside, you should not be dumping the transactions at all. Run log backups if you need point in time recovery, otherwise switch to simple recovery model.
Take a look through this article - http://www.sqlservercentral.com/articles/64582/
Also, why are you shrinking your database? Do you know what it's doing to your index fragmentation.
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 5:36 am
Thanks, I have learned something new today
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply