SQL server DB Access

Question

Post reply

SQL server DB Access

gupta1282

Default port

Points: 1465
More actions
February 17, 2010 at 1:06 am

#138103

Hi All
Today someone asked me that like in Oracle , multiple instance can share single db at the same time , is it possible in sql server also.
I replyed this is not possible in sql server.
Now I want to know , is there any third party tool which provide this functionality in sql server to access single db from multiple instance at the same time like oracle.
Thanks
Ghanshyam

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

jshailendra SSCrazy Points: 2260 More actions · Answer 1

The terms Database and Instance are different in Oracle and SQL.

In SQL in an instance there can be 'N' number of databases.

In SQL there is database which can have multiple instance.

---Now I want to know , is there any third party tool which provide this functionality in sql server to access single db from multiple instance at the same time like oracle.

What do you mean by to access single db from multiple instance at the same time like oracle? Is it that you want to access single SQL DB be accessed from different machines at the same time?

If that is your question then answer is YES...and you dont need any 3rd party tool to do that

Just Registered you SQL Instance on different machines (provided you have SQL installed on that machine)...and you are connected to all DBs in that instance.

Hope this helps...

gupta1282 Default port Points: 1465 More actions · Answer 2

Actually I want to know that

single database file (mdf,ldf) can have ownership from two instances

e.g. In oracle , two oracle instances can access single database at the same time in Oracle RAC(Real appilication cluster) architecture.

Is there any possibility in sql server.

Thanks

Ghanshyam

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Never heard of that being possible.

The only close possibility is to use replication of the db to a 2nd instance.

However since more than 1 application can connect to the same server and the same db at the same time I don't see how that's possibliy a requirement for you... can you tell us what you need to do so that we can offer a possible solution?