Viewing 15 posts - 1 through 15 (of 140 total)
I put the following into a bat file and then execute that from my SQL Server Agent job...
rem RoboCopyErrors.bat
robocopy %*
rem suppress successful robocopy exit statuses, only report genuine errors (bitmask...
November 20, 2013 at 12:37 pm
Henning Peter Jensen (10/26/2013)
October 26, 2013 at 10:30 am
qiyuef (10/24/2013)
There should be a logic in the job to check if the fail over happened. otherwise , it will keep reset the MAXMemory setting to the same value.
The code...
October 24, 2013 at 1:30 pm
Andrew L. Smith-213145 (10/24/2013)
October 24, 2013 at 1:25 pm
lptech (10/24/2013)
1) The jobs would run if the cluster was actually running active/active with the instances running on the opposite nodes.
2) After the...
October 24, 2013 at 11:20 am
Prudhviraj (10/23/2013)
That's a good article 🙂Can add one more line - set schedule for jobs 1,2 and 3 to one time(run on demand).
Hi Prudhviraj!
Glad to hear you liked the article.
You...
October 24, 2013 at 6:05 am
Sometimes the fix is to simply restart your SQL Server Agent.
October 15, 2013 at 9:15 am
Generally speaking you want to have a PLE (Page Life Expectancy) > 300 (5 minutes). In other words, you want your pages in memory to stay in memory a relatively...
August 27, 2013 at 12:41 pm
Functional means he or she isn't brain dead......yet.
May 30, 2013 at 12:49 pm
Nice function, but you may want to change this one line for proper US English...
Set @STAIL= 'AND CENTS ' +LTRIM(@STAIL)
change to:
Set...
April 22, 2013 at 9:41 am
Just to clarify what opc.three's link says. The reorg does not affect your db statistics, but if they were in a bad state before the reorg they'll still be in...
March 20, 2013 at 10:20 am
Would this work?
Each instance should have a drive that has a dependency set in cluster management. Place a text file somewhere on each drive, for each instance, and use the...
January 31, 2013 at 8:52 am
ahassan 82526 (7/12/2012)
November 2, 2012 at 8:20 am
Building a two node cluster on one physical server does not make any sense. The only reason to have a two node cluster is to protect against failiure on one...
April 16, 2012 at 12:44 pm
You're right to be concerned about the identity column values. Please see the following for info...
http://www.replicationanswers.com/DR_Using_TR_in_SQL2005.asp
March 13, 2012 at 8:54 am
Viewing 15 posts - 1 through 15 (of 140 total)