Friday, March 9, 2012

Logins (Sessions)

Hi !
Is it possible to backup (and restore) logins (no database users)? I've this
doubt because if I backup a db (Db1) from SQLserver1 and then I restore it
in other server (SQLserver2) without all logins than SQLserver1, results in
a problem with user access
to database.
Any comments? thanks in advance.Have a look here:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Han" <Han@.discussions.microsoft.com> wrote in message
news:9245067A-245E-41A4-97F8-4FB7F51A03CD@.microsoft.com...
> Hi !
> Is it possible to backup (and restore) logins (no database users)? I've
this doubt because if I backup a db (Db1) from SQLserver1 and then I restore
it in other server (SQLserver2) without all logins than SQLserver1, results
in a problem with user access to database.
> Any comments? thanks in advance.
>

No comments:

Post a Comment