Home > IT Answers > SQL Server > Restoring SQL Server 2000 database
Gini_2
5 pts.
 Restoring SQL Server 2000 database
SQL Server 2000, SQL Server backup, SQL Server Enterprise Manager, SQL Server errors
I want to restore a database in SQL Server 2000, using a specific name. I tried restoring it using Enterprise Manager, but kept getting the error 'You must select a backup set to restore'. Why is this and how do I resolve it?

Software/Hardware used:
ASKED: June 5, 2008  10:09 AM
UPDATED: June 5, 2008  7:51 PM
RELATED QUESTIONS
Answer Wiki:
To restore a database you must have a backup file of the database. To recreate the database with no data you need a sql script. After you select the backup file to restore, you need to select which backup within the file you want to restore. It will be the list ont he lower half of the window.
Last Wiki Answer Submitted:  June 5, 2008  7:51 pm  by  TorayDBA   60 pts.
All Answer Wiki Contributors:  TorayDBA   60 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hello Gini2,
when you select the backup file,a re you sure that you also checked which files you want to restore?

alessandro.panzetta
 9,695 pts.