Yes SQL Server service account has "Lock pages in memory" rights.

Hi,

Everything is done........but when i run dbcc memory status & sp_configure it showing AWE allocated is zero.......

i have ru dbcc memory status commad and sp_configure after enabling the AWE.its just showing AWE allocated as zero.

Hi,

its an enterprise edition, windows2003server and 32-bit.

yeah i have /pae switch in the boot.ini file.

i have restarted the server after enabling.

hi,

Let me try with your suggestion.

Thanks to Balmukund Lakhani & vidhya sagar for giving a suggestion.

Regards,

ajay

Hi siva,

   siva just see in MSDB database (system database) -->tables -->system tables -->dbo.suspect_pages.

Run a select query (select * from dbo.suspect_pages).it will display all the corrupted files.

regards,

mighty

hi,

database .mdf files are not expanding .even i enabled auto growth.can someone tell what would be the problem & provide me the exact solution for this.

 thanks,

ajay

Hi crispin,

   i enabled unrestricted autogrowth on database.after growing to 5mb. it is not growing automatically.The space available on database is 0MB.

Regards,

ajay

i'm not able remove mirroring as principal databaase is not showing as principal status.now the status of the database is empty nothing is there.if at all i want configure any...

 i gone through u all suggestions.still i'm not able to delete or make any actions on mirrored database.

u just delete the inactive transaction logs i..e transactions already recovered.

try this it might help u .

***ajay

hi, 

sugesh now i'm able to post the question.n i already post a question regarding database mirroring.can u help me.

thanks,

ajay