How to Restore SQL Server 2008 backup in SQL Server 2005

Leave a comment (3) Go to comments

Can we restore a SQL Server 2008 backup in SQL Server 2005?

NO, we can not restore higher version of 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.

There is a workaround to transfer a database from SQL server 2008 to SQL Server 2005, i.e

  1. Creating a Script from a existing 2008 database
  2. Using this Script (Created in Step 1), create database and database objects in SQL Server 2005 / older versions.
  3. OR Start using Data Transfer tool to copy data from SQL Server 2008 to SQL Server 2005 ot lower versions.

Other Related posts.

I have already posted an article on restore Database in SQL Server 2008 from a backup file, created in older versions and restore higher version of databases to a lower version (2008 to 2005)

EOF - How to Restore SQL Server 2008 backup in SQL Server 2005, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

3 Comments.

  1. and where is Step 1 ?..

  2. Dear Sir/Madam

    1) Can you please tell me how to restore a database from Sql Server 2005 to Sql Server 2008 ?

    2) How to create a mail alert in Sql Server 2005 and SqlServer 2008 after daily backup is scheduled?

    • To restore a full database backup

      After you connect to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

      Expand Databases. Depending on the database, either select a user database or expand System Databases, and then select a system database.

      Right-click the database, point to Tasks, and then click Restore.

      Click Database, which opens the Restore Database dialog box.

      On the General page, the name of the restoring database appears in the To database list box. To create a new database, enter its name in the list box.

      In the To a point in time text box, either retain the default (Most recent possible) or select a specific date and time by clicking the browse button, which opens the Point in Time Restore dialog box. For more information, see How to: Restore to a Point in Time (SQL Server Management Studio).

      To specify the source and location of the backup sets to restore, click one of the following options:

      From database

      Enter a database name in the list box.

      From device

      Click the browse button, which opens the Specify Backup dialog box. In the Backup media list box, select one of the listed device types. To select one or more devices for the Backup location list box, click Add.

      After you add the devices you want to the Backup location list box, click OK to return to the General page.

      In the Select the backup sets to restore grid, select the backups to restore. This grid displays the backups available for the specified location. By default, a recovery plan is suggested. To override the suggested recovery plan, you can change the selections in the grid. Any backups that depend on a deselected backup are deselected automatically.

      For information about the columns in the Select the backup sets to restore grid, see Restore Database (General Page).

      To view or select the advanced options, click Options in the Select a page pane.

      In the Restore options panel, you can choose any of the following options, if appropriate for your situation:

      Overwrite the existing database

      and you are done with this….

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.