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.