Thank you, will do

Thanks, good suggestions.

I will go with developer one then

Thank you all.

I did run a dbcc checkdb and it is the only error:

The In-row data RSVD page count for object "V420_XYF_LOGS", index ID 0, partition ID 62231571398656, alloc unit...

Thank you all for the suggestions

Thank you everyone for the answers, it's so much helpful.

I will keep these in mind.

I love this forum! There are so many talented DBAs here.

Good to know, thank you.

I like native tool also. It's fast to access and recover.

Our network guy suggested using Microft Data protection manager to direct do the back up...

Yes, I have some time reading and studying today.:-P

while I'm reading, I find questions, thought this site is really a good one to get help.

Thank you

For monitor, I mean monitor...

Thank you,

I will watch the video later tonight.

For now, could you tell me what usually is the best practice to run dbcc checkdb? every day, off hour or others?

Thanks

Thank you.

By the way, for the backup files, do you use native tool to backup or use third party tool to do it?

What is the better option?

Thanks

Thank you all

Thanks, Old Hands.

It is good to know that you are happy with your DBA jobs. I hope I like it too.

For the book, you said ignore pro-develop, not sure what...

Thank you.

I just did a search for Sql server internals, I got two books.

the Microsoft SQL Server 2008 Internals (Pro - Developer)

Does this mean a book for developer?

There is another...

Thanks all for your suggestions.

I will order the SQL server Internals and Trouble shooting right away.

I like sql server so much is because it seems there are so many learning...

Thank you!

thanks,

But I got no records. There are acutally 50 records in the table for today.

The whole query is like below:

SELECT ParentUsername, ParentPassword,...