November 19, 2012 at 1:18 pm
The irony here is that we deleted all of those records so that we could save space. But obviously that never happened.....
I learn something about SQL Server every day -- sometimes it completely reverses the concept you had of how it worked.
Thanks again to all who offered help.
Best wishes,
sqlnyc
November 19, 2012 at 1:19 pm
sqlnyc (11/19/2012)
Guess I'll have to do some research as to why they're not getting cleaned up in production.
Sql server version may be the issue, check for any patches that may resolve issues with ghost cleanup.
Paul gives some great guidance on how to troubleshoot ghost cleanup on his site.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2012 at 1:31 pm
sqlnyc (11/19/2012)
The irony here is that we deleted all of those records so that we could save space. But obviously that never happened.....
The ghost cleanup is a periodic background task. If it kicked in and tried to remove all the deleted data it would likely swamp the server.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply