Viewing 15 posts - 5,041 through 5,055 (of 9,244 total)
are you using the default mirroring timeout value?
What is the result of the following query?
select mirroring_connection_timeout from sys.database_mirroring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 3:04 am
Quite, the encryption hierarchy has to be in place before policy based implementation will succeed
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 1:23 am
Lynn Pettis (9/11/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 4:09 pm
jdbrown239 (9/11/2012)
Thanks Perry.How important are these messages in the checkdb results?
Perry Whittle (9/10/2012)
Personally, i would revert to the clean backup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 3:19 pm
you could turn on your firewall and block incoming traffic to the port sql server is listening on
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 12:22 pm
if you specify a check TDE policy it will log when the policy has been violated. When manually evaluating the policy you have the option of applying the change to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 12:12 pm
The later recommendation is actually files equal to 1\4 - 1\2 the number of CPU cores
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 4:28 am
S-322532 (9/11/2012)
Hi Perry,Yes, we have. Kindly tell me what should i do ?
Ensure that it is running successfully, check the job history to ensure it doesnt fail.
A common problem I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 2:03 am
S-322532 (9/11/2012)
Hi,The recovery model is FULL
Do you have transaction log backups in force for this database either via scripts or a maintenance plan?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 1:35 am
You'll find all the required info in Books Online here and here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 1:34 am
Another thing i would do with some urgency is to audit all user databases and find which ones are set to simple recovery and then query the business to have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 1:30 am
what is the recovery model used on the database?
When running in full recovery you must ensure you have transactioon log backups in place to truncate the inactive portions of the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 1:24 am
The reality is, if you don't have the load then you dont need to it's more a best practice. This has been blogged many times by many different people.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2012 at 1:21 am
jdbrown239 (9/10/2012)
Wouldn't last nights backup have the same corruption? If so I would have to use one from a few days ago.Would DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS fix the issue?
The corruption...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 3:49 pm
you're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 2:52 pm
Viewing 15 posts - 5,041 through 5,055 (of 9,244 total)