log shipping - recovery, what to do...

randyv

Hello -

I'm the primary DBA (amongst other things) here. I've been asked by my management to document emergency procedures in case I'm away when something 'bad' happens.

I've been referring them to the SQL Backup documentation for recovery since it is so clear and the product is so good.

Soon now, we're going to start using the Log Shipping abilities in Production. However, I cannot find anything in the online help file that provides the steps to bringing a database on standby into recovery and the steps to applying the final tail end log, etc. Do you plan on updating on line help? If not, do you have something documented that I can 'steal' instead of trying to write the procedure from scratch myself?

Thanks in advance.

petey

We presently don't have anything documented, as the steps are almost similar to what you would do when using native SQL Server backups and restores.

E.g. to bring a standby database online:

RESTORE DATABASE [prod_mirror] WITH RECOVERY

If you need to backup upthe log from a damaged database:

EXEC master..sqlbackup '-sql "BACKUP LOG [prod] ... WITH NO_TRUNCATE" '