Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Move Database to New Computer Via Restore? |
Tue, Nov 1 2011 1:20 PM | Permanent Link |
jframe | Can you create a backup, move it, and restore a database on a separate computer if the server doesn't currently have a reference to said database?
|
Tue, Nov 1 2011 1:41 PM | Permanent Link |
Adam Brett Orixa Systems | >>Can you create a backup, move it, and restore
>> a database on a separate computer if the server >> doesn't currently have a reference to said database? Once you have a Backup file _if_ you have the CATALOG you can restore it anywhere. i.e. BACKUP DATABASE MyDatabase AS "MyDatabaseBackup" TO STORE "Backup" Creates a backup file, but no catalog, so it can only be restored into a session which already contains a definition (catalog file) for that database. BACKUP DATABASE MyDatabase AS "MyDatabaseBackup" TO STORE "Backup" INCLUDE CATALOG ... includes the catalog ... so now you can restore it wherever you like. -- Your users will only access a restored database if you Server Session points to it (i.e. your server session includes a database definition which points to the restored database). |
Fri, Nov 4 2011 6:06 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << Can you create a backup, move it, and restore a database on a separate computer if the server doesn't currently have a reference to said database? >> The only requirement is that you restore the database into an existing database that has been created using CREATE DATABASE. It doesn't have to be the same database name, nor does it even have to have the same metadata if you have chosen to restore the database catalog also. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |