• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 644
  • Last Modified:

How do i know if database shrink is running

hello all

our support guys dialled in and are running a shrink on our mdf file.
its been running since this morning but still not finished.
basically i know nothing about SQL but can someone let me know how to see if this shrink is still running that it hasnt stopped or hung.

in processes i can see "sqlservr.exe" running and is fluctuating between 2 and 6 percent on CPU usage and using over 1.7Gb on mem.
is this it or not.

oh its sql 2000  

2 Solutions

run that in query analyzer and look in the command column for (I think) dbcc shrinkdatabase or shrinkfile
run this query and check the status field.
select * from master.dbo.sysprocesses
where program_name like'MS SQLEM%' and cmd like 'DBCC%'
SoHandyAuthor Commented:
hey guys

the operations did hang on us yesterday it was taking too long.
our support guys just stopped it in task manager.
i am going to give you bith points as i cant test it now.
thanks for the help

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now