Backup error in 4.0.2

infinition · Post by **infinition** » Fri Aug 10, 2007 2:56 pm

Hi,

I want to upgrade to 4.0.4, so I'm trying to backup my current database. Unfortunately, I can't !

After some time, I get this error:
------------------------------------------------------
Backup/Restore
An error occurred while creating the backup:

A database error has occured (FailDBReader)
-------------------------------------------------------

Any thoughts?

Best regards

Beth · Post by **Beth** » Fri Aug 10, 2007 4:03 pm

Is this only on the backup and everything else works?

Had you emailed support already?

If not, please run this check

DBCC CHECKDB sgvault

and save all the messages resulting in a document. Then you can either attach that here or you can email it to support at sourcegear.com (attn: Beth) with a link to this forum post.

infinition · Post by **infinition** » Mon Aug 13, 2007 7:17 am

No, I haven't emailed Tech Support so far.

And yes, everything else seems to be working fine. One question, where do I enter this command you suggested?

Best regards

Beth · Post by **Beth** » Mon Aug 13, 2007 8:23 am

That would go into your SQL Query Analyzer on your SQL machine that holds the vault database.

infinition · Post by **infinition** » Mon Aug 13, 2007 8:38 am

Ok, I got it. It reports no errors.

Beth · Post by **Beth** » Mon Aug 13, 2007 10:25 am

Can you look in your Vault server log at the same time that your FailDBReader errors happened and see if there are any errors or exceptions logged at the same time?

It would be good to also check your Event Viewer log during the same time that error happened to see what's logged there.

Please post any you find.

infinition · Post by **infinition** » Mon Aug 13, 2007 11:54 am

Ok, here is my sgvault.log file (part of it). It starts when I try to backup. There is some kind of login failure, but I'm confused, because everything else is working fine, even with the Admin user.

- The result.txt file is the log;
- The events.txt file is a copy/paste of all the events that occured from the start of the backup till the end. What I see there is the login failures, a try to login to a DragNet database (hum... I don't have DragNet !) and more surprising, 2 events indicating that the database has been backuped correctly.. (why 2 events and not 1?)

That's about it.
Best regards.

Beth · Post by **Beth** » Mon Aug 13, 2007 2:15 pm

It looks like the permissions for NT Authority/Network Service aren't quite right in the database.

Is the SQL server on the same machine as the Vault server?

I am attaching a document that shows where you need to have NT Authority/Network Service in the SQL database. Based on your setup, that might not be the best account to use, but I won't know until I know more about your setup.

infinition · Post by **infinition** » Mon Aug 13, 2007 2:29 pm

yes, the SQL Server is on the same machine. It is my first backup attempt since I moved from 3.5 to 4.0.2.

Maybe I made a mistake in the reinstallation...

Will read the document.

infinition · Post by **infinition** » Mon Aug 13, 2007 2:46 pm

I have two things that differs from your document.

1- In the Step 2), if I click on the sgvault or sgmaster database in the "users mapped to this login" grid, I see that "db_owner" is checked in the "Database role membership for: ..."

This might not be different, but I report it just in case.

2- The "Default Schema" is not set to "dbo" for both. When I try to set it, I get an error (see attachment).

I will try to find information on those errors while I wait for your answer.

Beth · Post by **Beth** » Mon Aug 13, 2007 3:38 pm

Are you performing the backup with Vault or with SQL Server Manager?

infinition · Post by **infinition** » Tue Aug 14, 2007 8:01 am

With Vault (the Admin tool, well the Admin web page)

Beth · Post by **Beth** » Tue Aug 14, 2007 1:35 pm

It appears that a bug has been found. Sorry for the inconvenience. The developers are working on fixing that. In the meantime, you can still create backups with the SQL Server Management Studio. You can right click a database, select Tasks - Back up. You will need to back up sgvault and sgmaster.

infinition · Post by **infinition** » Tue Aug 14, 2007 2:31 pm

ok thanks.
I'll wait for the fix before upgrading the version to 4.0.4 (or newest).

I'll keep checking this post for updates.
Best regards.