Rebooting SQL server

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.

Real time access to iSeries

I have a database maintained on an iSeries. I have an application that uses
MS SQL. I need to pull data down from the iSeries to my MS SQL server in real
time or just once a week, doesn't matter. Is this easily doable and are there
any "gotcha's" to be aware of?
Thanks!
Mbrewer.
You should be able to create a linked server to an iSeries. In fact, the
Books Online has an example of defining the link in the sp_addlinkedserver
topic.
http://technet.microsoft.com/en-us/library/ms190479.aspx
Once you have a linked server, then you can create a schedule job to do the
updates from the iSeries database into SQL Server.
For more hits, do a Technet search: "sql server" DB2 "linked server"
Also, on Technet I searched: "sql server" iseries "linked server"
http://www.experts-exchange.com/Database/DB2/Q_22592124.html
There is also a BizTalk connector, but you probably are not using that
solution: http://technet.microsoft.com/en-us/library/aa770734.aspx
RLF
"Mbrewer22" <Mbrewer22@.discussions.microsoft.com> wrote in message
news:D26B76E1-A79C-4AE4-A4C9-F123C8B683F3@.microsoft.com...
>I have a database maintained on an iSeries. I have an application that uses
> MS SQL. I need to pull data down from the iSeries to my MS SQL server in
> real
> time or just once a week, doesn't matter. Is this easily doable and are
> there
> any "gotcha's" to be aware of?
> Thanks!