Viewing 15 posts - 3,046 through 3,060 (of 4,745 total)
Use task manager just to confirm it is SQL chewing up the CPU.
You already know CPU spikes in the afternoon, does that give any clues to a possible process causing...
January 12, 2010 at 1:12 pm
SQL server 2000 standard edition is limited to 2Gb, but I presume you have enterprise edition, in which case it can use the extra memory with /PAE in the boot.ini...
January 12, 2010 at 1:00 pm
Lynns guess is correct. You cannot have master database in a recovery state, it would make SQL inoperable and then you would not be able to recover it.....................hence only...
January 12, 2010 at 10:08 am
cheers Dave. Any article on administring RS would be good, it does seem to ba a neglected area.
January 12, 2010 at 7:10 am
are you absolutely sure you installed the workstation components?
Is there a shared or a tools directory as part of your installation.
whats under start/all programs/microsoft SQL server 2005
You could always rerun...
January 12, 2010 at 6:54 am
thats good to hear.
This is not a process I enjoy doing (RS error messages are so esoteric). did it go smoothly, any hiccups? was the procedure in the link exactly...
January 12, 2010 at 5:45 am
Donna, log file is 11Gb but is actually hardly used. You do not have a problem per se, certainly not an ongoing runaway transaction or anything like that. At some...
January 12, 2010 at 3:41 am
Ignacio A. Salom Rangel (1/11/2010)
January 11, 2010 at 3:32 pm
Ramji-480085 (1/11/2010)
Sudhakara it's always a good practice to post the solution also...
January 11, 2010 at 10:02 am
sudhakara (1/11/2010)
george sibbald (1/10/2010)
on primary move log backups out of logshipping directory to another directory
on secondary delete log backups from log shipping directory
on primary take full backup...
January 11, 2010 at 9:20 am
Interesting, I am facing just such information in a deadlock at the moment, helps explain why there are sometimes 4 or more process ids in the process list, which gave...
January 11, 2010 at 9:12 am
In the case of the code above you would just leave @replace = 0
code seems to have ended up with spurious characters so needs all those 0 type characters removed,...
January 11, 2010 at 5:07 am
disable all logshipping jobs
on primary move log backups out of logshipping directory to another directory
on secondary delete log backups from log shipping directory
on primary take full backup (ensure db in...
January 10, 2010 at 12:21 pm
naldo.samuel (1/10/2010)
January 10, 2010 at 7:48 am
Viewing 15 posts - 3,046 through 3,060 (of 4,745 total)