Are this subscriber in same data center?

You've mentioned about the latency, is it between publisher to distributor or distributor to subscriber ?

Best luck Steve, and we'll be waiting for your come back.

Regards

Hemantgiri

See if this http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/55909/LATCH-EX-waits-of-Class-ACCESS-METHODS-SCAN-RANGE-GENERATOR can help you

There are some more to focus on,

SQL DBA + HA

SQL DBA + PT

In this thread MSFT is saying that add a new device to have a backup on that drive

http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/85572147-27bf-46b6-a482-1769c0b6d940/

and here http://www.developmentnow.com/g/99_2003_9_0_0_386917/SQL-Cluster-cannot-see-all-local-drives.htm , http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.clustering/2006-08/msg00129.html Geoff Hiten...

Hi All,

I was searching for some tool and landed here on this page. It is nice to see great tools. Here are some free tools:

SQLDBDiff V3.0.0 -- This tool can...

Hi,

you need to enable remote connection at your Host server, follow and check the steps listed here http://support.microsoft.com/kb/914277

According to me choosing a type of HA option depends on how cruitial data you have and how much down time is allowed!!

Definately cluster would be good choice but...

Hi,

i have also worked as Network / System Administrator and now since 6 years i am working as a MS SQL DBA also i dont want any programmer to let...

I feel you cant set default database for server as their are default system dbs set ...

BTW why you need to set the default db for server ?!

Regards

Hi,

do not use Enterprise Manager to shrink the file , instead use dbcc shrinkfile command to get more control over what you do... and for

resetting the suspect database read...

for an instance you can do it other alternet way too use L:

sp_helptext 'yrspname'  it will display the text / code of yr sp copy / save it to .txt...

Dear Raj,

it is not recomended to Add more log file , what you can do is shrink log file using dbc shrinkfile , make autor grow (in % and not...

Hi  Shajan,

Open registry editor : and opn HKEY_LOCAL_MACHINE->microsoft -> microsoft sql server -> 80 -> mssql server -> login mode -> add new...