How To Move And Copy A Resource 32000 Database

Moving / Copying a Resource 32000 Database (SQL Server)

These instructions are intended to allow a systems administrator to move or copy a Resource 32000 database on SQL Server 6.5. Basic knowledge of SQL Server administration procedures is assumed.

  • Go into SQL Server Enterprise Manager with system administrator privileges.
  • If necessary create a new database. This database can have any name you like for the moment (it can be renamed later if you want). We recommend a data area and separate transaction logs of at least several-hundred megabytes each. Preferably the data and transaction logs should on separate database devices, which should preferably themselves be on separate physical hard-drives. You may want to use the database options tab to set the transaction log for automatic truncation at every checkpoint, since this prevents it from filling up.
  • Now you can copy your existing Resource 32000 Database. Use the database transfer dialog that is available by right-clicking on the database name. Select the Destination database that you want to transfer to (possibly the one you just created in step 2), and then accept defaults for all the other options except “Quoted Identifiers? which you can alter by unsetting the “Use Default Scripting Options? button, then click on “Scripting Options….?, then click on “Use Quoted Identifiers? on the dialog that appears, and finally select “OK?. You can then start the transfer, which may take some time for a large database.
  • You may want to rename the database that you have just transferred into (and indeed the one you have transferred from). Typically you might do this when the object of the whole exercise is to move a database to a different device, or change its configuration. This can be done in the SQL Query Tool in the Tools menu of Enterprise Manager.
  • Launch the SQL Query Tool.
  • Change its database to master(this may already be the case).
  • Run the sp_renamedb (olddatabase, newdatabase) stored procedure. First do this to get the original database “out of the way?; then rename the new database to the original database name. After doing this you may need to reset single-user mode for both databases.