Check configuration and compatibility of:
Mode | Automatic Failover | Full Protection from Data Loss |
---|---|---|
High Availability | O | O |
High Protection | X | O |
High Performance | X | X |
CREATE ENDPOINT endpointName STATE=STARTED AS TCP ( LISTENER_PORT = listenerPortList ) FOR DATABASE_MIRRORING ( [ AUTHENTICATION = WINDOWS [ authorizationMethod ] ] [ [,] ENCRYPTION = REQUIRED [ ALGORITHM { algorithm } ] ] [,] ROLE = ROLE )
ALTER DATABASE AWData SET PARTNER FAILOVER
ALTER DATABASE AWData SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
sp_add_log_shipping_primary_database @DATABASE = N'AdventureWorks' ,@backup_directory = N'c:\lsbackup' ,@backup_share = N'\\tribeca\lsbackup' ,@backup_job_name = N'LSBackup_AdventureWorks'
BACKUP LOG AdventureWorks TO AWLogBackup WITH NORECOVERY
RESTORE LOG AdventureWorks FROM AWLogBackup WITH RECOVERY