Restore vault error

westar · Post by **westar** » Tue Oct 24, 2006 12:57 pm

I am running Vault 3.0.7 and I did a backup. It created a .sgvback file.
I wanted to test the vault restore. and I get this error message.

" Database restore failed. Please see the server log for specific
details"

Here is what is loacted in the SQL 2000 log files. There was more
than one so I listed the newest log file. The Log file shows the
backup but lists no info on the restore.

2006-10-24 13:37:06.40 spid9 Starting up database 'sgdragnet'.
2006-10-24 13:37:07.68 spid5 Starting up database 'tempdb'.
2006-10-24 13:37:07.93 spid3 Recovery complete.
2006-10-24 13:52:34.27 backup Database backed up: Database: sgvault, creation date(time): 2006/10/12(14:55:24), pages dumped: 563, first LSN: 21:384:1, last LSN: 21:386:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\test2.sgvbak'}).

Thanks

Post by **jclausius** » Tue Oct 24, 2006 3:29 pm

How did you execute the database restore?

Is it possible there are open connections to the database causing the restore to fail? If you use Enterprise Manager, try killing all connections to the database and then the restore.

In the database properties what is the recovery mode? Simple?

westar · Post by **westar** » Wed Oct 25, 2006 12:41 pm

I executed the database restore thru the Vault Admin tool.
I did the backup there to create the backup.sgvbak file that
I am using to restore back into the Vault.

There are no connections to the database when I am trying to
restore.

I changed the recovery mode from full to simple. I still
see the same error message.

Thanks

Post by **jclausius** » Wed Oct 25, 2006 1:13 pm

The admin tool is supposed to remove user's connection. Is it possible the stored procedure to remove connections in the master database did not fire?

Another option you may want to explore is to try the database restoration through the SQL Server Management tool.

westar · Post by **westar** » Wed Oct 25, 2006 2:05 pm

Good news and bad news...

I went thru the SQL 2000 Enterprise Manager and did the database
restore and it worked. That is the good news.

The bad news is that when I try to login into either Vault Client
or Admin I get a FailDBConn (could not establish a connection
to the database) error message.

I have stopped and re-started the datbase I even re-booted the
system with no luck.

Any ideas? Thanks

Post by **jclausius** » Wed Oct 25, 2006 2:13 pm

Take a look at the
Vault Server Log. It should give you a better indication of the problem.

westar · Post by **westar** » Wed Oct 25, 2006 3:11 pm

Here is what is in the Vault Log

System Started
Version 3.0.7.2863
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain =
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://Vinstall_cbm.enterprise.westar.corp/VaultService
Identity = NT AUTHORITY\NETWORK SERVICE
----10/25/2006 4:03:19 PM --()-- Vault Failed to establish a connection to the database.
----10/25/2006 4:03:19 PM --()-- Cannot open database requested in login 'sgvault'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----10/25/2006 4:03:19 PM --()-- Vault Failed to establish a connection to the database.
----10/25/2006 4:03:19 PM --()-- Cannot open database requested in login 'sgvault'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----10/25/2006 4:03:19 PM --()-- The session information was not removed from the database. Please check sgvault.dbo.tblsessions within SQL Server. There may be orphaned sessions stored within the database. Error: FailDBConn
----10/25/2006 4:03:20 PM --Vinstall_cbm.enterprise.westar.corp(127.0.0.1)--SSL Disabled Vault Failed to establish a connection to the database.
----10/25/2006 4:03:20 PM --Vinstall_cbm.enterprise.westar.corp(127.0.0.1)--SSL Disabled Cannot open database requested in login 'sgvault'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----10/25/2006 4:03:21 PM admin--Vinstall_cbm.enterprise.westar.corp(127.0.0.1)--SSL Disabled Vault Failed to establish a connection to the database.
----10/25/2006 4:03:21 PM admin--Vinstall_cbm.enterprise.westar.corp(127.0.0.1)--SSL Disabled Cannot open database requested in login 'sgvault'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Thanks

Post by **jclausius** » Wed Oct 25, 2006 3:29 pm

From this file, it appears Vault is configured to connect through Windows Authentication, but the Windows account NT AUTHORITY\NETWORK SERVICE does not exist as a security user within the database.

Can you check the sgvault database to verify NT AUTHORITY\NETWORK SERVICE is in the security roles to the database.

westar · Post by **westar** » Thu Oct 26, 2006 2:56 pm

The NT AUTHORITY\NETWORK SERVICE is located in the security logins
folder. I changed all the permissions to Admin and set NT AUTHORITY\NETWORK SERVICE as db owners to sgvault and sgdragnet.

After all the permissions were changed I was still unable to login under
Vault Client or Vault Admin Tools. It was now giving me a invaild username or password error. Instead of the FailDBcon error I was
getting before I changed permissions.

I removed Vault Admin and Client. I went to the SourceGear website
and downloaded Vault and installed it on my machine. The new install
works, I am able to login and see all of the data that I restored thru
the Microsoft SQL server 2000 interface to the sgvault database.

Thanks for the help