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 |
|
drsloat
Starting Member
45 Posts |
 Posted - 2008-12-17 : 15:09:54
|
| I am upgrading from a 32 bit sql server to a new 64 bit server. I will be moving the same disk from the 32 bit machine to the new 64 bit machine.Can I just detach the databaase, move the disk to the new server, and then attach the files to a new database? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 15:25:06
|
| Yes but make sure you backup all databases before you do that. |
 |
|
|
ckleong
Starting Member
17 Posts |
Posted - 2008-12-29 : 17:51:04
|
| Hi sodeep, Is master and msdb require to restore during the upgrading process? |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-12-30 : 20:53:43
|
| No you don't need to restore system database (master,msdb). |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-31 : 22:05:28
|
quote:
Originally posted by ckleong
Hi sodeep, Is master and msdb require to restore during the upgrading process?
Well to resolve logins,jobs and packages issues you can do that. Search for Moving system databases in Booksonline. |
|
|
|
|
|
|
Upgrade to 64 Bit Server