Viewing 15 posts - 6,391 through 6,405 (of 9,241 total)
to be clear, you have checked the windows application and system logs havent you?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 7:52 am
do you have any log backups happening outside of the log shipping plan?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 7:48 am
This query is quite handy for breaking down buffer pool object consumption
selectisnull(quotename(db_name(bd.database_id)), '[MSSQLResource]') as DB
, bd.database_id
, bd.file_id, bd.page_id
, bd.page_level
, bd.page_type
, bd.row_count
, bd.free_space_in_bytes
, bd.is_modified
, case au.type when 0 then 'Dropped' when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 6:44 am
when i encountered this issue i found various entries in the windows event log from the McAffe virus scan app. I looked them up on the McAffe support site and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 6:29 am
derekr 43208 (10/12/2011)
I'm quoting from your SSC article "Creating a 2 Node SQL Server 2008" - In the beginning of Part 3 you mention: "the Windows 2008 cluster may now...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 6:27 am
Dev @ +91 973 913 6683 (10/12/2011)
I always disable windows firewall on corporate domain computers
Considering the security, enabling few ports (adding exceptions) would be a good idea.
No, as i mentioned...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 2:05 am
Dave Brooking (10/12/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 2:02 am
GilaMonster (10/12/2011)
Perry Whittle (10/12/2011)
mwieczorek (10/12/2011)
any ideas why my sql server restarts every time?
As I said it sounds like someone is pulling the plug or switching off at the socket. Without...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 1:15 am
Saga... (10/12/2011)
Yes You will need 2 ip's (Heartbeat IP, Private IP) for each node & 1 Ip for SQL server.
Heartbeat and private are the same!
I assume you meant public...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 1:09 am
mwieczorek (10/12/2011)
any ideas why my sql server restarts every time?
As I said it sounds like someone is pulling the plug or switching off at the socket. Without any other log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 12:47 am
Jack
I always disable windows firewall on corporate domain computers. If you need to ringfence a set of servers use a dedicated firewall product. If you want a good freebie Smoothwall...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 12:43 am
On Windows server systems MDAC is part of the operating system and it's service packs.
I believe you may be referring to the SQL server native client, if you already...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 5:22 pm
Have you ensured that all required storage has been presented to the new node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 5:17 pm
Jack, the easiest way to test a failover of the cluster is to kill the public network connection on the active node. This should cause failover to a partner node....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 5:12 pm
What's in the windows application and system logs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2011 at 5:02 pm
Viewing 15 posts - 6,391 through 6,405 (of 9,241 total)