Moving SQL 2005 to new machine

I'm looking for help moving SQL Server to a new machine. The current
SQL machine runs Windows Server 2003 ... we recently upgraded SQL on
this machine from SQL 2000 to SQL 2005 (dev). The new machine runs
Windows Server 2003 (x64) and has a fesh install of SQL 2005 (dev,
x64).
I haven't seen any How To docs specifically for SQL 2005 on this topic,
but the information for 2000 seemed relevant enough. Following advice
I've read, my plan was to back up master, model, and msdb; then retore
master and then model and msdb; and then do the same for my user dbs.
To this point, I have not been able to restore master. This is how
it's gone:
Fresh install
Run mssqlserver in single-user mode ... restore master ... goes to 100%
... then produces error
Log specifies it's looking for mssqlsystemresource.mdf in wrong path
Realize that 32-bit version of SQL is installed causing path difference
("\Program Files (x86)\")
Uninstall SQL and reinstall with SQL x64
Run mssqlserver in single-user mode ... restore master ... goes to 100%
... then produces error
Log specifies it's looking for mssqlsystemresource.mdf STILL in wrong
path (directory structure on new machine has "\MSSQL.1\MSSQL\" path
while old machine had just "\MSSQL\")
SQL Server no longer starts (log shows "Could not open file" for
aforementioned file)
I'd be very grateful for some input. (btw, I've also attempted a
detach/attach approach, but wasn't able to detach system dbs easily.)
Thanks in advance.
Hi
This article was updated to also cover SQL 2005:
http://support.microsoft.com/default...;en-us;Q314546
John
"matty2112@.hotmail.com" wrote:

> I'm looking for help moving SQL Server to a new machine. The current
> SQL machine runs Windows Server 2003 ... we recently upgraded SQL on
> this machine from SQL 2000 to SQL 2005 (dev). The new machine runs
> Windows Server 2003 (x64) and has a fesh install of SQL 2005 (dev,
> x64).
> I haven't seen any How To docs specifically for SQL 2005 on this topic,
> but the information for 2000 seemed relevant enough. Following advice
> I've read, my plan was to back up master, model, and msdb; then retore
> master and then model and msdb; and then do the same for my user dbs.
> To this point, I have not been able to restore master. This is how
> it's gone:
> Fresh install
> Run mssqlserver in single-user mode ... restore master ... goes to 100%
> ... then produces error
> Log specifies it's looking for mssqlsystemresource.mdf in wrong path
> Realize that 32-bit version of SQL is installed causing path difference
> ("\Program Files (x86)\")
> Uninstall SQL and reinstall with SQL x64
> Run mssqlserver in single-user mode ... restore master ... goes to 100%
> ... then produces error
> Log specifies it's looking for mssqlsystemresource.mdf STILL in wrong
> path (directory structure on new machine has "\MSSQL.1\MSSQL\" path
> while old machine had just "\MSSQL\")
> SQL Server no longer starts (log shows "Could not open file" for
> aforementioned file)
> I'd be very grateful for some input. (btw, I've also attempted a
> detach/attach approach, but wasn't able to detach system dbs easily.)
> Thanks in advance.
>
|||Hi
I noticed in another post that there may be an issue with the resource DB if
you move the master database.
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:CE7199E1-9C6D-412F-B83A-9D9F9756493B@.microsoft.com...[vbcol=seagreen]
> Hi
> This article was updated to also cover SQL 2005:
> http://support.microsoft.com/default...;en-us;Q314546
> John
> "matty2112@.hotmail.com" wrote: