Viewing 15 posts - 7,456 through 7,470 (of 9,241 total)
I always backup system databases once a day, for the size of them it's really no great shakes!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2010 at 3:02 am
This is quite worrying too
SQL Server error log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2010 at 2:55 am
nekonecny (10/28/2010)
SQL server take more RAM, if SQL sever need it.[p]But You can set: [/p]
[p]sp_configure 'max server memory (MB)',6144;[/p]
[p]sp_configure 'min server memory (MB)',6144;[/p]
[p]reconfigure with override[/p]
Don't forget you will also need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2010 at 2:48 am
Geoff A (10/29/2010)
failover time with clustering = less than 1 minute more than 30 seconds.
I have deployed previous clusters that can failover 2 instances of SQL server in around 15-20...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2010 at 2:39 am
OK, now i know this is definitely related to your later question in this forum.
Firstly please do not double post, it clogs the forum and can prevent your questions from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2010 at 2:15 am
has the database been restored from a previous version of SQL Server.
Try updating usages and rebuilding indexes would be my first port of call!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2010 at 2:08 am
is this a graph produced in an SSRS report?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2010 at 2:06 am
Mike Hinds (10/29/2010)
a multinode cluster that consists of four active nodes, one primary passive node, and two alternate passive nodes."
Yes, that is an Active\Passive cluster!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2010 at 7:32 am
This is already in discussion here too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2010 at 6:19 am
BigSam (10/28/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2010 at 3:05 pm
Brian B. (10/26/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2010 at 10:43 am
homebrew01 (10/28/2010)
My BOOT.INI is:[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect
We're running VMWare, if that makes a difference.
I thought so, there you go!
PAE is automatically enabled when DEP options are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2010 at 10:24 am
hydbadrose (10/27/2010)
The default instance is missing or not visible on node b.
Curious, what makes you think the instance is not installed on Node B?
Did you install the instance originally?
If so,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2010 at 8:55 am
what do you have in the boot.ini?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2010 at 8:51 am
sqlstart wannabe (10/28/2010)
i can just failover the services and reboot the machine, am I right?
Just reboot the node it will automatically failover any services, no need to do it manually!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2010 at 8:50 am
Viewing 15 posts - 7,456 through 7,470 (of 9,241 total)