vurnordic.blogg.se - Mssql restore master database

To restore the database backup file to a different SQL Server instance than the one that created it, click the hyper-linked SQL Server instance name and choose a SQL Server instance. Target database - The name of the target database to which the backup file will be recovered.

SQL Server instance - The instance of SQL Server to which the database backup will be recovered.

Backup type - The type of database backup being recovered.

Database name - The name of the source database that will be recovered.

The backup summary panel indicates the following: IMPORTANT : When recovering a database backup from within SQL Backup Master, you should run SQL Backup Master from a Windows account that is a member of the System Administrator role in SQL Server. The Recover Database window will be shown. You recover a database within SQL Backup Master by running the Database Backup Recovery Explorer and then clicking the Restore from backup action link associated with a specific database backup file.