Viewing 15 posts - 6,796 through 6,810 (of 9,241 total)
sql server user accounts won't be affected but windows accounts including any service accounts may need to be addressed
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2011 at 10:34 am
Steve Jones - SSC Editor (8/16/2011)
Best advice, use backup compression first. If you have Enterprise Edition, you can use that
not available in SQL Server 2005, you will need a 3rd...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2011 at 10:32 am
Jeff Moden (8/17/2011)
Perry Whittle (8/17/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2011 at 9:56 am
DBAgal (8/17/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2011 at 8:44 am
Loss of the mirror
If the mirror fails, the principal continues functioning, but the mirroring state is
DISCONNECTED and the principal is running exposed. Once the mirror database
becomes operational, it automatically assumes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2011 at 7:57 am
Andrew Theodore (8/16/2011)
Just so everyone knows, restarting a second time allowed the DB to be shrank. Not sure why it didn't happen with the first reboot.
would of been handy to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2011 at 1:42 am
Its always been given bad press in the past due to the vulnerability. Its a feature hackers knew was there and could be exploited to harmful use.
I have an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2011 at 1:34 am
Have you configured the security for the mirroring session
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 4:31 pm
Have you configured the security for the mirroring session
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 4:30 pm
How are you configuring mirroring are you using scripts or the mirroring page on the database options?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 4:09 pm
That's not entirely correct!
High Safety - High Availability and High Safety - High Protection modes will still allow connections to the database even when there is a mirror failure.
It's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 2:53 pm
The OS rebuild when adding a new CPU only affected Windows 2000.
2003 and 2008 should be fine just ensure the multi processor HAL is loaded 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 1:47 pm
needed to see details of the configuration this morning not after you switched to asynch
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 12:07 pm
n.heyen (8/16/2011)
Currently only 12GB of RAM and only 2GHz on 1CPU allocated for SQL, just not enough.
I would of thought the RAM is ok, definitely ramp up the CPU to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 11:43 am
oops my bad, yes you need primary server too :blush:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 11:40 am
Viewing 15 posts - 6,796 through 6,810 (of 9,241 total)