February 4, 2010 at 4:52 pm
I do a LOT of backup/restore, moving DB's between different computers. Usually after I do a Restore the DB Owner on the restored DB is blank, and I have to assign it in order to run the application. Every once in a while the DB owner after the Restore operation is already assigned ... and the app won't run. When I try the Restore operation again (making sure that Overwrite is selected) same behavior.
What's going wrong with the Restore operation in these isolated cases? Thx in advance ....
February 5, 2010 at 6:41 am
the restore would assign as owner whoever ran the restore command.
If that is not what you want use sp_changedbowner to set it after the restore completes
---------------------------------------------------------------------
February 5, 2010 at 7:03 am
Usually when I restore and check the DB Owner it's blank, not the ID of the user who performed the Restore. The problem occurs when I check the properties of the restored DB and it's NOT blank ... I'm not sure why that is ...
February 5, 2010 at 7:06 am
probably blank because SQL cannot resolve ID of whoever ran restore, either way sp_changedbowner should fix it.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply