Database restore problem

[jgrenadier]

I am having trouble restoring a vault backup to a new machine.

I tried the following steps.

1. Install Vault 5.0.3 on the new PC.
2. Use SQL Server Management Studio to do a Restore on the Databases from the saved files.

If I do not use the overwrite switch, I get the following error:
"System.Data.SqlClient.SqlError: The backup set holds a backup of the database other
than the existing "sgmaster" database. (Microsoft.SqlServer.Smo)."

If I use the overwrite switch, I can get the master database installed.

However, even with the overwrite switch, my sgvault database cannot be installed.
I get the error...
"System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "sqvault" as
read from the backup set. (Microsoft.SqlServer.Smo)"

Ive tried backing up use the Vault Admin tool and the SQL Server Management Studio.
The files are the same size and the errors are the same.

Any ideas?

Jim

[Beth]

When moving Vault you should restore the database first before installing Vault. Uninstall your current version of Vault and drop the empty databases. Then try a restore again.

If the restore still fails, what happens when you run the following against your backup, replacing the x's with the path and name of your backup file:
RESTORE FILELISTONLY FROM DISK='x:\xxxx\xxxxxxxxxxxl.bak'

[jgrenadier]

I'm all set. You may close this issue.

I thought I had performed the steps in the same order that you described.
However, as the saying goes, "It's always the last thing you try.".

This time, to be sure that I understood the exact switches used in the RESTORE transact sql,
I performed the restore in a Transact SQL query window rather than use the SQL Server Management
Studio GUI.

So either my following the steps correctly in the right order this time worked or the original statements generated
automatically for my from the Management Studio was a problem.

In any case, thanks.

Jim

[Beth]

Thanks for the update. I'm happy to hear you're working.