If you perform a level-0 archive using ON-Bar and a storage manager, then drop a database, and then perform a restore with the onbar -r command, the database remains dropped. The restore salvages the logs and the logs contains the DROP DATABASE statement. When the logs are salvaged, or replayed, the database is dropped.
To prevent this situation, perform a physical restore using the onbar -r -p command, and then a logical restore using the onbar -r -l command. This sequence does not salvage the logs and does restore the database.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]