Some concern has arisen to the completeness of the backups of the MS SQL backups of the MBARI Samples Database. Until it can be verified that the system nightly backups performed from within the MSQ SQL backup are sufficient to restore the database, some alternative steps need to be performed to ensure that the database is fully backed up.

Any time changes are made to the schema of the samples database, backup the Schema

1. From inside the enterprise manager program, click on the [+] by Cyclone, the [+] by Databases and highlight the MBARI_Samples database. Then select [Object] [Generate SQL Script].



2. Check all objects (except "Use Quoted Identifiers") and press [Script]



3. Select a location that gets backed up nightly and a name that makes sense and press [Save]

In approximately 30 seconds the script file should be created.

Any time large amounts of data change, backup the data in MS Access

1. Open a new database in Access by selecting [File] [New Database]



2. Pick a blank database and press [OK]



3. Select a location that gets backed up nightly and a name that makes sense and press [Create]



 

4. Select [File] [Get External Data]



5. Select [ODBC Database] from the "Files of type:" pull down list



6. Select the "sample1" Data Source Name on the Machine Data Source tab and press [OK]



7. Select all the tables except the views (those which start with vw) and press [OK]



8. After 15-30 seconds all the tables should appear in your new database. Spot check the data to verify correct and complete.

These two files are all you need to completely restore your database.

»Next: Web interfaces

Last updated: 07 December 2004 by Jennifer Paduan
Copyright © 1998 MBARI