standby server 3 mode:

1> backup and restore

2> replication

3> log shipping

Check the DB recovery mode.

It is SQL Server Agent Error Log.

My suggestion:

1> Make a dump of ur DB system

2> Run DBCC checkdb, ...

3> Make a dump again

4> Scan ur HD. Or change a HD.

5> Check HD Space

6> Reindex

7> Microsoft or...

create and schedule a task

You can change the error log location on "startup parameters" of "SQL Server Properties".

It will be active after restart SQL Server.

Hi,

SQL server cannot record the connection IP address, you can try the ways which Bkelley and Stubob said. And you also can audit the login, maybe it will help u.

Good...