Viewing 15 posts - 7,906 through 7,920 (of 9,720 total)
You really should run PerfMon and a server side trace to determine at what point the cache is eating the memory and to see if it's even related to SQL...
June 3, 2010 at 7:25 am
All,
This is a duplicate thread. Responses can be found at Fatal Error.
June 3, 2010 at 7:22 am
GilaMonster (6/3/2010)
Log shipping to a failover node of the cluster is frankly stupid.
Yeah, well, I tried to be nicer about that point in my first point on this thread.
June 3, 2010 at 7:15 am
Well the OP isn't clear if the second server is on the cluster or not. I'm just assuming that's what (s)he meant.
But it wouldn't be the first time this week...
June 3, 2010 at 6:32 am
You can log ship to a server that has no instance?
I thought log shipped databases were in a state of Recovery? I thought they needed an instance to reside on....
June 3, 2010 at 6:17 am
Active / Active has a SQL instance on both nodes. Active / Passive has the instance only on one node. If you have instances on both nodes, you're running A/A...
June 3, 2010 at 5:52 am
It amazes me that someone would expect you to restore backups with no alternative cataloging system to identify this information. Automated backups through the maintenance plan or a third party...
June 3, 2010 at 5:50 am
Depends on what kind of cluster you have set up. If it's Active / Active, then yes, you shouldn't have a problem. If it's Active / Passive, you have a...
June 3, 2010 at 5:39 am
Job_ID is not an int. You have to use uniqueidentifier or char / varchar data types for your variable.
EDIT: And yes, what you want to do is possible. Just adjust...
June 3, 2010 at 5:36 am
Google that first sentence. There are tons of responses from 2008 and 2009.
First one on the list is this one about 64 bit OS patches.
June 3, 2010 at 5:34 am
Check out this link on how to read the dump log. It might help you track down your problem child.
June 2, 2010 at 10:26 am
Check the dump log, and the server's event viewer. What are they saying?
The usual "fix" in SQL 2000 for me (when it came to problems like this) was re-initializing the...
June 2, 2010 at 8:40 am
It's been forever since I've used replication. I have this bizarre, vague memory that there's a setting in one of the properties windows that needs to be set in order...
June 2, 2010 at 8:35 am
I don't know if there will be a problem if you move your databases without changing your SQL Server install from 32bit to 64bit. Have you upgraded the SQL Server...
June 2, 2010 at 8:23 am
Check your server's Event Viewer for errors and warnings from around the time of this error.
June 2, 2010 at 8:22 am
Viewing 15 posts - 7,906 through 7,920 (of 9,720 total)