why are you shrinking the DB which will cause the log to grow and index will be defragmented

so you have to do reindexing after that which will again grow...

Suri, this is not a local forum. you may not get appropriate answers/delayed answers.

check with your friends/local search engines.

.

good explaination, i was confused whether this will be work...

No DBCC checkdb error and no backup error - strange

now i dont have any clue..

with 160 GB free space have you recently deleted/ moved any data from tables.

with big DB kindly shrink and reindex the db and update stastics during the non production time.

if...

Any error on SQL Server error log and system event log at that time?

try taking manual backup and post the error ,if any?

now what is the autogrowth option set to?

move it to active- active cluster.

this is not exact load balance google for more details i am not an expert in that.

what is the cpu usage of db server at...

As antony said it will scater your data and indxes has to be rebuild and most important it will grw again on most of the cases.

Kindly dont think that shrink...

is it applicable for license renewal? or is it for new purchase?

do you have anything for sql 2005 licensing

or sql 2005 license to sql 2008 r2

or sql 2005 lciense to sql 2012

Hello ,

hope 100 pages can go up to 200000 records, instead we can ignore till 500 pages.

i have speciefied 20 pages to have the fragmentation to get reflected properly by...

6, 7 & 9. A private consulting company had just done a review of db performance. From what they left from their traces & analysis the main culprit seems to...

what are the number of pages if it is less than 20 hopefully ignoreable.

as you have reduced it to 1000 rows it is a smaller table now.

Hope MS MapPoint is a data intergration and visualization product. and sorry i havent used it.

do you have huge number of servers to main that data in that.

what is the...