Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Naveed Amir
Starting Member
8 Posts |
 Posted - 2013-04-09 : 03:48:24
|
| Dear Team, Can we restore SQL Server 2008 R2 database in Sql server 2005 through DB back up. If not is their any other work arround to restore in SQL server 2005.Naveed AmirIT Specialist |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-09 : 04:24:17
|
| Nope you cantYou cant restore a backup created in later version to earlier version serverYou can do inverse though ie creating a backup in earlier server like 2005 and then restoring to 2008 R2 box due to backward compatibility------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-09 : 04:24:42
|
| In your case only workaround is to upgrade 2005 to 2008 R2------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Naveed Amir
Starting Member
8 Posts |
Posted - 2013-04-09 : 09:23:59
|
| thanks ...Naveed AmirIT Specialist |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-09 : 14:46:23
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-04-10 : 01:52:10
|
| If upgrading from SQL Server 2005 to sql server 2008 is not possible - one option is to to script out objects and manually transfer data.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Database backward Compatibility!