How to restore a SQL Server 2000 database using a backup

Tags:
Backup
Backup and Recovery
Microsoft SQL Server 2000
SQL Server backup
Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software (.NET application) and SQL Server 2000 back end. We run the backup before any major change to the database.

Answer Wiki

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

You can do this via the Microsoft console (look under programs/Microsoft SQL server) or via SQL command.
I suggest you using the graphical way, that’s to say:

  • Open the management console
  • Provide login information
  • Right click the database that you need to restore and choose restore
  • If the database name isn’t listed right click on any database and select restore, and in the database name drop down at the top enter the name of the database to restore to.
  • In the source field if you don’t see the file where you backed up your db choose add
  • Choose if you want a complete restore and click start
  • If you need to change the folder where the files will be stored select the second tab (Options I believe in SQL 2000) and change the folder for each of the files listed.

If you want to use the T/SQL RESTORE DATABASE command the syntax will look like this.

<pre>RESTORE DATABASE MyDatabase FROM DISK='D:\Path\To\BackupFile.bak'
WITH MOVE 'MyDatabase_Data' TO 'D:\MSSQL\MSSQL\Data\MyDatabase_Data.mdf',
MOVE 'MyDatabase_Log' TO 'D:\MSSQL\MSSQL\Data\MyDatabase_Log.ldf'</pre>

If the folders are the name between the source server and the server you are restoring to you can ignore the WITH MOVE part of the command.

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

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