Thursday, March 29, 2012

How restore database on other server with rights to all objects

Can you help me?
Thanks
AlinaAlina
Look at RESTORE command in the BOL
Also you will have to move all logins from the OLD server to the NEW one.
"Alina Górna" <a.gorna@.icnet.pl> wrote in message
news:1091512370.614501@.d1.icnet...
> Can you help me?
> Thanks
> Alina
>|||Hi,
You could see the below links to restore and map the users.
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Thanks
Hari
MCDBA
"Alina Górna" <a.gorna@.icnet.pl> wrote in message
news:1091512370.614501@.d1.icnet...
> Can you help me?
> Thanks
> Alina
>

No comments:

Post a Comment