database back up

Question

hi,

Now am using windows 2008 x32 bit standard version,  so am going to move or upgrate windows 2008R2 x64bit.

it's possible to work well all database in this new database?

i can only back up 2008 x32 bit (.mdf and .ldf) file only

Answer 1

Yes it fine to upgrade...assume sql server backup files as normal Data file and they can be successfully backup and restore between the 32 bit and 64 bit machine as well as sql server instance with 32 bit and 64 bit version.

No special procedure is required other than regular backup - restore process. 

---

Regards Harsh

Answer 2

hi,

Now am using windows 2008 x32 bit standard version,  so am going to move or upgrate windows 2008R2 x64bit.

it's possible to work well all database in this new database?

i can only back up 2008 x32 bit (.mdf and .ldf) file only

On disk file storage format for 32 bit and 64 bit are same so there would be no issue in restoring backup of SQL server taken on 32 bit version of windows to 64 bit version of windows .

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

My TechNet Wiki Articles