|
This may occasionally happen due to a
database corruption or because the database reached the 2GB size limit imposed by older MSDE.
The current free
Microsoft SQL Server Express replaced MSDE and no longer imposes a 2GB limit.
In older versions, once
the limit is reached, it becomes inaccessible by Praetor. (FYI: Check to see if the Praetor
nightly cleanup scheduled task is enabled. This prevents reaching the
limit.)
To receive a new, blank Praetor log database,
download the
"DefLog.Zip" file from the CMS website. This Praetor zip file
contains...
|
 |
LogAttach.sql |
|
LogDetach.sql |
|
Logins.sql |
|
|
PraetorLog_Data.mdf |
|
PraetorLog_Log.ldf |
|
|
Make sure G2-Daily.bat is not running before following these steps...
|
1) |
Under "ControlPanel\Administrative
Tools\Services", disable "IIS Admin Recovery"
options by setting all to "Take No Action" |
|
2) |
Run "iisreset/stop" |
|
3) |
Then "Net
Stop Prlog" |
|
4) |
Extract the
files held in "DefLog.Zip" into a temporary folder on
the Praetor machine. |
|
5) |
Run "SQL
Studio Express" |
|
6) |
Detach the
Praetor Log Database |
|
7) |
Move the
current "PraetorLog_Data.MDF" and "PraetorLog_Log.ldf"
out of the CMS Praetor G2 directory |
|
8) |
Copy the new
"PraetorLog_Data.MDF" and "PraetorLog_Log.ldf"
out of the CMS Praetor G2 directory |
|
9) |
Attach the
PraetorLog database using SQL Studio Express |
|
10) |
Open the
Security for the database to add the following identities...
|
|
NTAuthority\NetworkService |
|
|
MachineName\PG2_MachineName |
|
|
IWAM\MachineName |
|
|
11 |
Type "IISRESET"
at a command prompt |
|
BL-Monitor
