Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Kill Process Command

Status
Not open for further replies.
dzdncnfsd

dzdncnfsd

MIS
Jul 14, 2000
118
US
Yesterday, our network person created an incremental backup job for one of our SQL servers using Seagate Backup Exec. The job ended with an error but the process is still listed as runnable under "current activity" in the Enterprise Manager. There are several active database locks: 2 on the master and 4 on the database he attempted to back up. He rebooted the backup server, but this did not release the locks in SQL. I tried to kill the process, but it is still active. How do I get rid of the locks????
Thanks,
Gladys

Gladys Clemmer
gladys.clemmer@fifsg.com

 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Command to Display at Bottom Of Query Window.
Replies
2
Views
236
grnzbra
grnzbra
VijiKumara
  • Locked
  • Question
My 'Union Query is throwing Unknown Command 1
Replies
4
Views
394
VijiKumara
VijiKumara
SaltyTheFrog
  • Locked
  • Question
Rework process not to use cursor 2
Replies
3
Views
291
gbaughma
gbaughma
VIJSQL01
  • Locked
  • Question
Unable to Load the CSV file, using BCP command in SQL 2008 1
Replies
2
Views
198
VIJSQL01
VIJSQL01
rwsjbs
  • Locked
  • Question
Simple SQL Replace Command Help
Replies
1
Views
104
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top