problems after catastrophic failure

[kmh72756]

HI,

I have two problems after losing our server and tring to recreate everything.
I have windows server 2003 installed from scratch.
Then I got Sql Server Express installed and running.
Then I found the original Vault 3.5.1 install files and got Vault up and running fine.

The first problem is that I inherited this problem and I don't know where to refind our license information.
So at this point I am stuck with just the admin user.

The other problem is that we use a program to produce our backup files via Microsoft.SqlServer.Management.Smo.Backup
I don't know how to go about restoring one of those backups.
After several years this is the first time we have ever needed to restore Vault.
Do I need to use some kind of command line program built into SQL Server or do I need to write a program like our backup?

Thank you,
Ken Handzik
kmh@excaliburinc.com

[Beth]

With the program that makes the backup, does it make a regular SQL backup that ends in .bak or is it some other format? If it's a SQL backup, then it can be restored with SQL Server Management Studio Express.

Also, the backup should be restored before you install Vault. If Vault is installed prior to the backup being restored, it won't read the users from the database.

If you can open a Query Analyzer Window, you can use something like the following to restore:

RESTORE DATABASE sgvault
FROM DISK = 'X:\xxxsome pathxxx\backupname.bak'
WITH MOVE 'sgvault' to 'X:\xxxsome pathxxx\sgvault.mdf',
MOVE 'sgvault_log' to 'X:\xxxsome pathxxx\sgvault_log.ldf'

Just replace the 'x' areas.

[kmh72756]

I think the file produced by the back is a 'regular' SqlServer backup even though it doesn't end with .bak

At least I hope that is so because the program is talking to the Microsoft SqlServer object.

I guess I will have to uninstall Vault first, then do the restore once I figure out Management Studio Express, and finally reinstall Vault.
Does that sound right?

Where would I find Query Analyzer if I want to do the restore the other way?
And what are those MOVE clauses for?
What is an mdf or ldf file for?

Also, does anyone have any idea what to do about my licensing problem, or will the reinstall work differently because I will be restoring the sgvault first?

[Beth]

I think the file produced by the back is a 'regular' SqlServer backup even though it doesn't end with .bak

That's fine. I'm not sure what your tool does, but I know when a backup is run with the Vault admin tool, it creates a SQL backup with the extension .sgvbak. I can use those in a regular restore.

I guess I will have to uninstall Vault first, then do the restore once I figure out Management Studio Express, and finally reinstall Vault.
Does that sound right?

That should work for getting running again.

When you first open SQL Server Management Studio, there is a button in the upper left area for New Query. That brings up Query Analyzer. Then enter the information and click Execute. See attached screenshots for help.

The move clauses aren't required, but I find them useful for placing the database where one wants them to be, such as where there is enough extra space.

An mdf file is the main database file and the ldf is the log. Most databases have both. When working with Vault, it's important you have both.

Your licenses are stored in the Vault database, so you will not need to enter it again.