Log Shipping Details
New Information - SQL Server 2000 SP3.
Use this dialog box to view or specify the following options. This dialog box is only available when one secondary database is in standby mode.
View the monitor server name.
Use Windows authentication
Use Windows Authentication when connecting to an instance of Microsoft® SQL Server™. It is recommended that you use this option for security because users who connect through a Microsoft Windows NT® 4.0 or Windows® 2000 user account can make use of trusted connections. Trusted connections are those validated by Windows NT 4.0 or Windows 2000.
Security Note When possible, use Windows Authentication.
Use SQL Server authentication
Use SQL Server Authentication to connect the monitor server. When a user connects with a specified login name and password from a nontrusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails and the user receives an error. For more information about SQL Server Authentication, see Authentication Modes.
View the login name for the monitor server, if the server is connecting using SQL Server Authentication.
View or specify the password for the monitor server, if the server is connecting using SQL Server Authentication.
Log Shipping Role
View information about the role of the monitor server.