access

oops.. excuse french..
i have a client that i have 2 db on server, but there are a lot of db, and
the security is present!. 1 is for live operation, 1 is for test. The
problem is that i cannot restore db on the test. But i have DBO and backup
operator access. So.. there is a way for me to restore the db and preserve
access for another db ?
thank!Hi,
Restore can be done by an user who got "dbcreator" fixed server role or
"sysadmin" fixed role.
How to assign "DBCREATOR" to a user:-
sp_addsrvrolemember <user>,'dbcreator'
Since you are doing the backup and restore in the same SQL Server machine,
the access previlages will not be a problem.
The access issues will only araise when you restore the database to a new
SQL Server, where your Ligin/User chain will be broken.
This case you can use the system procedure "sp_change_users_login" (refer
books online) to recreate the link.
Thanks
Hari
MCDBA
"Marty" <martin.foucault@.nospam.cgsi.qc.ca> wrote in message
news:#APmf3HPEHA.2740@.TK2MSFTNGP11.phx.gbl...
> oops.. excuse french..
> i have a client that i have 2 db on server, but there are a lot of db, and
> the security is present!. 1 is for live operation, 1 is for test. The
> problem is that i cannot restore db on the test. But i have DBO and
backup
> operator access. So.. there is a way for me to restore the db and
preserve
> access for another db ?
> thank!
>