In response to my earlier post, we need to have the ability for two things:
- Be able to load a database from backup if the database.status column is 320 (offline and suspect) – this will allow us to avoid dropping the database with “dbcc dbrepair(<dbname>, dropdb)” and recreate the databases for load. Perhaps a “load database <dbname> from …. with override”?
- “create database …. for load” can take hours or days depending on the size and speed of the devices. In certain DR situations, we don’t have the time for the load database for load to be performed. We need a “create database …. for load with DDL only” which will populate the system tables and verifies that the specified databases are available. This should be a sub-second operation. By providing this method, Sybase can provide DR hosting sites a fully supported method to rebuild a database in a reasonable timeframe.
I’m waiting on the feature request numbers from Sybase. As soon as I receive them, I’ll update this post.