Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
markmg
Starting Member
4 Posts |
 Posted - 2009-09-16 : 06:24:16
|
| Is there a easy way to export a server running SQL 2008 x86 to a new/other clean installed SQL server 2008 X64 ?if so, what steps should i take ? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-09-16 : 07:41:10
|
| There are numerous ways...the easiest would be to do a simple backup/restore but that might cause some downtime. You could also do log shipping, mirroring, replication... We really need to know your requirements before making any specific recommendations.- Lumbago |
 |
|
|
markmg
Starting Member
4 Posts |
Posted - 2009-09-17 : 11:12:32
|
| Ok I will try, I hope you can understand it. i have a old server running sql server 2000, i am trying to export it to a new sbs 2008 server. Because its an old server and has problems i don’t want to update it in live production.so my idea, was to setup a virtual server with sql 2000 update it to SQL server 2008 x86, witch works, and then export it to the SBS 2008 x64 server. The software that uses the database can install fine on a 32bit server and supports sql 20008, but the software installer dosnt instal on a 64bit system for some strange reason. It only creates the database, nothing else is installed that can’t be setup manualy.But that is where i get stuck, i am lost how i can completly backup the 32bit database and export it to the new 64bit server.i tryed to manually backup and restore in the sql management studio but i get errors its missing other databases.i cant find a option to completely backup and restore and wil it even work 32 to 64 bit? Downtime is no problem, i can do it at night, and the database is very smal about 300Mb |
|
|
|
|
|
|
|
|
Migrate x86 SQL2008 to x64 SQL 2008