Thaks for the reply , how can we find the largest index in a database ?

thanks for the replies , I also need the database growth as well

Thanks to all for your suggestions ..

thanks for the mail , what is the reason of not creating index on 32 bit system?

I need technical reasons with irrespective of replication types

Thanks...

also what about the transactions if the principle is down ?

can provide an sample query to get the info

how to check the n/w connections ?

in C : we did not find installer folder and we got error .msi file is missed while upgrading Service pack

thanks .. can you send the query ?

I checked the healthy level of AG and its fine and we have only one secondary ..

Yes both are in sync ..

The paths are also same

k:\data

l:\data

We configured mdf's in K drive and .ldf's in L drive existing in both the nodes ..