From device: This is probably what you will use most, especially if you are restoring a database from another server.If you backed up your filegroups using different backups, you will have the ability to restore an individual file or filegroup. If you only have one filegroup and/or file, this option will work the same exact way as the database option. Filegroup or files: This will allow you to restore a filegroup or file from the backups.Database: This option allows you to restore the complete database based on information in the system backup tables.For an existing database, the contents of the backup will be restored over the existing database. For a new database, the database will be created and then the contents of the backup will be restored. This drop-down menu option allows you to select an existing database, or, if you want to restore to a new database, type in a new name. If you select Restore, the following 'Restore database' window pops up, which I'll explain below.Įnterprise Manager: Restore database General tab The backup option was discussed in Selecting a SQL Server backup modelĪnd Maintenance Plan backups were covered in SQL Server backups made easy using Maintenance Plans. You will have options to Backup and Restore a database. In Enterprise Manager, right click on the database and select All Tasks.

In addition to being able to back up a database using a maintenance plan, you can back up and restore a database using Enterprise Manager. I will explore the Enterprise Manager command in this tip and T-SQL in a future tip. To restore a database, you can either use Enterprise Manager or T-SQL commands. Database Maintenance Plans make it easy to automate the backup process, but there is no equivalent for restore.

Sql server enterprise manager