If you're using files as opposed to devices for your backups, you can simply browse to the backup folder and delete the *.bak files in question.  If you're using a...

Take a look at the sp_trace_setstatus topic in Books on Line.  You could write a command to open an isql session and use this to set the status to 0...

Actually IIRC, the checkalloc can be dropped as well if this is SQL Server 2000. I believe the checktable and checkalloc functions are both incorporated in checkDB with 2000.  This would...

AFAIK, there's no way to tell.  And you can't use an extended property on system objects otherwise you could assign one there.

I know Sybase 12.5 has a crdate column that...

Sushila,

Nice job.  This topic has been kicked around quite a bit at my workplace over the past several years.  Unfortunately, executive management feels like they can't control us if they...

Does this happen regularly, or was it just a one time thing?  Take a look at your SQL Server Agent logs from Enterprise manager and Open log Archive#1 and you...

LOL...waiting for SP4a?  

Fortunately (or not) for me my hands are tied.  Our vendors have to sign off on it before it can be...

Oops.  Just realized that you were talking about EM and not QA.  I'm not sure if there's a way to do this without changing your default location for all Explorer...

From Query Analyzer, select Tools, Options and look at the General Tab.  This will let you specify a default location for both your Query and Result files.  Is that what...

I have to agree - Wow, and my hat's off to you Steve! 

Not only are the rankings forced in a situation like this, but if your rankings are then...

Interesting.  'Error not found' isn't much help, is it?

Can you contact a network admin and have them verify the restore status by running Enterprise Manager directly from the console?  Or...

Forgive I'm stating the obvious, but OS error 3 is a 'Path not found' error.  Have you verified that the file actually exists in the folder where SQL Server is looking...

Why not use Enterprise Manager and just create a maintenance plan for each database?  That way you can schedule them when you want, specify the backup location and job options...

In that case, article #3 is probably the best way to go for you.  But please note the cautions listed in that article and act accordingly.  Article 1 deals with moving...

The information you posted looks somewhat dated (6.5 I'm guessing?).  What about simply using the sp_attach_single_file_db method described in Books On-Line?  One caveat:  attach single file will only work if...