|Logging
SSMA can generate logging messages to log files for further troubleshooting if necessary. The following parameters are available:If the logging mechanism is turned on, the following parameters are available:
- Output directory - The directory where log files will be created (by default, it is C:\\Documents and Settings\\[Current User]\\Application Data\\Microsoft\\SQL Server Migration Assistant\\logs\\). To change it to your home folder, click the Browse and insert alias "<
>". This will point to the C:\\Documents and Settings\\[Current User] directory. It is also possible to set any other directory for log files. - Parameters schema - For changing between:
- Logging parameters - Shows options available for logging subsystem.
- Output redirection parameters - Shows options that can enable or disable output stream redirection to a file.
- Error redirection parameters - Shows options that can enable or disable error stream redirection to a file.
|
- Enable logging - Enable or disable logging subsystem.
- File output - File name.
- Maximum log file size - If the log file reaches its maximum size, it begin working like a queue: it will add new message to the beginning and remove last message at the end.
- Backup index size - The number of backup copies of log files to keep.
- Categories - There are different subsystems in SSMA, and logging can be enabled or disabled for each subsystem separately, as well as logging level. We recommend to use the option "WARN" for all subsystems.
Log shipping is supported on Enterprise, Developer, Standard and Workgroup editions of SQL Server. This instance has %1!s! ...
Log was backed up. Database: %1!s!, creation date(time): %2!s!(%3!s!), first LSN: %4!s!, last LSN: %5!s!, number of dump ...
Log was restored. Database: %1!s!, creation date(time): %2!s!(%3!s!), first LSN: %4!s!, last LSN: %5!s!, number of dump devices: ...
Logarithmic scale recalculate the values shown in the Minimum, Maximum, boxes as powers of LogarithmBase for the value axis, ...
Logging SSMA can generate logging messages to log files for further troubleshooting if necessary. The following parameters ...
Login '%1!s!' is aliased or mapped to a user in one or more database(s). Drop the user or alias before dropping the login. ...
Login '%1!s!' owns one or more multiserver jobs. Ownership of these jobs can only be assigned to members of the %2!s! role. ...
Login '{0}' has no access to the selected default database. Click OK to continue without permitting access to the the default ...
Login failed due to timeout; the connection has been closed. This error may indicate heavy server load. Reduce the load on ...