To learn how to perform a server-side trace, and for other Profiler advice, check out my free eBook, "How to Become a Profiler Master" at http://www.sqlservercentral.com/books.

Currently, there is no way to download these videos.

I'm a big believer in keeping production databases in the full recovery mode, and then performing nightly fully backups, and hourly (or more often) transaction log backups. If you are...

Below are some quick answers to your questions, but keep in mind, that these suggestions are generic, and may or may not be the best for your particular situation.

Q: How...

I have worked in a number of organizations where the IT management was done by accountants who had no understanding of technology at all, other than what they read about...

Thanks for all of the thoughtful feedback. I purposely didn't say what I do to relieve stress in the editorial, as I didn't want to influence anyone. While I can't...

Maintenance Plans are far from perfect, as you have discoverd one of their many problems. On the other hand, if used are appropriately, they can be very useful. I have...

tibor_karaszi (1/11/2010)

---

Mani,

Consider using Ola Hallengren's scripts: http://ola.hallengren.com/%5B/quote%5D

I often incorporate some of Ola's scripts inside my Maintenance Plans, running them as "Execute SQL Server Agent Job" tasks.

I'm using maintenance plan for database Integrity check.Could you please tell me what the difference in performing Integrity check using T-sql code (dbcc checkdb (dbname) with no_infomsgs) & Maintenance plan...

In two of the presentations I regularly give, I emphasize the importance of maintaining backups that are restorable, including the need for storing backups offsite and regularly checking to see...

You can download the presentation I referred to in my previous post at: http://www.bradmcgehee.com/presentations. It is located near the bottom of the webpage.

Jeff Moden (12/1/2009)

---

Interesting and thoughtful editorial you wrote there, Mr. McGehee. I'd like to add a 3rd category instead of just the Giver or Taker catgories... Receiver. It...

Madeline.Jean (11/30/2009)

---

I'm not a DBA, so I do my volunteering where I actually have some expertise to provide. I appreciate the instruction on using data bases that I have...

Thanks for...

I have to say that I have not seen this behavior before, and I am not sure what to suggest, other than to use the Profiler GUI. Hopefully some other...