Viewing 15 posts - 5,041 through 5,055 (of 9,241 total)
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
Jpotucek (9/10/2012)
why didn't I hire MS professional services for this!!!!!!
No need to pay over the odds, You just merely need to hire a good contractor to design\install the system...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 1:32 pm
You dont have a quorum resource for each instance installed, the cluster as a whole at the windows level has one quorum resource.
The resouce can be node majority for odd...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 1:08 pm
Jpotucek (9/10/2012)
can anyone same MS Professional Services : )
don't understand, what does this mean?
Jpotucek (9/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 9:25 am
Viewing 15 posts - 5,041 through 5,055 (of 9,241 total)