RE: Moving databases to new server

From: John Bandettini (JohnBandettini_at_discussions.microsoft.com)
Date: 02/01/05


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.
>
>
>



Relevant Pages

  • Re: Error running Copy Database Wizard (CDW)
    ... I am not sure why the error but why not simply do a restore or an attach ... Issues When a Database Is Moved Between SQL Servers ... > I am using the Copy Database Wizard to copy a database from one SQL ...
    (microsoft.public.sqlserver.tools)
  • Re: Setting up Test of database using backup/restore
    ... Thanks Andrew...I have seen the references in your other posts but I just ... will the two be in production at one time, ... > I would go for the restore of the latest FULL backups as the least ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)
  • Re: How to cpy logins from one Server to another
    ... > to a New Location with Detach/Attach ... > Passwords Between SQL Servers ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.security)
  • Re: question -- copy database?
    ... > Passwords Between SQL Servers ... > Issues When a Database Is Moved Between SQL Servers ... and have SS recognize the database? ...
    (microsoft.public.sqlserver.dts)
  • Re: migrating sql server from one computer to an other
    ... Moving SQL Server Databases to a New Location with Detach/Attach ... Mapping Logins & SIDs after a Restore ...
    (microsoft.public.sqlserver.server)

Loading