how do you run a back up?

[stewglyn]

I have a .bak file which is the full backup of a database.
It is a sql server7 back up. I want to run it on a 2000 version but I can't find where to do it??? I've found restore database but the wizard is confusing and I can't see where you choose the bak file to restore.
do i have to create the shell of the database first??

regards

stewart.

 

[xloop]

Hi

You need to create the new database, right click on it's name, restore database, from device, select devices, add device, type filename and away you go

Cheers