Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1206
  • Last Modified:

Migrate SQL Server 2005 x86 to SQL Server 2008 x64 in default instance

Hi

We need to migrate a SQL Server 2005 x86, running in a Windows Server 2003 R2 x64 to a SQL Server 2008 x64.

Thanks in advance
0
zdavidlnx
Asked:
zdavidlnx
1 Solution
 
bcsqlCommented:
You want to change your default install of SQL 2005 from x32 to x64? you have reinstall.
1) detach databases - alluser dbs, model and msdb.
2) script logins - and jobs just in case
http://support.microsoft.com/kb/918992/
3) save db files and scripts
4) unintall SQL
5) install sql x64
6) attach dbs
7) re attached dbs once files are in correct place.
8) run scripts for logins and jobs if msdb is not reattached.
0
 
Marten RuneCommented:
Sorry bcsql, not entirely correct!
For clarification, step 3 for bcsqq does not include the system databases, So step 2 above is crucial since you must reinstall every job, all accounts and preserve their passwords.
Otherwise lbcsql is correct. But also check that all databases dont use custom extended stored procedures, or worse, is still using DTS packages (they can be run under sql2005, but not edited).
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now