SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Backup and Restore
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pvccaz
Yak Posting Veteran

USA
87 Posts

Posted - 04/16/2008 :  17:17:52  Show Profile  Reply with Quote
Hi,
Can a SQL server 2005 db be backed up and restored on a SQL Server 2008 db ?
Thanks

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 04/16/2008 :  17:22:19  Show Profile  Reply with Quote
Should be . Have you tried?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35953 Posts

Posted - 04/16/2008 :  17:52:58  Show Profile  Visit tkizer's Homepage  Reply with Quote
Yes it is possible. In fact, it's one of the easiest ways to upgrade your databases to the newer version.

It is not possible to backup on a higher version and restore on a lower version though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

pvccaz
Yak Posting Veteran

USA
87 Posts

Posted - 04/16/2008 :  18:11:58  Show Profile  Reply with Quote
I would be installing SQL Server 2008 in my machine and was collecting the inventory of databases. I need to try it tonight.
Go to Top of Page

pvccaz
Yak Posting Veteran

USA
87 Posts

Posted - 04/16/2008 :  18:13:26  Show Profile  Reply with Quote
Thanks Tara..
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/16/2008 :  22:48:58  Show Profile  Reply with Quote
Sql2k8 client tools don't like previous versions of sql, need to install them on machine without other version of sql.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000