Re: shutdown for backup : pro's and con's

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 8 Dec 2000 11:48:56 -0500
Message-Id: <10704.124063@fatcity.com>

SHUTDOWN IMMEDIATE should work, but I've always used a method similar to what you describe below just for the extra piece of mind that it gives me. NEVER do a backup immediately after a SHUTDOWN ABORT. Best regards,

Jonathan
mailto:jonathan_at_gennick.com
http://gennick.com

Thursday, December 07, 2000, 10:33:55 PM, you wrote:

PHC> I would like to be convinced one way or the other on the following issue : PHC> What is the best way to take a database down for a cold backup ?

PHC> SHUTDOWN ABORT
PHC> STARTUP RESTRICT
PHC> SHUTDOWN NORMAL
PHC> <BACKUP>

PHC> or

PHC> SHUTDOWN IMMEDIATE
PHC> <BACKUP>

PHC> I have seen both widely used.
PHC> I have always stayed away from the ABORT option because I am uneasy about
PHC> taking any database down this way (hard).
PHC> I am looking for a dialog on the pro's and con's of each approach.
PHC> ie: Any horror stories about taking down with the ABORT option ?

Received on Fri Dec 08 2000 - 10:48:56 CST