Archive | Recovery RSS feed for this section

Manage Your Transactions (So they don’t manage you – Part 1)

by Mike Walsh on 09. Apr, 2009 in Best Practices, Pet Peeve, Recovery, SQL Server, Shrinking & Transactions, Syndicate

This is part 3 in a series on shrinking and transaction management. Click here for part 4. You can see them all in the Shrinking & Transactions category.
If you are one of the people who have been reading this blog, you know where I stand on shrinking databases/log files. I don’t like the practice (Post 1, Post [...]

  • Share/Bookmark
Read full story • Comments { 4 }

Do you focus too much on your backups???

by Mike Walsh on 14. Jan, 2009 in DBA, Pet Peeve, Recovery, Syndicate

Have you lost your mind?!
What could I possibly mean by that title? I’m a DBA… One of the basic tenets of a DBA is “backup, backup, backup”, right? Well sort of…
Far too often I hear people asking questions like “will this setup allow our backups to be fast?”, “how is your backup process working?” or [...]

  • Share/Bookmark
Read full story • Comments { 6 }