question

GMC avatar image
GMC asked

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
shrink-databasedatabase-files
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

GMC avatar image GMC commented ·
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 !!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.