Solved

Dump Transaction Log in SS2008?

Posted on 2009-04-03
2
2,575 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

803 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