Thanks a lot for all your reply.

Thanks a lot

Thanks a lot

i am on gmail, the id is deepu0608@gmail.com, u can give your gmailid

The Auto-growth has been made in terms of MB so i have given 100 MB as auto-growth

Hi,

I am using SQL Server 2000, i believe we use SP4 infact the reason for the DB to get...

Hi,

I tried this option but was not able to recover the suspect mode db to normal, please suggest if any other.

Hi,

I restarted the SQL server agents and i found the DB is Suspect Mode, so could you let me know...

Hi Thanks for the information, i will uncheck the auto-shrink option in the production database and will let you know regarding whether the problem has solved or not. Thanks once...

Hi,

I checked the space available in the disk for database and it is as follows:

Total Database Size

size 45011.91 MB

Space Avlbl 98.76 MB

.ldf size is 5.44 GB size on disk...

Hi thanks for the reply,

Even i checked with increasing the filegrowth size interms of MB , earlier it was 100 MB and i made it to 200...

Hi as per your sugesstion, i checked the space and it is as follows,

Size of HD remaining is 169 GB free and the all the db files stay in the...

Hi Thanks for the reply, i have checked the option autogrowth, couldnt come out of this error. Few more sugestions or tips please