Viewing 15 posts - 256 through 270 (of 541 total)
RamSteve (3/29/2011)
Can some one shade some light by giving step by step to configure this process of log shipping with one primary and two secondary servers?Thanks in advance
March 29, 2011 at 12:16 pm
Does the service exist in cluster admin on node1?
March 29, 2011 at 10:56 am
Did you try recreating domain accounts on the server and re-adding them inside sql server?
March 21, 2011 at 1:05 pm
Use Performance Monitor on subscriber server and select all Sql Server Replication counters.
March 21, 2011 at 9:58 am
OK, so you're saying it'd be safer to not use automatic failover?
Exactly
Be careful setting the timeout!!!
Lets say you set the timeout to 3 minutes and your cluster does not...
February 15, 2011 at 2:28 pm
That timeout parameter is tricky.
It depends on the time it takes for your cluster to failover in order for your witness to keep on mirroring once the passive...
February 9, 2011 at 2:41 pm
what does this return:
WHILE EXISTS
(
SELECT top 1 NULL
FROM dbo.tmp1 TMP (NOLOCK)
INNER...
February 9, 2011 at 10:55 am
This is usually caused by server times being slightly off or a huge transaction log taking time backing up.
January 31, 2011 at 1:51 pm
You should uninstall both versions and then install the proper one.
Otherwise there will be many weird errors.
January 31, 2011 at 1:41 pm
well thank goodness it's a dev server.
Maybe those sneaky developers installed SSMS express on top of your sql server management studio.
check control panel
January 28, 2011 at 10:18 am
SQL Server Express 2005 does not have sql agent. Did you recently install sql server express?
January 28, 2011 at 10:01 am
NewBeeSQL (1/27/2011)
TYPE: oPERATINGSYSTEM COMMAND(Cmdexec)Run as: SQl server agent
Command: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqllogship.exe" -Restore 02443D0C-6EE6-4139-B9B9-6E272E0324B8 -server EBFFwoe3
in view job history, error Message is..
Executed as user: EBFFwoe3\SYSTEM. The step failed.
Check which service...
January 28, 2011 at 9:33 am
giles.clapham (1/27/2011)
January 27, 2011 at 1:30 pm
Right Click on the restore job--->Properties--->Steps--->Highlight Step 1--->click Edit
Paste what it says in
Type:
Run as:
Command:
January 27, 2011 at 12:51 pm
Viewing 15 posts - 256 through 270 (of 541 total)