3

Rather than the detach/attach, take the database offline, change the location, move the file, and set back online. Example DDL: --take database offline ALTER DATABASE test SET OFFLINE; --modify the file location ALTER DATABASE test MODIFY FILE ( NAME = 'log', FILENAME = 'd:\test2.ldf' ); --manually move the file to the new location --finally, set database ...


1

Reference: log_shipping_monitor_secondary (Transact-SQL) sp_help_log_shipping_monitor (Transact-SQL) Monitor Transaction Log shipping using T-SQL and SSMS by Jignesh Raiyani View the Log Shipping Report (SQL Server Management Studio) Using TSQL get details of last restored transaction log Backup (Subscriber Side): SELECT b.type, b.first_lsn, b.last_lsn, b....


Only top voted, non community-wiki answers of a minimum length are eligible