Re: Disaster Recovery
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/26/04
- Next message: Eduardo Quintana: "RE: Installing SQL 2K Std on Windows 2003 Std"
- Previous message: Rand Boyd [MSFT]: "RE: Can't Access Database from Win XP client"
- In reply to: Rob Smeets: "Disaster Recovery"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 26 May 2004 10:01:42 -0400
Depends on what type they are and how they the db's were added. You may not
have to do a thing or you may need to use sp_change_users_login. These
should help:
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/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
-- Andrew J. Kelly SQL Server MVP "Rob Smeets" <anonymous@discussions.microsoft.com> wrote in message news:9F4BDA8F-BA6C-443F-AC36-91C6F9F273D6@microsoft.com... > Hi i'm writing a disaster recovery plan. > I've read a lot but one answer i cannot find. > > After i restored the master, msdb and user databases, do i have to drop users and logins and add them again, or am i done after the restore? > > Thanks for the information! > > with kind regards, > > Rob Smeets
- Next message: Eduardo Quintana: "RE: Installing SQL 2K Std on Windows 2003 Std"
- Previous message: Rand Boyd [MSFT]: "RE: Can't Access Database from Win XP client"
- In reply to: Rob Smeets: "Disaster Recovery"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
