After a database is restored, users should clear their caches prior to opening their clients. See this KB article for additional information: viewtopic.php?t=217.
There are a few methods for restoring I will list here:
1) Restoring using the Vault admin backup/restore web page.
- The Backup/Restore page allows the user to backup and restore all Vault databases, which include sgvault, sgmaster, and sgdragnet if you are using Vault Professional. This page uses the SQL Server basic backup and restore functions. This page can only be used to restore databases on the server on which Vault already resides.
- SSMS has a restore function. Details on how to use it can be found in Microsoft's documentation: https://msdn.microsoft.com/en-us/librar ... l.90).aspx. If you are restoring a backup that was created using Vault's admin web page, you will need to rename the file extension of each back up file from .sgvbak to .bak. This method can be used in any case where you may need to restore the Vault databases.
- In SSMS you can click New Query and paste in the example code provided below to restore a database and decide it's restore location at the same time. Replace the sections "xxx_some path_xxxx " with the appropriate locations. In addition replace the backup names with the correct backup name.
Code: Select all
--SGVAULT RESTORE DATABASE sgvault FROM DISK = 'x:\ xxx_some path_xxxx \vault backup name.bak' WITH MOVE 'sgvault' to 'x:\ xxx_some path_xxxx \sgvault.mdf', MOVE 'sgvault_log' to 'x:\xxx_some path_xxxx\sgvault_log.ldf' --SGMASTER RESTORE DATABASE sgmaster FROM DISK = 'x:\ xxx_some path_xxxx \sgmaster backup name.bak' WITH MOVE 'sgmaster' to 'x:\ xxx_some path_xxxx \sgmaster.mdf', MOVE 'sgmaster_log' to 'x:\xxx_some path_xxxx\sgmaster_log.ldf' --SGDRAGNET RESTORE DATABASE sgdragnet FROM DISK = 'x:\ xxx_some path_xxxx \dragnet backup name.bak' WITH MOVE 'sgdragnet' to 'x:\ xxx_some path_xxxx \sgdragnet.mdf', MOVE 'sgdragnet_log' to 'x:\xxx_some path_xxxx\sgdragnet_log.ldf' --SGNOTIFY RESTORE DATABASE sgnotify FROM DISK = 'x:\ xxx_some path_xxxx \sgnotify backup name.bak' WITH MOVE 'sgnotify' to 'x:\ xxx_some path_xxxx \sgnotify.mdf', MOVE 'sgnotify_log' to 'x:\xxx_some path_xxxx\sgnotify_log.ldf' --SGVAULTINDEX RESTORE DATABASE sgvaultindex FROM DISK = 'x:\ xxx_some path_xxxx \vaultindex backup name.bak' WITH MOVE 'sgvaultindex' to 'x:\ xxx_some path_xxxx \sgvaultindex.mdf', MOVE 'sgvaultindex_log' to 'x:\xxx_some path_xxxx\sgvaultindex_log.ldf'