tags:

views:

9

answers:

1
Q: 

Delete redundant MOSS content database entry

In a sharepoint content database we have noticed there are a couple of records in the all_docs table that reference documents that no longer exist. The listid guid that they are associated with is not in the site so we have no way to view them and delete them. I think this was a result of moving a content database from another environment into this one.

Can anyone suggest the best approach to clean this up? I need to delete it as it is referencing a page layout that I cannot delete until this page has been removed.

Thanks for any suggestions

A: 

Have a look at Fear and loathing, it describes an undocumented stsadm command to delete an object by its id.

Timores  2010-03-15 17:01:13
Can this be any object or is this specific to timer jobs? It says it cannot find the object when I pass in the GUID from the ID column in the database
78lro  2010-03-16 09:29:02
It is not specific to timer jobs, as a colleague used it to delete an invalid AAM mapping, but the full extent of its usage is unfortunately unknown, sorry.
Timores  2010-03-16 11:32:17

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL