Backup error in 4.0.2

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Backup error in 4.0.2

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
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

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
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

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
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

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
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

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

Ok, I got it. It reports no errors.
Attachments
result.txt
(11.82 KiB) Downloaded 457 times

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

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
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

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.
Attachments
result.txt
(57.83 KiB) Downloaded 464 times
events.txt
(12 KiB) Downloaded 867 times

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

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.
Attachments
SQL Security.doc
(192 KiB) Downloaded 449 times

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

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
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

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.
Attachments
error.JPG
error.JPG (157.54 KiB) Viewed 12100 times

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

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

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

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

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

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

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

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
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

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.

Locked