Just wanted to follow up to let you know that it worked fine... thanks for all the info/help.

Very cool, I will do this off hours just because i am paranoid. Let you know how it goes. Thanks for the help!

So this is what it should look like:

RESTORE DATABASE TEST FROM DISK = 'E:\<path>\FULL.BAK'

WITH

MOVE 'PROD' TO 'E:\<path>\TEST.MDF',

MOVE 'PROD_log' TO 'E:\<path>\TEST_log.LDF';

Sorry for asking a lot of questions, never created test DB's...

So it should look like this?

RESTORE DATABASE TEST FROM DISK = 'E:\<path>\FULL.BAK'

WITH REPLACE, RECOVERY,

MOVE 'PROD' TO 'E:\<path>\TEST.MDF',

MOVE 'PROD_log' TO 'E:\<path>\TEST_log.LDF';

Do i need the RECOVERY?

Also, do i use the logical name or physical name?

Perry Whittle (7/25/2014)

---

This is why you are getting the error

RESTORE DATABASE TEST FROM DISK = 'E:\<path>\FULL.BAK'

WITH REPLACE, RECOVERY,

MOVE 'PROD' TO 'E:\<path>\TEST.MDF';

You've only specified a move for the primary data file,...

Thanks for the reponses....

So the above is correct but due to someone signed in probably caused the errors.

I just want to make sure that this will create a new Test...

I would need to do it after hours but i can.

The errors where along the line of cannot move Prod because it is in use.

Thanks for taking the time to repond.

I was thinking along those lines too just wasn't sure if that was the best method. When I create the 'on the...

Sorry it took so long to reply... got pulled away for something else...

I tried with <> and like but it is throwing an error cannot compare string with boolean.......

OK made some progress but I am stuck...

The "Both" and "Printing" selection works from the drop down list on the report... the "Copy" selection is where I am stuck.

This...

Thanks for the reply... that was pretty clear.... I will play with it and let you know....

Thanks again!

So I have had some time to look over this and had a couple questions:

First let me give better info, the parameter name is @Type and the column name is...

Thanks for the reply... I will test tomorrow and give feedback.

groovy...

I apologize I am still a bit of a NOOB with this... I was trying to read up on what you provided to understand what it is doing... but you...