Solved

Dump tran DatabaseName with no_log

Posted on 2010-09-01
3
1,207 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
  • 2
3 Comments
 
LVL 60

Accepted Solution

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

Expert Comment

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

Author Closing Comment

by:techzone12
Comment Utility
Thanks
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

763 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

6 Experts available now in Live!

Get 1:1 Help Now