Can we Restore the backup of 2008 in 2005 server

Dear All,

I Have an Issue in restoration , I have installed the SQL Server 2008 and due to Space issue we take Compress backup (*.CNB Format) , one of our Client have SQL Server 2005 Version and he need the backup file for restoration for some testing purpuse.

So Can We Restore Compress Backup in SQL Server 2005 .

Thanks Basit Khan

more ▼

asked Aug 15, 2010 at 10:31 PM in Default

avatar image

basit 1
509 57 65 91

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

No, You can't Restore the backup of higher versions of sql server to the lower version. Better generate the DB, table, etc Scripts from sql server 2008 and run it on the 2005 Server, later use IMPORT/EXPORT Wizard or BCP or SSIS packages to ship the data

more ▼

answered Aug 15, 2010 at 10:45 PM

avatar image

10.8k 37 58 51

Is there any Tool From which we can perform it..

Aug 15, 2010 at 11:39 PM basit 1

You can also use tools like Red-gate compare and Red-gate datacompare or tools from Quest software ( I can't remember the name of it). The tools are powerful and not that expensive if you buy Red-Gate Toolbelt that contains Refactor and SQL Prompt. These tools can speed up you development and release process. Now it sounds like I am sponsored by Red-Gate, but I am not. :)

Aug 15, 2010 at 11:50 PM Håkan Winther
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 15, 2010 at 10:31 PM

Seen: 1354 times

Last Updated: Aug 15, 2010 at 11:51 PM

Copyright 2018 Redgate Software. Privacy Policy