Post reply

Change user of Read-Only database

  • September 15, 2014 at 9:56 am

    #299433

    Hello, I have a database that is involved in log shipping. It is on the secondary server, so it is in Standby/Read-Only mode. I would like to change the owner but am getting an error because the database is Read-Only.

    So do I have to break log shipping to change the owner or is there another way?

    Thank you,

    djj

  • September 15, 2014 at 9:59 am

    #1745526

    I can't think of any way you could change the owner and carry on with log shipping afterwards. The database will always have to have the same owner as it had just after your restored it, as far as I can see.

    John

  • September 15, 2014 at 10:03 am

    #1745529

    Thank you. I was afraid of that. I must have goofed during the restore and have my user as the owner not the admin created for the purpose.

    However, the master database has the correct owner.

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

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