none
SQL Server 2005 Publications Disappear

    Question

  • Hi Folks,

    Thanks for taking the time to look at my question. 

    I have a client who's publications have now dropped or disappeared twice in the span of one month.  He has a backup of the publications that he can restore but then he has to synch approximately 280 laptops.  Obviously this is time consuming.  I was wondering if there are any suggestions or reasons as to why these pubs have disappeared.  Any help in the matter would be greatly appreciated!

    In the SQL log, the only messages for the day in question are:

    03/09/2012 14:56:06,spid54,Unknown,Setting database option MULTI_USER to ON for database xxx.
    03/09/2012 14:56:01,spid54,Unknown,Setting database option RESTRICTED_USER to ON for database xxx.
    03/09/2012 14:56:00,spid54,Unknown,Setting database option MULTI_USER to ON for database yyy.
    03/09/2012 14:55:53,spid54,Unknown,Setting database option RESTRICTED_USER to ON for database yyy.
    03/09/2012 14:55:53,spid56,Unknown,Setting database option MULTI_USER to ON for database zzz.
    03/09/2012 14:55:46,spid56,Unknown,Setting database option RESTRICTED_USER to ON for database zzz. 

    Monday, March 12, 2012 5:57 PM

Answers