SQL Jobs Hanging...

From: Daijon (daijoha_at_yahoo.com)
Date: 03/25/04 

Date: 24 Mar 2004 21:10:30 -0800

Hi,

The Jobs in my sql server 2000 are hanging.The backup job backs up all
the 30 databases except 2 of them,but the job never completes.
I have to cancel it each time.I dont find any errors in the Win Event
viewer or SQL error logs.When I use check db on tempdb
I see two temp tables with the name ##db_maint_plan_lock_db_test and
##db_maint_plan_lock_db_SBtest. I suspect that there some locks
holding up the databases,
which may be resulting in a bottleneck.I also found out that these two
databses test and sbtest are not backed up.Is it safe to drop these
temp tables .
What can be done to correct this problem?

Please help

Thanks
Daijon

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL Server 2000 from NT4.0 to Windows 2003
    ... Detach your existing user databases, ... user databases (or RESTORE) to the new server. ... > Hey Steve, ... Windows 2003 will not allow SQL Server SP less than 3. ...
    (microsoft.public.sqlserver.server)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... MDB is friggin dead.. ... SQL Server has taken over the world. ... than read-only access to central company databases. ... I learned to write queries in Access after an hours' ...
    (microsoft.public.excel)
Quantcast