I've always monitored from a server other than my SQL server. Also, be sure you have sufficient disk space to hold the PERFMON log file. It can grow pretty large (although,...

I'd also suggest going back to Bloomberg. As a vendor of yours (who I'm sure you're paying very handsomely), they shoud not subject your DB to any kind of integrity...

Simply issue a backup of the database(s) to a different disk on the server (or totally to another server). Once the new disk is in, simply restore the database(s). Or...

If you're doing all the tables in the database, your can use a maintenance plan to perform it as well. Create the plan with the wizard, schedule it as frquently...

I use UNC paths. What version of SQL are you running because this was not available in 7.0? Also, it's my understanding that MS doesn't recommend doing this (but we...

When looking at the sp_ solution, I notice I only have data in sysjobhistory going back about 3 weeks. I guess if I run the sp_ going forwar to a...

try something like this:

select substring(ad.account_number,1,2)as AcctPreFix, count(*) as Total

from annual.annual_account_detail aad,

common.common_account_detail cad,

annual.annual_status aas

where aad.ar_id = cad.account_id and cad.account_id

Group BY ad.account_number

Just a note, if you're backups aren't done, and put to tape, and you have a major crash and cannot restore the data, they are going to look at YOU...

If Tivoli has the file locked when it's backing up  it will cause your SQL backup to fail. Try to avoid any contention with respect to file locks on the...

Paul, if you run sp_configure on both servers, is everything the same (or at least similar)?

Any other cool commands like this that you can think of? I know they're in BOL but with everything in there...I can't tell you how many times I've seen this...

I figured that was the table but I expected a column called model or recovery or somthing that was a little more explainatory. Thanks for the quick response.

FYI - from my Query Analyzer, both shift-F1 and F1 bring up BOL.

The database was originally full. Someone changed it to "simple" during the course of the day (without my knowledge) causing the job to fail. Had I been alerted to the...

I've added a filter to ELM to trap the warning so I guess this issue is closed. But still, does anyone have any idea why it doesn't log to the...