Have SQL Server Management Studio configure your secondary database by backing up the primary database and restoring it on the secondary server. Yes, generate a full backup of the primary database and restore it to the secondary database The account used to connect must be a member of the sysadmin fixed server role on the secondary server instance. The new database is created as part of the restore operation.Ĭonnect to an instance of SQL Server for use as a secondary server in the log shipping configuration. If you enter the name of a new database, you must select an option on the Initialization tab that restores a full database backup of the primary database into the secondary database. When adding a new secondary database to a log shipping configuration, you can choose a database from the list or type the name of a new of the database into the box.
Optionsĭisplays the name of the instance of SQL Server currently configured to be a secondary server in the log shipping configuration.ĭisplays the name of the secondary database for the log shipping configuration. Use this dialog box to configure and to modify the properties of a secondary database in the log shipping configuration.įor an explanation of log shipping concepts, see About Log Shipping (SQL Server).
0 kommentar(er)
