Thank you, it is a great help

I just found out in SQL log there are some records like:

Setting databaes option ANSI_Padding to ON for database ...

Starting up database auto_upate statisticst to Data base Metadata

Setting database options...

Thanks.

This is a maitenance plan for many databases, is there a way I can find out which database got changed from Simple to full, or an explicit truncate log....

Thank you, both. I understand GilaMonster's post, Yes, that are the only 3 transactions backup.

We have also a senoria like this:

We copied a datatbase from production server to a testing...

Thank you!

I figured out. Thanks

Thanks, But there is no any error related with the transaction log backup.

I just did a manual run, and it immediately failed. The job history is as follows,

Date3/14/2011 2:29:03 PM

LogJob History (MaintenancePlan.Transaction Log Backups)

Step ID1

ServerMy server

Job NameMaintenancePlan.Transaction Log Backups

Step NameTransaction Log Backups

Duration00:00:06

Sql...

Thank you, P Jones. I understand DBA will do quite a lot restore to developer or test server.

I have a couple of questions, when you say change them to...

Thank you, what other T-SQLs for everything DBA needs to do for daily jobs?

By linking database to Source control system, will that affect performance of sql server?

Never used source control sytem before, should the tool only be used on development server but not...

Thank you, when you say run a server trace, is that using SQL profiler?

One time when one of our servers got a hang or ran very slow, I tried to...

Thank you, I prefer online articles.

But if there is a book, i'm interested too.

Thank you

Thank you all!

Thank you, it's very helpful, I will definitely check into that.