Viewing 15 posts - 6,391 through 6,405 (of 9,244 total)
GilaMonster (10/12/2011)
Perry Whittle (10/12/2011)
do you have any log backups happening outside of the log shipping plan?
If there was, the error would be that the log backup is too new to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 8:40 am
what is providing your shared storage for your cluster, do you have a SAN or some other NAS?
Do you have a storage administrator, someone who looks after said SAN or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 8:38 am
To be honest i would just go for this
1. On Node B: Add the required roles and features to enable for failover clustering
2. On Node A: Run the Add node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 7:56 am
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
Viewing 15 posts - 6,391 through 6,405 (of 9,244 total)