Home Forums Article Discussions Article Discussions by Author Discuss content posted by Perry Whittle Using Disparate File Paths in SQL Server Database Mirroring RE: Using Disparate File Paths in SQL Server Database Mirroring

  • March 1, 2011 at 2:16 am

    #1292759

    dibbydibby (3/1/2011)

    nice article. one question?

    in your backup TLog statement did you mean to say....

    BACKUP DATABASE AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT

    ?

    Hi

    well spotted, no the backup and the restore statement should read

    BACKUP LOG

    RESTORE LOG

    Regards

    Perry

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉