It’s very easy to restore a database in Microsoft SQL Server 2000 from a backup.
1. Open Enterprise Manager.
2. Right-click on the Database tab, select All Tasks, and then click Restore Database in the drop-down menu.
3. In the window that opens, you will see the Restore as database section. It will ask where to save the database you restored from backup. I always perform the restore process by naming a new database. For example, as you can see here, I typed restore-backup. If you don’t need to restore over the existing database, you can make a selection here.
4. In the Show backups of database section, you’ll select which database to restore.
5. You can select the date from the First backup to database section.
6. Now we can restore our backup by pressing the OK button. Once the restore is complete, if you’ve given it a new name, you can check it in the Database section.
Leave a Comment