Windows Server 2008 R2 Thread, SQL Server 2008 R2 move from SQL Server 2005 Free in Technical; Hi All.
My experience of SQL Server is limited. However I am just installing SQL server 2008 R2 ready for ...
15th January 2013, 10:28 AM #1
- Rep Power
SQL Server 2008 R2 move from SQL Server 2005 Free
My experience of SQL Server is limited. However I am just installing SQL server 2008 R2 ready for our new print management software. What I am trying to understand is how to "migrate" an existing database in 2005 over to the new installation of 2008. Reason for doing this is I have a much more robust backup in place for 2008 R2 and the 2005 free version is very limited in that sense.
Any pointers and tips would be great
IDG Tech News
15th January 2013, 11:26 AM #2
If you're luck's in then you should be able to just backup the SQL 2005 database and restore it to the 2008r2 server. Check with your app vendor that they support the newer platform though.
Thanks to theriver from:
M0MST (15th January 2013)
By sippo in forum Windows Server 2008 R2
Last Post: 17th May 2012, 03:47 PM
By dtakias in forum MIS Systems
Last Post: 18th January 2011, 01:20 PM
By thesk8rjesus in forum Web Development
Last Post: 8th June 2010, 02:53 PM
By duxbuz in forum Hardware
Last Post: 24th February 2010, 12:34 AM
By speckytecky in forum MIS Systems
Last Post: 9th July 2009, 04:34 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)