Manuscript stores all the data it needs to run in the database. The most important databases containing your Manuscript data are the “trialN” database(s) and we recommend backing them up regularly. Microsoft has a knowledge base article on how to back up your SQL Server database. Make sure that every time you do a backup you are shrinking the transaction logs to keep them small.
If you are not sure where your databases are hosted, you can find the physical server(s) hosting them by using the fbhosted database, the location of which is stored as sFBHostedConnectionString in the registry at
HKEY_LOCAL_MACHINE\SOFTWARE\Fog Creek Software\FogBugz\<your manuscript install directory>/Website. Run the following query on the fbhosted database:
SELECT t.ixFogBugzTrial, t.sUniqueSiteName, s.sSQLServerInstance, CONCAT('trial', t.ixFogBugzTrial) AS sDatabase FROM tblFogBugzTrial t JOIN tblFogBugzTrialDBServerMap m ON t.ixFogBugzTrial = m.ixFogBugzTrial JOIN tblFogBugzTrialDBServer s ON m.ixFogBugzTrialDBServer = s.ixFogBugzTrialDBServer