Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 2 backup threads in a wait state

Author  Topic 

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2012-06-29 : 15:43:13
SQL Server 2005 Standard Edition.

We use Netbackup to backup our Databases directly to Tape.

I have 2 Databases that have not been backed up in 2 Days. One is the MASTER Database and one is a user database.

When I look in the activity monitor on the sql server,
I have Backup threads for these 2 Databases that are in a SUSPENDED status with a wait type of BACKUPTHREAD


Is it safe to cancel these threads???

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-29 : 16:37:17
Yes kill them.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -