I am Sorry for replying late,

It was my mistake, I was trying to restore the database after renaming Log file since CRC check failure.

I deleted The database and created a...

Yes, its log backup.

I will enable the schedule and get back to you.

Is there any other way to the size of LDF file?

Lowell (12/25/2009)

---

could it be you do not have a regular backup schedule in place in that location, and that is causing your unnecessary growth?

the ldf is the log file. if...

Hi,

After removing Disk cache setting, It was bit relaxing, but Yesterday, again once of the banch system reported database corruption. The eror log says

2009-05-28 12:46:15.90 server Microsoft...

Thank you, Paul Randal,Gilamonster and nilmov.

I will disable disk write cache, and keep it under observation.

Now I have introduced Back-up plan.

Thanks again for the support and knowledge bestowed on...

nilmov (5/15/2009)

---

As you said that the DB goes to suspect now and then and also the h/w check came clean.

Only thing I can think of right now is disk...

Yes, I have checked and attached screen shot of the settings.

Enable write caching on the disk...

I agree GilaMonster. with the help of links provided by you and Paul, Now I am working on back up plan.

GilaMonster (5/12/2009)

---

Have you checked for hardware-related errors in the system...

Yes, My...

Thanks for the link Paul.

When my application starts, Physical files back-up is taken(auto). But the problem is transactions entered after back-up. There is no backup plan strategy, now...

I forgot to mention, I am not doing regular database maintenance like shrinking, re indexing. The database size is apprx. 1.4 gb

Yes, But I didn't find any thing. This is not happening in one place/System !!

No Idea. Actually my application uses 5 databases, for past 2-3 months I have observed minimum 3-4 times database in suspect mode in each branch, and corrupting database in not...

Aftermy post system restarted many times. I dont have previous error log file. But when it happens Again I will make sure i will post both