GilaMonster (8/22/2013)

---

Is once a month often enough? Do you retain all your backups (full and log for month)? If not, what do you plan to do if the CheckDB picks...

Thanks for clarification,

I am going to configure DBCC CHCKDB for all database t monthly once.. could you suggestion me? shloud I go for thru maintenance plan or Mr.ola-allengren coustmize script?

I want to know one things,

Enable - Checksum option

if corruptions happend that database by automatically Database backup also failed, so we comes know and checking in error log any...

Hi Steve Jones, I have doubt CHECKDB and CHECKSUM.

DBCC CHECKDB - it is allocate the huge resource for checking database Integrity & consistancy operation.

CHECKSUM - it is verify page level...

I got it....

In my case current service pack is (sp1) already updated on Instance.

I could install SP3 only and not required latest CU12..

In SP3 included that hot fix as...

ok.. Thanks for replay

First update SP3 and then apply latest Cumulative update package 12 for SQL Server 2008 SP3, is it correct ?

Ok..

That error was fixed with CU6 of SP3.. SQL SERVER 2008 32 bit

Pl. confirm as below steps for updating SP3 and CU6

1. Install SP3

2. Install CU1, CU2....CU6 ( i need...

Thank you for replay

As per BOL, forcing service facilitates resynchronizing the databases (with possible data loss) when mirroring resumes and make it mirror database online..

Is it possible how much data...

I have doubt.. I have Mirror setup manual failover without witness server

If Principal server is down due to N/W or H/W issues, In this cause mirror database condition is Restoring...

Hi

ALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Instead of above query, can we run as below query for make it online in MIRROR Database..? Mirror database always sychronizing/Restoring mode. wheather High performance...

yes correct as Gail told enterprise edition took online recovery while restart the server..

Standard Edition few months back i noticed that recovery on offline mode on Transaction log file 35...

Resolved that isssues due login permission CONTROL and ALTER with master database

Revoke ALTER and CONTROL permission in Master database.. after that SQL Services started successfully..

Thanks

No more problem addressed even query working fine with 00:00:02 seconds and DISTINCT cost 72%..

Thank you..

Hi, ChrisM@Work.. wow what a understand that update query logic..Absloute correct...

Hi, Eric M Russell.. SSMS - actual execution plan suggested to create one Non clustred index, that was created... (index...

ok.. I will update you once getting from Dev.Team for the all details..

thanks

ananda