making a sql backup file a database

Hi
I have copied a sql server backup file. I would like to make it a live database. How would I do this??Use RESTORE statement to restore as database.
Refer to books online for more information.|||Originally posted by Satya
Use RESTORE statement to restore as database.
Refer to books online for more information.

I actually made a backup of one of our live databases...lets call it database1....I would like the backup to be identical to Database1 BUT called database2. The main reason for this is i want to do tests on it...

Thanks

Charlene|||Can you describe "backup" in a bit more detail? Is this a SQL backup (to a dump file), or an NT file backup?

-PatP|||Originally posted by Pat Phelan
Can you describe "backup" in a bit more detail? Is this a SQL backup (to a dump file), or an NT file backup?

-PatP

On one of databases in Server Enterprise Manager, I right clicked on the database and I made a full backup.....this is what i currently have as my backup......

Charlene|||Ah, way more gooder yet even! ;)

There are more ways to skin this cat than there are cats, but I'll give you a simple scenario.

1) Go into SQL Enterprise Mangler.
2) Create a new database on your server
3) Right click on the new database
4) Click restore from the pop-up menu
5) Select the dump file that you created

...and you should be in business!

-PatP|||Originally posted by Pat Phelan
Ah, way more gooder yet even! ;)

There are more ways to skin this cat than there are cats, but I'll give you a simple scenario.

1) Go into SQL Enterprise Mangler.
2) Create a new database on your server
3) Right click on the new database
4) Click restore from the pop-up menu
5) Select the dump file that you created

...and you should be in business!

-PatP

Thank you sooo much...you are a great help/////|||Oh, I just love it when a pretty lady says that!

-PatP|||Actually, you can skip steps 1 through 3 and restore a db to a different name (Hoping for a "Thank you sooo much" here...:rolleyes: )|||Thank you soooo much!

Oops, hold on a second. Probably not where you wanted that to come from. Sorry ;)

That actually would be how I'd do it, but that isn't as "easy" for somebody from the GUI world.

-PatP|||Originally posted by Pat Phelan
Thank you soooo much!

Oops, hold on a second. Probably not where you wanted that to come from. Sorry ;)

That actually would be how I'd do it, but that isn't as "easy" for somebody from the GUI world.

-PatP

Cool....you guys are all great...I am very impressed with the help...|||Originally posted by charla
Cool....you guys are all great...I am very impressed with the help...

One more problem...where must my database .bak file be placed, because I cannot select the file i want to make a backup of...|||Originally posted by charla
One more problem...where must my database .bak file be placed, because I cannot select the file i want to make a backup of...

This is not working....can someone please guide me step by step through the process of making a backup of a database that is sitting on one of my remote servers. Then creating a copy of this database on a local machine.

Thanks|||Why not review information from books online for BACKUP & RESTORE statements.