Administration > SQL Server Administration > Administration Tasks > SQL Server Administration > Viewing SQL Server Logs
  
Viewing SQL Server Logs
To view SQL Server Administration logs, open the SQLAdmin_<timestamp>.txt file, which is stored in the default Windows temporary folder.
To open the Windows temporary folder:
Start the Windows Run command dialog box, type %temp%, then click OK.
The following Model Explorer functions are logged:
Create Database
Delete Database
Backup Database
Restore Database