sgmaster starting all the time

[Xavier]

Hello,

I have a lot of 'starting sgmaster' database in the event viewer. All the time

Do you think it's corrupted ? Can I make a check of it ?

Thanks

Xavier

[Beth]

I haven't heard of this. Could you look in your Fortress server log to see if there are corresponding errors? If there's nothing, can you post all the details from one of the errors that you are seeing in the Event Viewer?

[drmccue]

Xavier,

Please check your 'sgmaster' database properties to see if "Auto Close" is checked. It is my understanding that if Auto Close is turned on, the database has to be started when it is queried, and then Auto Close "stops" it, so it needs to be restarted at the next query.

I do not suspect that the database is corrupted. However, if you want to run a diagnostic check on your database, the following command will do the job:

DBCC CHECKDB (sgmaster)

Best regards,
Dan McCue
SourceGear