We have a SQL server 2000 server residing on an iSeries intel card which is being rebooted once per week. The server log has the following two entries:
When shutting down:
1. SQL Server terminating because of system shutdown.
During startup:
1. Recovery of database "ERPDB" is complete
2. Two transactions rolled back in "ERPDB".
3. Recovery is checkpointing "ERPDB"
4. Recovery complete.
The database is 70GB and is a copy of an iSeries database. The recovery model is set to 'Simple' but I am still concerned if the above messages indicate that the server is shut down without properly waiting for replication tasks to complete?
Rgds
Bertrand
Is there any reason for the reboot every week?
The message on error log is by default as the services for SQL Server has been stopped when there are connections on SQL Server are idle or performing any activity.
The messages during the startup are also by default as it need to bring up the database and those rolledback transactions are due to when the SQL was stopping these were initiated. It is better to stop the SQL Server services when there is no such activity on server.
No comments:
Post a Comment