SQL Server Forums - Backup and Restore

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

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

Topic

pvccaz
Yak Posting Veteran

USA
82 Posts

Posted - 04/16/2008 : 17:17:52

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
7173 Posts

Posted - 04/16/2008 : 17:22:19

Should be . Have you tried?

tkizer
Almighty SQL Goddess

USA
35007 Posts

Posted - 04/16/2008 : 17:52:58

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/

pvccaz
Yak Posting Veteran

USA
82 Posts

Posted - 04/16/2008 : 18:11:58

I would be installing SQL Server 2008 in my machine and was collecting the inventory of databases. I need to try it tonight.

pvccaz
Yak Posting Veteran

USA
82 Posts

Posted - 04/16/2008 : 18:13:26

Thanks Tara..

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/16/2008 : 22:48:58

Sql2k8 client tools don't like previous versions of sql, need to install them on machine without other version of sql.