Attach Backup MDF and Rename

[chrism2278]

We have a copy of an accounting.mdf that we would like to attach and use as a test evironment. This copy was made prior to a year end close so we would really like to use that particular mdf copy.

We currently have a live accounting database running.

I took a copy of the accounting.mdf and renamed it to accounting_2.mdf

I then went to attach the database and it MDF/LDF files were defaulted to the live company. I then changed the paths in the attach to the accounting_2.mdf and ldf filename. I also renamed the database in the attach to accounting_2.

I get an error 5173 - cannot associate files with different databases

How can I take a copy of our live database and rename & attach to create a test environment.

Thanks

 

[SQLBill]

Does it have to be in the same instance? I would advise installing a second instance called TEST (or whatever you want). Then attach the test version there.

-SQLBill

Posting advice: FAQ481-4875

 

[chrism2278]

Unfortunately yes...in order for the account system to see it.