How to restore a SQL Server 2000 database using a 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: 4  Replies

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.
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    69,130 pointsBadges:
  • minhngoc
    Hi, how can I restore my SQL 2000 backup to me?
    10 pointsBadges:
  • Subhendu Sen
    @minhngoc, more information is needed. What environment is there? Is it your office? You can follow Mr. Denny Cherry blog which can help you a lot as mentioned.
    142,670 pointsBadges:
  • ToddN2000
    @minhngoc: Try looking at the Microsoft write up on the back up and restore process at this LINK. IF you still have issue come back with more info.
    136,530 pointsBadges:

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.

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


Share this item with your network: