@Thwap!  @=)

My predecessor was 6 feet plus some inches tall.  The desk and chair were sized for him and I couldn't wrestle the desk loose and reset it by myself. ...

Virani,

Rather than opening up a backup window from right-clicking the database and choosing "Backup", you should either use the Database maintenance Plan to create and schedule automatic backups or create...

Actually, your code is just sample code.  It doesn't include a description of what you're doing with the code.  And there is no real life example included with it, which...

<GROAN!>  Steve, you're killing us!

@=)

Other perks, ability to work from home while waiting for the Maytag repair man / cable guy / etc.

Oh, absolutely.  And you might want to check the properties of the log too, to make sure that it isn't set to unlimited growth.  An out of control Translog can...

Without testing, I honestly couldn't answer you on that.  And truly, I don't think there is a ratio of database to transaction log out there that is a standard. 

Transaction...

I don't know, Michael.  I've never seen a situation in any of the jobs where I've worked when a Cross join was needed.  Usually, in fact, people are adding them...

So maybe it's not that DBAs in general are more scarce this year.  Maybe it's just good DBAs that are scarce.  Would that be a fair assessment?

Actually, I'm sure Backup Exec can backup open files with no problems.  Open text files, .doc files, .xls files.  All of which are not SQL Database files. 

So you just...

Oh, I forgot to mention...

Just because the client is doing full backups doesn't mean they're doing transaction log backups.  You can do one without the other (though it's not advisable). ...

Does Backup Exec actually make SQL database backups or is it backing up the .mdf and .ldf files from the server?

If the later, then your client has a problem.  Databases can't...

The problem with the shopping list ads is that contracting companies take them seriously and won't submit you for a job if you're missing what they see as the important...

Naqaraj, you should really open up a new thread about this error instead of piggy-backing on a thread with a different subject. 

People who read this thread are expecting to...

You can't do a log backup and a full backup of the same database at the same time.  One will be held up until the other finishes and they may...

Here's an example.  TableTime has two columns, TimeID and a datetime column.  It is updated every month with the most recent month-end date (for accounting).  You want to pull all...