sgmaster starting all the time

If you are having a problem using Fortress, post a message here.

Moderator: SourceGear

Post Reply
Posts: 230
Joined: Tue Mar 01, 2005 5:06 am

sgmaster starting all the time

Post by Xavier » Fri Aug 29, 2008 8:11 am


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 ?


Best regards


Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear

Re: sgmaster starting all the time

Post by Beth » Fri Aug 29, 2008 2:58 pm

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?
Beth Kieler
SourceGear Technical Support

Posts: 24
Joined: Thu Jun 21, 2007 3:21 pm

Re: sgmaster starting all the time

Post by drmccue » Tue Sep 02, 2008 7:53 am


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

Post Reply