question

basit 1 avatar image
basit 1 asked

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
sql-server-2008sql-server-2005restore
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Cyborg avatar image
Cyborg answered
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
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Håkan Winther avatar image Håkan Winther commented ·
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. :)
5 Likes 5 ·
basit 1 avatar image basit 1 commented ·
Is there any Tool From which we can perform it..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.