Showing posts with label Logshipping. Show all posts
Showing posts with label Logshipping. Show all posts

Monday, 30 May 2011

logshipping reconfigure

Restore database [abc] from disk='\\klkoiu02b\backup_02b\abc\abcfull.bak' with
move'abc_Data' to 'G:\MSSQL$INST02\Data\abc_data.mdf',
move'abc_Log ' to 'H:\MSSQL$INST02\LOG\abc_log.ldf',
replace,stats=5,standby='\\jumpv02\g$\MSSQL$INST02\BACKUP\Logshipping_in\abc\abc_undo.dat'

Log shipping imp tables

select * from log_shipping_secondaries

select * from log_shipping_monitor
select * from msdb..log_shipping_monitor_secondary

select * from sysobjects where name like '%log_shipping%'

select * from log_shipping_databases

select * from log_shipping_plans