Viewing the Log File for a Database
To view SQL Server Administration logs, open the SQLAdmin_<timestamp>.log 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