Hi,

When I run the commands below, I get an "9100 Fatal error" message.

COMMANDS
-------------
truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
DELETE {databaseOwner}{objectQualifier}SearchItemWord
DELETE {databaseOwner}{objectQualifier}SearchWord
DELETE {databaseOwner}{objectQualifier}SearchItem

ERROR MESSAGE
--------
System.Data.SqlClient.SqlException (0x80131904): Warning: Fatal error 9100 occurred at May 22 2013 2:06AM. Note the error and time, and contact your system administrator. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String ConnectionString, String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String connectionString, String script) ClientConnectionId:dcf511d4-03aa-4841-9012-998ef39f7835 truncate table dbo.SearchItemWordPosition DELETE dbo.SearchItemWord DELETE dbo.SearchWord DELETE dbo.SearchItem
--------------

It seems the indexes are corrupt?
For this I need to "re-build" the indexes or, to do a restore of the database from an earlier date.

Questions:
1.
Is it simple to rebuild an index?
Somebody has an example how to do?

2.
Can I restore only the database or must I restore the file structure at the same time?

With regards, Ton Hermes

---

Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com

Hi,

I have done a restore of the database and files.
Everything is OK now.

Regards, Ton Hermes

---

Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com