I am curious if anyone has used dbcc forceghostcleanup on production and it caused any issues. Not looking to put someone at a liable state, just looking to see if...

Solved that... when I viewed my excel file under my domain name, it over-rode all role security access and granted acces to everything, with no deny. When I logged onto...

I used bits from both, and came up with a solution.

My issue was I had a role setup that I wanted to have denied a calculated member to a user...

That's about what I thought, just being clear. Perhaps my initial post should have stated something more explicitly. My main remark on "outside means" was that the suggestion of pulling...

Killing all power by pulling a plug in the middle of a read, with other failed hardware components... no problems as far as you see it?

Sudden power loss on a...

Shut down SQL Services first through config manager or command. Better to not risk database corruption in killing the service by outside means.

Also, you are rebuilding parts of system databases,...

I never thought I would be trying to perform and exorcism of ghosts as a DBA.

I have found a few more resources. Since the issue is recurring and I...

I don't see anything to repair with the backup table. The data size for that table is as expected. No new data is going into that table. It is not...

Oh, and yes, the table is still around. It was not a temp table, as I used it as a backup first in case the records were needed. The above...

If I can't find an online solution my plan is try and select top 0 * into sysjobstepslogs2 from sysjobstepslogs, mod the table to reflect correct constraint on pkey, create...

Temp Table: 113 rows

namerowsreserveddataindex_sizeunused

TMPsysJobStepsLogs062211113 219064 KB219000 KB16 KB48 KB

sum datalength = 214144

Prod Table: 86 rows

namerowsreserveddataindex_sizeunused

sysjobstepslogs86 ...

Oops... len * 2... 2 bytes per character.

Thanks for the catch! Looks like the issue then is most definitely recurring! I will have to look into turning snapshot isolation...

Looks like this may go into a recurring issue for me and did not resolve the final underlaying problem.

select sum(len(log) * 8 / 1024) from sysjobstepslogs

go

sp_spaceused sysjobstepslogs

A rough comparison on...

Not sure what "base" refers to here, but I did

select * into [|TempStorageTableInCaseNeededLater|] from sysjobstepslogs

truncate sysjobstepslogs

jobstepslogs was then already refreshed soon after due to job processes running (within 10...

It does, and it was pretty trashed at the time. Though, it was on an int that supposedly only had 113 rows. I saw some other postings that rebuilding the...