Administration > SQL Server Administration > Administration Tasks > Database Administration > Creating and Viewing the Log File for a Database
  
Creating and Viewing the Log File for a Database
When you perform any of the following administrative functions on an SQL database, a log file with the name SQLAdmin_<timestamp>.log is created in the Windows temporary folder:
Create Database
Delete Database
Backup Database
Restore Database
To view the SQL Administration logs, open the Windows Run command dialog box, type %temp%, and click OK. The Windows temporary folder opens. In this folder, locate and open the file SQLAdmin_<timestamp>.log that contains the logs of administrative functions performed on the databases.