Re: Moving a Database to another Server
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/30/04
- Next message: Uri Dimant: "Re: how can i move a local directory with all files within a procedure"
- Previous message: Dan Guzman: "Re: Ownership Chain Issue"
- In reply to: dibetage: "Moving a Database to another Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 30 Nov 2004 09:16:53 -0500
These should be helpful, especially the ones about Logins etc.
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 MVP "dibetage" <dibetage@discussions.microsoft.com> wrote in message news:4944B79D-CFA7-47C8-B53F-1781A4BA422F@microsoft.com... > How can i move a Database from one to another 2 SQL Server 7.0 SP2 > I already backed up the Database and restored it on the new Server but > now i have the Error Message that the role is alreasdy in the Database , > but there are no user at all created. > > >
- Next message: Uri Dimant: "Re: how can i move a local directory with all files within a procedure"
- Previous message: Dan Guzman: "Re: Ownership Chain Issue"
- In reply to: dibetage: "Moving a Database to another Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
