Solved

Dump tran DatabaseName with no_log

Posted on 2010-09-01
3
1,214 Views
Last Modified: 2012-05-10
I have some legacy SQL code that used to run on a SQL 7 system. Now client upgraded the hardware to SQL 2008. The SQL code has this line:

Dump tran DatabaseName with no_log
go

/* do some inserts..*/
go

Dump tran DatabaseName with no_log

I am reading that Dump tran is not supported in SQL 2008. What should I replace it with?



0
Comment
Question by:techzone12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 33579642
You don't need to run it at all....
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 33579644
btw...that TYPE of functionality isn't present in 2008
0
 

Author Closing Comment

by:techzone12
ID: 33579782
Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

749 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