Post reply

Resync Dbo

  • March 24, 2005 at 8:53 am

    #87875

    How do i resync dbo?

    We restored a database on the server and lost the sa login for Dbo. This has caused the Transaction Log Backups to fail.

    Thanks

    ps: I found code that will resync all other users but not Dbo

  • March 24, 2005 at 8:58 am

    #548780

    have you try to reset dbo first to sa and then back to the old dbo's login?  This usually works for me.

    exec sp_changedbowner 'sa'

    exec sp_changedbowner 'userlogin'

     

     

    mom

  • March 24, 2005 at 9:02 am

    #548784

    That worked.

    Thank you.

  • March 24, 2005 at 9:35 am

    #548797

    This should not affect the transaction log backups to fail. sa is a member of sysadmin group and he has permissions to all the database. You might want to take a look are your recovery model. Verify that it is set to full.

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

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