• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

How to backup database from WinXP and restore in Windows 7 64bit.

Hi,

Im running windows XP 32bit professional with sql server 2005 express as a database for my Bentley select server. I'm planning to upgrade my server to windows 7 64bit pro. I need to backup my database from winXP and restore in windows 7 64bit. What is the best way to do it? Thanks,

Jess
0
JessIT2013
Asked:
JessIT2013
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you "simply" backup the databases on the source server, and restore them on the target server. the 32 vs 64 bit does not impact on the backup/restore functionality.

there are other things to check, see here:
http://technet.microsoft.com/en-us/library/ms186390.aspx
0
 
JessIT2013Author Commented:
Thanks but my new server has sql server 2008 r2 express?

Jess
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, the restore is backwards compatible, sql 2005 backups can be restored on sql 2008 instances.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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