Re: Migration ?
- From: "Michael Hotek" <mike@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 1 Apr 2006 22:50:43 -0600
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@xxxxxxxxxxxx> wrote in message
news:et0zGJSVGHA.6084@xxxxxxxxxxxxxxxxxxxxxxx
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: Alex Anderson
- Re: Migration ?
- References:
- Re: Migration ?
- From: Andrew J. Kelly
- Re: Migration ?
- Prev by Date: Re: Migration from SQL2000 to Cluster SQL2005 ?
- Next by Date: Re: Evict cluster node BEFORE running SQL setup
- Previous by thread: Re: Migration ?
- Next by thread: Re: Migration ?
- Index(es):
Relevant Pages
|
Loading
