log shipping - recovery, what to do...
randyv
Posts: 166
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.
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.
What we do in life echoes in eternity <><
Randy Volters
Randy Volters
Comments
E.g. to bring a standby database online:
If you need to backup upthe log from a damaged database:
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8