Re: Migration ?

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0A3A75CF-166A-4BD7-88C9-1B55B519B9B7@xxxxxxxxxxxxxxxx
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@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









.

Relevant Pages

  • Re: Restore leaves DB in Loading state
    ... state of loading after the database restore - rather than in read only. ... > leave SQL restore hanging until it could write to that file. ... > I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: SQL restore sets password to Null
    ... Mapping Logins & SIDs after a Restore ... How to Resolve Permission Issues When a Database Is Moved Between SQL ... Looking for a SQL Server replication book? ... Steve wrote:> I have to move a sql database from one server to another - I backed up my> database in enterprise manager by selecting the database then clicking on the> backup database option. ...
    (microsoft.public.sqlserver.server)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Moving from SQL 2000 to SQL 2005 on another machine
    ... The easiest way is probably back up and restore. ... Move Databases Between Computers That Are Running SQL Server ... Moving SQL Server Databases to a New Location with Detach/Attach ... How to Resolve Permission Issues When a Database is Moved Between SQL ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)