|
Home > Archive > MS SQL Server > March 2005 > Restoring a copy of a database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Restoring a copy of a database
|
|
| Russell 2005-03-31, 8:01 pm |
| If restore a backup of a database to a database with a different name and
owner, do I have to recreate the views and re-apply permissions to the tables
etc. As I far as I can see all the views are owned by the dbo, but the actual
database owner differs. From a SQL Server point of view I can look at the
database and all seems ok and I can run select's against tables and views.
| |
| Tibor Karaszi 2005-03-31, 8:01 pm |
| You can change owner to a proper login using sp_changedbowner. And you can sync logins using
sp_change_users_logi
n.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
http://www.sqlug.se/
"Russell" <Russell@discussions.microsoft.com> wrote in message
news:3D20C46F-1DF4-4E28-BD69- 014ED8EFA270@microso
ft.com...
> If restore a backup of a database to a database with a different name and
> owner, do I have to recreate the views and re-apply permissions to the tables
> etc. As I far as I can see all the views are owned by the dbo, but the actual
> database owner differs. From a SQL Server point of view I can look at the
> database and all seems ok and I can run select's against tables and views.
|
|
|
|
|