you need to expand at the VM level, then do the same at OS level.

Do not use it - period.

see https://www.brentozar.com/archive/2021/11/nolock-is-bad-and-you-probably-shouldnt-use-it/

if you truly have to use it and the business has signed off on allowing potential bad data then use the Transaction level.

NOLOCK vs...

you can try shrink in 100 or 200 GB at the time - not advisable but would work -

the truncateonly is here in case you get lucky...

fix the queries and the indexes  - based on your latest threads that is where your issue is and the sooner you do it the better for everyone.

possible changes - in addition to what I mentioned on the other thread.

table C_B_CONTACT - likely the clustered key should be changed to be based on PARTY_ID...

it can take days to shrink depending on how busy the db is.

and I would expand that command - prefer to be specific about which files get truncated and to...

I may be wrong but this would only prevent LOG file shrink - not data file (which I...

what exact command are you using for it?

Tom - that is the perfect example of WHY code reviews SHOULD be done - the reaction that individual had would also be a good pointer to go and review...

did you implement the indexes I mentioned on https://www.sqlservercentral.com/forums/topic/query-filling-up-tempdb ?

some of them would help on this particular issue as well.

and while not necessarily the issue on this case replace that...

why do you say it does not work?

SMO, and that particular script (with a few changes required on the scriptingoptions block as it its missing significant items) is one of...

• This reply was modified 1 year, 11 months ago by frederico_fonseca.

this may not be the correct way but check https://www.mssqltips.com/sqlservertip/5437/adding-a-database-to-an-existing-sql-server-always-on-configuration/

why is it difficult? you just need to...

if you have them on sql_modules you will also have them as SP's - so a normal "drop procedure xxxx" on master will delete(drop) them.

(to be safe generate their definition...

this is the type of sql you should confirm yourself in a dev box - if it is wrong you will see the errors.

as for executing it blindly as you...