Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question of the Day for 30 Mar 2007 Expand / Collapse
Author
Message
Posted Wednesday, March 21, 2007 8:05 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, 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
Posted Friday, March 30, 2007 1:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:23 AM
Points: 5,998, Visits: 8,259

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
Posted Friday, March 30, 2007 9:18 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

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
Posted Tuesday, November 27, 2012 5:25 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:27 AM
Points: 1,890, Visits: 2,329
got to know about DUMP today


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1389120
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse