Re: Migration ?
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Fri, 31 Mar 2006 19:21:31 -0500
You have to move the databases to the new server individually. Most of
these were written for 2000 but still apply to 2005.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's 2000
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://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
Moving Users
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
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scripts/contributions/1598.asp Script
Roles and Permissions
--
Andrew J. Kelly SQL MVP
"Alex Anderson" <AlexAnderson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2DF0B36D-5B38-4BE1-A448-91CE4F33F5B2@xxxxxxxxxxxxxxxx
Hello,
I currently have a SQL 2000 SP3 STD running in my org, I want to move it's
contents to a clustered (two node) system running SQL 2005 STD edition.
Is
it possible to move the entire contents of my old SQL environment to the
new
environment? I would like to preserve user logins and the current
instance
name of my old server. I know it might require me renaming the old SQL
server name when I get to that point. If someone could give me some tips
on
how (or if it's even possible) to do this I would be highly greatful.
Thank you
Alex Anderson
.
- Follow-Ups:
- Re: Migration ?
- From: Michael Hotek
- Re: Migration ?
- Prev by Date: Re: Service Pack 4 resetting cluster resource settings (affect group)
- Next by Date: Re: SQL Server Cluster Install Fails
- Previous by thread: Re: Service Pack 4 resetting cluster resource settings (affect group)
- Next by thread: Re: Migration ?
- Index(es):
Relevant Pages
|
Loading
