[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

Offline migration MSDE on SBS 2003 x86 to sql 2008

I need to migrate an msde database with sp4 from an SBS 2003 standard box.to a new sbs 2011 premium box without having the old server and new server connected in migration mode.

Is this doable and if so, how?

Thanks
0
jyeager28
Asked:
jyeager28
  • 3
  • 2
3 Solutions
 
jyeager28Author Commented:
I need to migrate an msde database with sp4 from an SBS 2003 standard box.to a new sbs 2011 premium box without having the old server and new server connected in migration mode.

Is this doable and if so, how?

Thanks
0
 
Anthony PerkinsCommented:
Try copying over the old data and log files and attaching them to the new server.
Another option is to restore a full SQL backup from the old database to the new SQL Server.
0
 
jyeager28Author Commented:
Will that work with becuase of the different versions of SQL???
0
 
Anthony PerkinsCommented:
You can certainly attach or restore an older version of the database to a newer one. The reverse is not possible.
0
 
jyeager28Author Commented:
All comments were useful
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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