Shulou(Shulou.com)05/31 Report--

Restore sql server database processing methods, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

How to restore a backup from a backup device (Enterprise Manager) restore a backup from a backup device

Expand the server group, and then expand the server.

Expand the databases folder, right-click the database, point to the all tasks submenu, and then click restore Database.

In the restore to Database box, if the database name you want to restore is different from the default database name displayed, enter or select it. To restore the database with a new name, enter a new database name.

Description assigning a new name to the database automatically assigns a new name to the database file restored from the database backup.

Click from device, and then click Select device.

Under restore from, click Tape or disk, and then select the restore device. If no device appears, click add to add an existing backup device or create a new backup device. In the restore Database dialog box, click View contents and select the backup set you want to restore.

"indicates that this option scans the backup set for backup content information, which may take a long time, especially when using tape devices." If you already know the backup set to restore, enter the backup set number in backup number.

Under restore backup set, do one of the following: click Database-full to restore the database backup.

Click Database-difference to restore the differential database backup.

Click transaction Log to apply the transaction log backup.

Click File or filegroup to restore the file or filegroup backup. Specifies the name of the file or filegroup. Click the options tab, and then do one of the following: (optional) Click enable the database to continue running, but cannot restore other transaction logs, if there are no other transaction log backups to apply.

Click make the database no longer running, but restore other transaction logs, if you want to apply other transaction log backups.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.