x

Error while shrinking warehouse Database

Hai, I got the following error when i tried to shrink my warehouse database in my job.

"Msg 3140, Level 16, State 5, Line 1 Could not adjust the space allocation for file 'WarehouseDb'. Msg 3023, Level 16, State 2, Line 1 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed."

But neither i was using those files nor i was running out of disk space.I have arround 43GB free space on my drive...

and also let me know what system phantom health records are because one of my maintainance plan deletes these records
more ▼

asked May 15, 2011 at 11:46 AM in Default

GMC gravatar image

GMC
85 6 8 10

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

Some other operation must be currently occurring for this error to be evident. Check sys.dm_os_waiting_tasks and see if there are things currently waiting on the system. Something else has to be running.

As far as the deletes goes, I don't understand what you're asking about.
more ▼

answered May 15, 2011 at 12:01 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
98k 19 21 74

when my Job is running i came across this in profiler "SYSTEM PHANTOM HEALTH RECORDS ARE DELETED".my job has nothing to do with this.I was wondering whether are these system generated records !!
May 16, 2011 at 11:03 AM GMC
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x35
x12

asked: May 15, 2011 at 11:46 AM

Seen: 2903 times

Last Updated: May 15, 2011 at 12:02 PM