Can we restore SQL Server 2008 database to SQL Server 2005?


No we can’t restore it. SQL Server is not allowing the restore of higher version databases to a lower version. It is not possible to restore a database from a backup of a newer version to older version as database backups are not backward compatible.

You can do below workaround to transfer higher version database to lower version.

1. Generate database script. Right Click database -> Tasks -> Generate Scripts

2. Execute the script on the lower version server and it will create the database and its objects

3. Transfer data between these two databases using DTS/SSIS

Advertisements

One thought on “Can we restore SQL Server 2008 database to SQL Server 2005?

  1. SQL Server 2008 Training

    Hello

    Your website came up in Hello

    Your website came up in my search and I’m taken by what you have composed on this topic. I am presently diversifying my research and thus cannot contribute further; even so, I’ve bookmarked your web site and will be returning to keep up with any future updates. Just Now love it and thanks for granting my remark. Great job and will extend it on to admirers and my web site fans.my search and I’m taken by what you have composed on this topic. I am presently diversifying my research and thus cannot contribute further; even so, I’ve bookmarked your web site and will be returning to keep up with any future updates. Just Now love it and thanks for granting my remark. Great job and will extend it on to admirers and my web site fans.

    Reply

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s