Viewing 15 posts - 3,331 through 3,345 (of 9,241 total)
karend211 34657 (4/28/2014)
Why would you need a new server just because sql server won't start??
I am thinking worst case scenario & want to be prepared & have a plan for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2014 at 11:10 pm
karend211 34657 (4/25/2014)
I need to better understand under what circumstances you would rebuild versus restore the system databases?
If you wanted to change the system collation.
karend211 34657 (4/25/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2014 at 12:19 pm
You'll also need to drop any constraints on the columns before you alter them, see books online for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2014 at 11:11 am
SQL!$@w$0ME (4/24/2014)
I have an urgent requirement to implement encryption (Data at rest) for our SQL 2005 instance. Please let me know your thoughts if I can accomplish this through SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2014 at 10:57 am
are you using shared storage?
in one scenario previously, i had a set of LUNs presented to server A and it turned out they shared storage pools with another server B....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2014 at 5:24 am
please provide futher info from this file
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140417_191232\Detail.txt
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2014 at 5:08 am
lilywhites (4/22/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2014 at 10:20 am
lilywhites (4/22/2014)
recently we have been having connections getting through in-between the log restores and causing issues.
What issues have you been experiencing?
Can you post the output of the following query run...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2014 at 5:17 am
this is the default setting for all cluster resources, just something to be aware of
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2014 at 5:13 am
Benki Chendu (4/21/2014)
Yes. It is listed as a possible owner..
possible owner of which resources?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2014 at 1:42 pm
Benki Chendu (4/21/2014)
Perry Whittle (4/20/2014)
Benki Chendu (4/19/2014)
The operation failed because either the specified cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2014 at 1:41 pm
Why not just use log shipping, seems it would be perfect for this scenario.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2014 at 6:33 am
Just a tip, change the ALTER PROCEDURE to a CREATE PROCEDURE and the script will execute.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2014 at 3:36 am
have you first added the new replica to the AlwaysOn group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2014 at 1:32 pm
That will just force a regeneration of objects protected by the service master key. Have you created a database master key in master yet?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2014 at 1:08 pm
Viewing 15 posts - 3,331 through 3,345 (of 9,241 total)