![]() ![]() For more information regarding the sequencing of restore operations, please consult your SQL Server product literature. You should elect to leave the database in a non-operational state only if you plan on executing additional recovery steps (such as recovering subsequent differential or transaction log backups) immediately thereafter. running, full recovered) state or it can be left in a non-operational state. To restore the backup to a different database, either select a new database name (via the drop-down arrow) or type in a new one.ĭuring the database recovery process, SQL Backup Master can either leave the database in a "ready to use" (e.g. 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. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |