Did somebody say ascii gopher?    

             xxxxxxxxxxxxxxxxxxxxxxxxxxxx

          xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx     __

        xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx//

       xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx((_  )x

      xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx_xxxxx

     xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx(o)xxxxxxx

    rrxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxo

   rrrxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/|\xx/

  rrrrxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx__/x|

rrr   xwxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

rrr      wwwxxxxxxxxx ..                    xwwww...

rrr       ...

I haven't tried it myself, but you might be able to do what you want using the RESTORE with MOVE option, then specify the same filename for both files of...

I personally tend to leave the system databases (master, model, msdb) in simple recovery mode since that's the way they install and then take regular full backups of these.  They're...

Another thing.  If your databases are set to simple recovery mode transaction log backup are not allowed.  Master and msdb are set to simple mode by default when SQL Server...

If the backup jobs fail, the older files won't be deleted as this is the last task that the jobs attempt.  You'll need to find out what's causing the job...

Check that.  I just re-read the post and realized you're using 7.0 so try sp_who instead.  I don't believe sp_who2 was available until SQL 2000 came out.  Best of luck.

Have you checked Task Manager on the server to see what process is using all the memory?  If SQL Server is the culprit, you can check what's going on using sp_who2...

Well I believe chalk is also a great antacid, so maybe you were destined to be a DBA from childhood.    I believe the...

Paste.  I was referring back to the post about eating crayons.  When I was in grade school (longer ago than I care to admit) that's what we ate instead of...

I go to check my mail this morning and there's like 30 notifications for this thread.

Sorry I missed out on all the fun, but I've been busy sitting in a...

Well 4 heads are better than 2 aren't they? 

Just a quick off the top of my head look at your configuration makes me...

Just my 2 cents, but I'd be very reluctant to cancel the process with any of the repair options turned on.  The result may leave the database in an inconsistent...

And at least a gender battle hasn't broken out..........................yet.

Don't forget philosophising...even if it wasn't sucking up. 

I didn't know what to make of that.  But I thought what can a little humor hurt?  Or maybe it's just a case of "Fools rush in where angels fear...