Friday, 15 February 2013

Manually attach one instance of SQL Server database from another SQL Server instance -


I have installed two SQL Server instances, one is SQL Server 2012 and the other is SQL Server 2014.

I am associated with the use of the management studio from the SQL Server 2014 instance and clicked "Attach", while clicking on the "Find Database Files" window has been clicked and I have SQL Server 2012 I can not see the instance database.

Is it possible to add another instance database without moving the database to another location?

Is there a database that you are still using by the example of 2012? A database can not be attached simultaneously with two instances, as long as SQL Server can see a drive (or share), it can attach a database (as long as the database is being added the same or lower version Is.)


No comments:

Post a Comment