SQL Server Agent Stopped 1

[alan12345]

Our SQL Server agent stopped last Tuesday 11/01. Our system backups are done by SQL Server agent jobs that I created.

Yet the SQL Server logs show that Database backups were performed early this morning anyway. Where would I find those backups? In the directory where the .mdf and .ldf are stored?

Thanks,
Alan

 

[mrdenny]

Backups are normally placed in the BACKUP folder which would be located in the parent folder of the DATA folder.

However they can be placed anywhere depending on where the backup command told them to be placed.

Check the SQLSERVERAGENT service in the services icon in the Administrator Tools Control Pannel. If it is running then the SQL Agent is running.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com