Solved

Dump Transaction Log in SS2008?

Posted on 2009-04-03
2
2,572 Views
Last Modified: 2012-05-06
So we have some software that runs off of SQL Server.  One of the updates has the following command:

dump transaction [DYNAMICS] with no_log

which worked fine in SQL Server 2000.  Does anyone know the equivalent in 2008?  When run now, I receive the following error:
Incorrect syntax near the keyword 'transaction'.
0
Comment
Question by:mtuepker
2 Comments
 
LVL 1

Accepted Solution

by:
Shyam_Saraf earned 500 total points
ID: 24062969
try this alternates fom Enterprise manager
      1. set the database to simple recovery model
      2. Shrink the file
      3 .Set back to Full (If required). ie. If you are not taking TL backup let it be in Simple recovery model only



 
0
 
LVL 1

Author Comment

by:mtuepker
ID: 24063003
Perfect, Thanks.  Now to get our vendor to implement the changes in their install file!
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now