If you wish to specify a different restore time for each database individually, click Set restore time to the right of the appropriate database:.If the restore time selected is available, a success icon will appear to the right of the database.If the restore time specified is not available from the supplied backup files, a warning icon will appear to the right of the database and the nearest available time to that specified that the database can be restored to will be indicated.To restore all databases to the same point in time, specify the time in the Restore time drop-down menu and click Search.Check each database in the list that you wish to restore.The list may take time to generate depending on the number of backup files.
You can add as many directories as you like. Click Add if the path was entered manually.If the backup files for your databases are not available you may need to first restore them from your backup media using NTBackup. BAK format (a separate file for each database) before being copied to the backup destination (tape drive, external hdd, REV drive, etc). Each database backup created is stored in the SQL directory in. Note: this is typically the SQL directory used in your BackupAssist backup job.BAK format) either by typing it directly in the Add directories containing backups field Specify the path where the database backup files reside (in.The master database will be restored before other databases. if you want to restore the master database check Master database recovery as well. Note: checking this option will not let you restore the master database.
Choose the SQL server instance you wish to restore to from either the list of local or remote servers detected.If you are restoring your SQL server after a disaster or new installation, it is advised that you restore the master database before restoring any other database. The databases you wish to restore must already exist on the SQL server if they do not you can either choose to use the SQL Restore Utility to restore the master database first, which will result in recreating all databases on the server, or you can manually recreate each database you wish to restore. The utility also lets you restore a SQL database to a specific point in time, provided you have a transaction log backup to restore from. BackupAssist provides a utility for restoring one or more SQL databases to either a local or remote SQL server in just a few simple steps.
0 kommentar(er)
