Post reply

LOG Recovery

  • March 12, 2004 at 4:03 pm

    #161238

    RESTORE LOG mydb

    FROM DISK = 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\BACKUP\mydb.BAK'

    WITH

    DBO_ONLY,

    STANDBY = 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\data\undo_mydb.ldf'

    WAITFOR DELAY '00:00:05'

    EXEC sp_dboption 'mydb', 'single user', true

     

    Server: Msg 4306, Level 16, State 1, Line 1

    The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.

    Server: Msg 3013, Level 16, State 1, Line 1

    RESTORE LOG is terminating abnormally.

    Server: Msg 5066, Level 16, State 1, Procedure sp_dboption, Line 423

    Database options single user and dbo use only cannot be set at the same time.

     

    Im not so conserned with the second message, but why the first??

  • March 12, 2004 at 5:24 pm

    #498650

    This isn't an answer to your question, but ... is this SQL 7?  I'm asking because I thought the DBO_ONLY option had been replaced by RESTRICTED_USER.

    Chris

  • March 16, 2004 at 8:11 am

    #498957

    Hi Chris, no you can still use DBO_ONLY in 2000. I forgot to reply to my own post when I figured out that I forgot to include With NORECOVERY on my first restore.

  • March 16, 2004 at 9:58 am

    #498985

    Glad you got it working!  And thanks for the info that DBO_ONLY still works in SQL2K - I didn't know that.

    Cheers,

    Chris

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply