Viewing 14 posts - 1 through 14 (of 14 total)
Are this subscriber in same data center?
You've mentioned about the latency, is it between publisher to distributor or distributor to subscriber ?
August 16, 2014 at 11:09 pm
Best luck Steve, and we'll be waiting for your come back.
May 31, 2014 at 3:01 am
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
April 30, 2012 at 1:41 am
There are some more to focus on,
SQL DBA + HA
SQL DBA + PT
July 8, 2010 at 4:28 am
In this thread MSFT is saying that add a new device to have a backup on that drive
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...
November 18, 2009 at 5:25 am
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...
November 9, 2009 at 4:56 am
you need to enable remote connection at your Host server, follow and check the steps listed here http://support.microsoft.com/kb/914277
March 24, 2008 at 2:12 am
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...
March 13, 2008 at 2:16 am
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...
March 14, 2006 at 8:58 am
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 ?!
August 10, 2005 at 12:30 am
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...
July 31, 2005 at 10:46 pm
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...
July 31, 2005 at 10:36 pm
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...
July 31, 2005 at 10:33 pm
Open registry editor : and opn HKEY_LOCAL_MACHINE->microsoft -> microsoft sql server -> 80 -> mssql server -> login mode -> add new...
July 31, 2005 at 10:21 pm