Jimbo,

Thanks for the info. I am talking about transactional replication. Recently I noticed one of our subscription in inactive state. So I just right clicked on that subscription in replication...

ask the admin for temporary credentials for accessing the database.

But what about the other window settings....if the service or application fails more than the maximum in the specified period, it will be...

John Mitchell-245523 (11/15/2013)

---

Yes, and it's not just explicit use of temp tables and temp variables that use tempdb. Maybe the query optimizer will decide that it needs to materialise...

actually i found an article .......

http://social.technet.microsoft.com/Forums/windowsserver/en-US/90c13166-7f95-4ea8-9cac-580426d2598b/quorum-drive-not-moving-in-2node-cluster

Actually you don't need to. This layer of clustering has been abstracted from the administrator as it used to cause confusion for some...

Perry,

I try to do it but it failed throwing the following error--

System error 5013 has occurred (0x00001395).

The cluster group could not be found.

I can see the cluster group status from...

I tried it on a test server using the command prompt command. I can move the cluster group but i still see the quorum drive on the passive node only....

MysteryJimbo (11/14/2013)

---

The clustergroup doesn't failover automatically along with the application groups.

You can safely move this group on to the active cluster. Im not aware of any impact if you...

Thanks a lot !! will go through them.

Jimbo,

thank you. But in the above responses somebody said the default is 0 and that means unlimited. Which one is true ?

We started modifying our scripts from applications.

How to resolve this issue?

free_mascot (11/5/2013)

---

The actual number of user connections allowed also depends on the version of SQL Server that you are using, and also the limits of your application or applications and...

do we require seperate quorum ?

I don't think it's possible. You have to reset the log shipping if you want to move the...

That script will not work if you have multiple files for a database.