Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Confused about creating a dup mdf

Author  Topic 

right-lefty
Starting Member

2 Posts

Posted - 2008-03-13 : 12:50:09
Hi
I have an slq Express mdf at path X and I copy it to path Y. When I open it up (from the Y path) using sql mgmt studio, it shows that it's from path X.
Why? How can I get sql mgmt studio to recognize it as a separate mdf, distinct from the one at path X?

TIA

rank beginner

toxicrainpx
Starting Member

8 Posts

Posted - 2008-03-13 : 13:11:07
Yes, attach the Y path database with a diferent database name and you have both available.
Go to Top of Page

right-lefty
Starting Member

2 Posts

Posted - 2008-03-16 : 22:30:39
ty! Will check it out.



lefty
Go to Top of Page
   

- Advertisement -