• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2639
  • Last Modified:

Dump Transaction Log in SS2008?

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
mtuepker
Asked:
mtuepker
1 Solution
 
Shyam_SarafCommented:
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
 
mtuepkerAuthor Commented:
Perfect, Thanks.  Now to get our vendor to implement the changes in their install file!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now