I resized data file gorwth setting 5 GB then after 5 hrs data files grown upto 642 GB.

Already configured on each table for capture data growth on daily basis with history data.

verifired the history table that Image table row size has increased 1GB on daily basis.

yes. backup file also increased some GB size.

Daily incremental backup. and monthly full backup due to disk free sapce capacity.

This database there is no data retention period also management not accepted to delete old data for identified block listing people.

Data format is storing binary and encrypt format for Photo...

Could you confirm me, Does it support /3GB switch on HyperV serve in Guest OS windows 32 bit?

As per MS Link PAE x86 does not support HyperView server on guest...

Thanks for provide that script..

Thanks for provide that Link. HyperV best pratices.

1. PAE x86 system can applicable on host operating system and it allows using more than 4GB.

2. PAE x86 virtual system can not...

one more help.. as per attached SQLDumper log, is it missing patch level on SP3? Pls. confirm

current version

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86) Sep 22...

Thank you so much for your help.. I have done successfully all the action.

DBCC CHECKDB ([Honeywell.MES.LimitRepository.DataModel.LRModel]) WITH NO_INFOMSGS, ALL_ERRORMSGS;

Command(s) completed successfully.

yes, immediate i will recreate constraint. drop and recreate it will take 2 0r 3 min times.

due to constraint not able to delete that index.

First drop that Uniqe key constraint and then it will allow drop that index..

Pls. confirm if drop constaint key if any impact...

Thank you, I found some blocking SPID and killed them, after that drop and create the new index..

But another one index not able to drop

Msg 3723, Level 16, State...

I could not drop that index, ..

TITLE: Microsoft SQL Server Management Studio

------------------------------

Drop failed for Index 'IX_OperatingLimitHighValues_EffectiveTime'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Index&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or...

I tried as below command but not clear that errors

ALTER INDEX [IX_OperatingLimitHighValues_EffectiveTime] ON

[Honeywell.MES.LimitRepository.DataModel.LRModel].[dbo].[OperatingLimitHighValues]

REBUILD WITH (SORT_IN_TEMPDB = ON, ONLINE = OFF)

go

ALTER INDEX [PK_OperatingLimitHighValues] ON

[Honeywell.MES.LimitRepository.DataModel.LRModel].[dbo].[OperatingLimitHighValues]

REBUILD WITH (SORT_IN_TEMPDB = ON, ONLINE = OFF)

go

ALTER...

DBCC CHECKDB ([DBName]) WITH NO_INFOMSGS, ALL_ERRORMSGS;

Msg 8952, Level 16, State 1, Line 1

Table error: table 'OperatingLimitHighValues' (ID 741577680). Index row in index 'uc_OperatingLimitHighValues_uid1' (ID 2) does not match any data...