Cannot restore

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
asimo4262

Cannot restore

Post by asimo4262 » Mon Nov 15, 2004 4:37 pm

Using Vault 2.0.6
Windows 2000 server - domain controller

Can Create a backup file, but when I try to restore from a file, it asks me for the sa password which I provide (even though I set it up for Windows Authentication).

This is the application error message:
Database Restore Failed - See server log file for details.

This is from the log file ....
Restore returned:Restore can not be completed while the VaultServer
is in Integrated Authority Mode. Restore can be completed using SQL
Server's Enterprise Manager

Anyone had the same problem??

gmagana
Posts: 145
Joined: Wed Feb 18, 2004 10:51 am
Location: Santa Ana, CA, USA

Post by gmagana » Mon Nov 15, 2004 4:53 pm

I can't restore either (in mixed mode, though), except when I uninstall Vault, restore the database, then re-install Vault server (choose to keep existing database).

Does this work for you?
gabriel magana-gonzalez

jclausius
Posts: 3706
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Re: Cannot restore

Post by jclausius » Mon Nov 15, 2004 9:28 pm

asimo4262 wrote:Using Vault 2.0.6
Windows 2000 server - domain controller

Can Create a backup file, but when I try to restore from a file, it asks me for the sa password which I provide (even though I set it up for Windows Authentication).
The Vault Admin Tool's restore capability is very limited. The Admin Tool expects SQL Server to be running in mixed auth mode, and you must use the 'sa' account to restore the database.

From the log message, it appears your SQL Server is running in Windows Auth Mode only. For these purposes, using a RESTORE DATABASE query or Enterprise manager to restore the backup will be the best way to restore the database.

Post back if you need more assistance restoring the backup through normal SQL Server means.
Jeff Clausius
SourceGear

Post Reply