Home Forums Testing Center Question of the Day (QOD) Question of the Day for 30 Mar 2007 RE: Question of the Day for 30 Mar 2007

  • March 30, 2007 at 1:42 am

    #697810

    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/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/