Restoring SQL Server 2000 database

5 pts.
Tags:
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?
ASKED: June 5, 2008  10:09 AM
UPDATED: June 5, 2008  7:51 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • alessandro.panzetta
    Hello Gini2, when you select the backup file,a re you sure that you also checked which files you want to restore?
    9,725 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following