1.logshipping-> db level->sql 2000->full/bulklog
2.db mirroring->db level->sql 2005->full
3.replication->table level->sql 7.0->full/bulk log/simple
4.clustering->instaance level->sql 2000
5.always on->group db level->sql 2012->full
automatically send transaction log backups from a primary database on a
primary server instance to one or more secondary databases on separate secondary
edition should be same,minimum 2 sql ,monitor 1 as well.
create backup folder in primary and provide read/write permission on service
create copy folder in secondary and provide minimum read permission
express edition not supported agent not avalible.
collasion setting also same
maxminum we can 25 secondary servers.
log shipping issues:
jobs disable,backup folder share permission issues
space issue backup folder copy folder
recovery model change full to simple
manuval log backup LS break
backup job fails: disk full,permission,invalid path,agent down,sql down db
down,recovery model change to simple.
restore job fails:sqldown,server down,disk down,agent down,backup file currepted
how will change database stand by mode:
manuvally restore log backup option stand by mode
There are two options to make such changes for log shipping configurations:
1) by running the log shipping system stored procedure
===EXEC sp_change_log_shipping_secondary_database / @secondary_database =
'Collection',/@restore_mode = 1,/@disconnect_users = 1
2) by making changes to log shipping using SSMS. manuvally restore log backup
restore stand by mode.
RESTORE LOG [test] FROM
DISK = N'I:\backup\test_fullbackup_3.42.pm.trn'
FILE = 1,
STANDBY = N'I:\backup\ROLLBACK_UNDO_test.BAK',
STATS = 10
log file full
1) Open transactions