Migration ?

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
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/featu...le.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/colu...rdatabases.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/scri...p?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/scri...tions/1598.asp Script
Roles and Permissions
Andrew J. Kelly SQL MVP
"Alex Anderson" <AlexAnderson@.discussions.microsoft.com> wrote in message
news:2DF0B36D-5B38-4BE1-A448-91CE4F33F5B2@.microsoft.com...
> 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
>
|||Actually, it can be done a bit more simply than that. You need to do the
following:
1. Configure the cluster
2. Install a SQL Server failover cluster instance
3. Backup the master database on your standalone and restore it to the
failover cluster instance
4. Backup msdb and restore it to the failover cluster instance
5. Move your databases using either a detach/attach or backup/restore
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:et0zGJSVGHA.6084@.TK2MSFTNGP14.phx.gbl...
> 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/featu...le.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/colu...rdatabases.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/scri...p?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/scri...tions/1598.asp Script
> Roles and Permissions
> --
> Andrew J. Kelly SQL MVP
>
> "Alex Anderson" <AlexAnderson@.discussions.microsoft.com> wrote in message
> news:2DF0B36D-5B38-4BE1-A448-91CE4F33F5B2@.microsoft.com...
>
|||Michael,
Moving the Master and MSDB database, what if the old server where those
databases are coming from are different builds? Will a restore on the SQL
2005 cluster allow this?
Thank you
Alex Anderson
"Michael Hotek" wrote:

> Actually, it can be done a bit more simply than that. You need to do the
> following:
> 1. Configure the cluster
> 2. Install a SQL Server failover cluster instance
> 3. Backup the master database on your standalone and restore it to the
> failover cluster instance
> 4. Backup msdb and restore it to the failover cluster instance
> 5. Move your databases using either a detach/attach or backup/restore
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:et0zGJSVGHA.6084@.TK2MSFTNGP14.phx.gbl...
>
>
|||During a restore, all of the metadata is upgraded. So, yes, it does work.
You will obviously want to test it before doing it in production.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Alex Anderson" <AlexAnderson@.discussions.microsoft.com> wrote in message
news:0A3A75CF-166A-4BD7-88C9-1B55B519B9B7@.microsoft.com...[vbcol=seagreen]
> Michael,
> Moving the Master and MSDB database, what if the old server where those
> databases are coming from are different builds? Will a restore on the SQL
> 2005 cluster allow this?
> Thank you
> Alex Anderson
>
> "Michael Hotek" wrote:
|||Michael,
I've tried every way I can think of trying to restore the master database.
I fail every time because it's complaining about the build numbers being
different. Is there something I can need to check to override this?
Thank you
Alex Anderson
"Michael Hotek" wrote:

> During a restore, all of the metadata is upgraded. So, yes, it does work.
> You will obviously want to test it before doing it in production.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Alex Anderson" <AlexAnderson@.discussions.microsoft.com> wrote in message
> news:0A3A75CF-166A-4BD7-88C9-1B55B519B9B7@.microsoft.com...
>
>