Two databases - same name: Can do?

[SQLBill]

I have to do some work with archived data which requires me to restore the data to the same server our current data is on. That means that I will have two databases with the same name. Here is what I plan on doing:

1. create a new instance (\\servername\Archive)
2. create a new folder on the SAN (Archive files)
3. move the archive database files (master, model, msdb, userdbs) to this folder.
4. attach the files to the new instance.

This will give me two instances (Default and \\servername\Archive) each with a database having the same name, but different file locations.

Does anyone see any problems with doing it this way?

-SQLBill

Posting advice: FAQ481-4875

 

[JayKusch]

Nope ... That seems the most ideal solution.

Only catch is that you have to make sure to preface the correct instance if you make any cross-instance calls or you have apps that may hit both instances.

Thanks

J. Kusch

 

[SQLBill]

Jay,

Thanks for the insight about cross-instance calls and apps. If I have to do this, I'll be creating a Crystal Report template that duplicates the one currently used, but pointing to the archive instance.

-SQLBill

Posting advice: FAQ481-4875