Steve,

Our Production cluster instances are using Dynamic ports since they configured. In this can I create alias...

please advice me on how to do...

Its working when I provided the below

myserveramed instance

But the same is NOT working when I accessed through VPN. From VPN the below is working myserver\<named instance>,port.

What should I do to...

Yes, the backup disks also exist on...

Disk Z & Disk K are...

Our cluster is configured as below:

SQL Server instances on node3 can only failover to node2 (passive) and SQL Server instances on node1 can only failover to node2(passive) but node3 cannot...

We have a common backup group, which has a Z drive in it, for all all the instances on node3. The Z drive it NOT tied to a single SQL...

Those objects do not appear to be doing much. Have you been able to trap the query yet that is causing so much activity?

I would set up the sql agent...

Thanks

Query1:

use tempdb

go

SELECT OBJECT_NAME(id), rowcnt

FROM tempdb..sysindexes

WHERE OBJECT_NAME(id) LIKE '#%'

ORDER BY rowcnt DESC

Results:

328 row(s) affected)

#5629CD9C0

#58DCE86C0

#59511E610

#5A45429A0

#5BB955170

#5BB955170

#Temp_______________________________________________________________________________________________________________0000000046480

#Temp_______________________________________________________________________________________________________________0000000046480

#5CECA51B0

#5DE0C9540

#5E15D37E0

#5E95C1C20

Query2:

DBCC OPENTRAN('tempdb')

Results:

No active...

Hi Jason,

Can I run the below commands on Production TempDB directly or do I need run these commands only for user database?

DBCC OpenTran(mydb)

DBCC InputBuffer(SPID)

Thanks

I do have the same question. Could you please advice on what tasks need to done to upgrade the secondary too, while upgrading the primary?

thanks

Hi Mohan,

I did not understand that there are really two methods for inplace upgrade SQL Server 2008. i.e normal & rolling upgrade? could you please shed some light on the...

Did you read that from:

http://msdn.microsoft.com/en-us/library/bb500433.aspx ?

I don't believe that MS is saying not to use a named instance, I think they are just saying that most instance installations...

Thanks,

Does the Browser services MUST need to be enabled even if we configure static port in CLUSTERED Environment.

From SQLServer2008FailoverCluster document:

If you assign static IP ports to all of your SQL...

I've done this, and we've set static ports in the firewall. If you don't do this, then you open a big range on the firewall, which upsets security people. Also...