When is too much success a bad thing?

I was talking to a customer the other day who had an interesting problem:  Successful backups. Specifically, their problem had to do with the success messages that SQL backup puts in the SQL errorlog and the system event log. Seems like a nice, friendly thing to do right?  Drop a note that your backup was… Read more

Fuzzy backups and RESTORE DATABASE WITH STOPAT

So what’s a “fuzzy backup” and how does it relate to STOPAT?   There has been some confusion about what RESTORE DATABASE WITH STOPAT does, if it works, and why it behaves as it does.  This is not about RESTORE LOG WITH STOPAT, but only RESTORE DATABASE.  To understand how this works and why, you… Read more