Thank you for the advise. I changed to simple and ran DBCC shrink.

The db will stay as simple for right now,but I want to make sure, it sat right. Here...

1.Do I switch to simple and then shrink the file?

2.What is the syntax to run it? Thank you

It means that you aren't properly managing the size of your database files more or less. Your database files are set to autogrow to prevent the database from running out...

I am in the process to find out if they ok to loose a full day of data. So if they ok,should I switch the recovery to simple? Thank you

Thank you very much, it is a great article, but what I don't understand, if I have db set to full recovery, is it nessary to set up transaction job,...

Thank you:-)

Ok for the system and db should I have the same things check?Do I need to check Update statistics?Is Database integrity task takes care of integrity and optimization together because...

No, I don't see any errors anymore this is was only one time when transaction job ran.I wanted to know why is this happening and do I need to do...

CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'. So is this mean that these error happend after restarting. I have transaction job running at that time

It has name of the category that SQL Server doesn't have

Thank you everyone, so just to be cleared, Here is the order:

1.CheckDatabaseIntegrity

2.Update Statistics

3.Reorginize Index

4.Rebulding Index

5.Cleanup History

6.Maintance Cleanup Task

(Is this order ok for system db and user db?)

My back up runs...

I know how to create with wizard, but it does it and export it, but how can I save it and call it from the job?

thank you

Thank you, it is working, Can I convert float to numeric?

Ok, I changed from money to numeric(10,4). Before data looked $967.69 and now 967.0000.What is the solution?Thank you