Sorry, I should make this more clear. we have 30 servers.

For some important databasse with lots of transactions we do transactionlog back up every one hour.

some servers are setup to...

Thank you, both of your replies are very helpful.

We do regular transaction backup like every 3-6 hours.

Thank you, it's very helpful. and you explained so easy to understand.

Thank you, so you said to change to bulk copy recovery mode then do the rebuild index. Can I also change to simple mode recovery to do this? For this,...

Thank you all.

Sorry for the confusion, in this case, I do mean for generic question about transaction log, not related with my other thread, before doing that, I thought this...

Thanks, the SQL Server Agent Schedule Decoder link works.

And also when I right click the job, I can see manage schedule. But how can I export the list and do...

Great, thanks for the help

Thank you, does the install need to restart the computer after the installation?

Thanks

Thanks.

This is very helpful for me to undertand.

One point not sure is : when you say:"But if you've lost the Sunday full backup, those daily differential backups are of...

The last statement doesn't make sense to me, quote:"But again, you will be able to restore from log backups if you have all of those available."

So if someone deleted the...

Thanks, this is very helpful for me to understand the backup and restore.

I understand most of it, and will add it as a bookmark and keep checking it.

Thanks

Thanks all.

How long does it take to apply service pack 3?

Thanks

Thank you all

I found it's a bug in SQL server.

when I choose backup the following database, but next time when I open it, it didn't save the result.

I have to specific check...