RE: Moving databases to new server
From: John Bandettini (JohnBandettini_at_discussions.microsoft.com)
Date: 02/01/05
- Next message: TieTo: "[QA] Run 1 query on multiple db's"
- Previous message: seth: "Re: SOX and Auditing"
- In reply to: nivek: "Moving databases to new server"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Feb 2005 07:53:02 -0800
Try this lot
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
Regards
John
"nivek" wrote:
> Does anyone have a link to a good article about moving logins and databases
> to a new sql server? (2000 to 2000). Any input would be greatly
> appreciated.
>
>
>
- Next message: TieTo: "[QA] Run 1 query on multiple db's"
- Previous message: seth: "Re: SOX and Auditing"
- In reply to: nivek: "Moving databases to new server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|