Sugesh, your script doesn't show multiple instances on one box. Also, it's showing databases that are off-line or suspect (which may or may not be desirable, for me, I...

How about a moderately fast used P3 or P4 laptop? Bob Johnson.com has some pretty good deals. And if we happen to own something better (I'm using...

If there's one person whom I wouldn't want as a role model, it would be Bill Gates! I don't know of any computer industry tycoons that I'd like to...

My normal work is as a DBA with some development, I spent a year doing SQL development with zero DBA work for a state agency. Pure database development and...

I always recommend half.com as a source for used books. I've gotten some great deals from them. They're generally comparable to Amazon's used sellers. I've only been...

Besides, isn't that our job as database developers/administrators? Overthink in order to not underestimate?

Not that I'm picking at nits or anything...

Glad I could at least help indirectly. One of the best things about having peers (such as this forum) is that you can bounce ideas and it might inspire...

Stupid reply-eating so-and-so system....! That's twice this week that it's eaten a reply!

David, I totally missed the point that part of your original question was the benefit of full...

David, you might want to make sure to copy your transaction log to alternate locations, just in case. I copy my tlog backups to a SNAP server after they're...

Yeah, I meant to ask how big of a DB you were dealing with. My biggest DB is only 140gig, and it's not a production DB. My biggest...

I use xp_sendmail to send my DBCC results to me every night, in my case the message has no @message contents. If your text has single quotes, I would...

Good answers, Mark. I would assume that the job has been tested to have appropriate rights to the backup device. Regardless, the question is bad because it doesn't...

I think your plan looks reasonable, the only way to know is to try it. Are you using a backup agent? A lot of people prefer backing up...

Thanks, Karl. I think those are acceptable reasons in certain circumstances. Fortunately those circumstances don't apply here.

The server has a high-performance...

Thanks, Cary! I guess it's been a while since I reviewed the logic behind backups. For some reason I was thinking that a full data backup would invalidate...