+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1
    M0MST
    Guest

    SQL Server 2008 R2 move from SQL Server 2005 Free

    Hi All.

    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

    Thanks

  2. #2

    Join Date
    Apr 2006
    Posts
    390
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    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.

  3. Thanks to theriver from:




SHARE:
+ Post New Thread

Similar Threads

  1. SQL Server 2008 R2 enterprise evaluation edition
    By sippo in forum Windows Server 2008 R2
    Replies: 13
    Last Post: 17th May 2012, 03:47 PM
  2. Replies: 21
    Last Post: 18th January 2011, 01:20 PM
  3. Setting up Moodle on Server 2008 R2 IIS 7 SQL
    By thesk8rjesus in forum Web Development
    Replies: 2
    Last Post: 8th June 2010, 02:53 PM
  4. Can i run Server 2008 R2 64bit on x86 server
    By duxbuz in forum Hardware
    Replies: 10
    Last Post: 24th February 2010, 12:34 AM
  5. Moving from SQL Server 2005 to 2008
    By speckytecky in forum MIS Systems
    Replies: 19
    Last Post: 9th July 2009, 04:34 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •