Question of the Day for 30 Mar 2007

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Testing Center » Question of the Day (QOD) » Question of the Day for 30 Mar 2007

Question of the Day for 30 Mar 2007

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Wednesday, March 21, 2007 8:05 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the Question of the Day for 30 Mar 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=997.

Post #353124

Hugo Kornelis

Posted Friday, March 30, 2007 1:42 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:44 PM
Points: 5,297, Visits: 7,239

For completeness' sake, it should be added that:

1. It's actually the DUMP TRANSACTION command that backups the transaction log. DUMP DATABASE backups the database.

2. The DUMP command is deprecated.

3. SQL Server also has some new DUMP commands: DUMP CERTIFICATE, DUMP MASTER KEY, and DUMP SERVICE MASTER KEY. All these commands export a key to a file.

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #354983

James Rochez

Posted Friday, March 30, 2007 9:18 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 9:07 PM
Points: 1,529, Visits: 824

The reference given in the explanation is actually for the CONTINUE statement. Try the following instead:

http://msdn2.microsoft.com/en-us/library/ms187315.aspx

Post #355065

kapil_kk

Posted Tuesday, November 27, 2012 5:25 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:11 AM
Points: 1,130, Visits: 1,278

got to know about DUMP today

Post #1389120

« Prev Topic | Next Topic »

Permissions