restore database query in sql server 2008

Restore a Database Backup (SQL Server Management Studio)
December 21, 2021 – 11:25 am
SQL Server 2016: Restore a Database

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, point to Restore, and then click Database, which opens the Restore Database dialog box.

On the General page, use the Source section to specify the source and location of the backup sets to restore. Select one of the following options:

  • Database

    Select the database to restore from the drop-down list. The list contains only databases that have been backed up according to the msdb backup history.

If the backup is taken from a different server, the destination server will not have the backup history information for the specified database. In this case, select Device to manually specify the file or device to restore.

  • Device

    Click the browse (...) button to open the Select backup devices dialog box. In the Backup media type box, select one of the listed device types. To select one or more devices for the Backup media box, click Add.

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

    In the Source: Device: Database list box, select the name of the database which should be restored.

    This list is only available when Device is selected. Only databases that have backups on the selected device will be available.

In the Destination section, the Database box is automatically populated with the name of the database to be restored. To change the name of the database, enter the new name in the Database box.

In the Restore to box, leave the default as To the last backup taken or click on Timeline to access the Backup Timeline dialog box to manually select a point in time to stop the recovery action. For more information on designating a specific point in time, see .

hair extensions near me hairstyles for short hair waves hair hair transplant walmart hair salon rose gold hair dark red hair hairstyles for long hair ash brown hair dark brown hair with highlights hair stylist near me brad mondo hair dye hair cutting places near me ginger hair types of hair honey blonde hair hair design human hair wigs black hair short hair cuts curly hair boys best hair salon near me madison reed hair color african hair braiding near me 3c hair curly hair products black hair salons near me luv me hair how often should you wash your hair red hair color braiding hair hair loss bellami hair bangs hair short hair cuts for women 2021 hair trends hair growth thick hair short haircuts coconut oil for hair fall hair colors dominican hair salon near me perm hair snow white with the red hair highlights hair billie eilish new hair hair dye colors best vacuum for pet hair semi permanent hair color hair bleach pubic hair cute hairstyles for short hair long hair men burgundy hair color hair type chart ingrown hair cyst ash blonde hair hair places near me passion twist hair gray hair ingrown pubic hair auburn hair color brown hair color crochet hair styles halo hair extensions hollywood hair bar how to cut your own hair 4a hair how to make your hair grow faster black hair anime girl money piece hair dark blonde hair dyson hair wrap loreal hair color hair tinsel copper hair color hair accessories hair crimper alt hair styles splat hair dye monat hair hair dryer brush hair dye ideas
Source: technet.microsoft.com
Related Posts