Backup error in 4.0.2
Moderator: SourceGear
-
- Posts: 26
- Joined: Fri Apr 27, 2007 8:13 am
Backup error in 4.0.2
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
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
Is this only on the backup and everything else works?
Had you emailed support already?
If not, please run this check
Had you emailed support already?
If not, please run this check
- DBCC CHECKDB sgvault
-
- Posts: 26
- Joined: Fri Apr 27, 2007 8:13 am
-
- Posts: 26
- Joined: Fri Apr 27, 2007 8:13 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.
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.
-
- Posts: 26
- Joined: Fri Apr 27, 2007 8:13 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.
- 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 776 times
-
- events.txt
- (12 KiB) Downloaded 1224 times
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.
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 770 times
-
- Posts: 26
- Joined: Fri Apr 27, 2007 8:13 am
-
- Posts: 26
- Joined: Fri Apr 27, 2007 8:13 am
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.
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 (157.54 KiB) Viewed 17849 times
-
- Posts: 26
- Joined: Fri Apr 27, 2007 8:13 am
-
- Posts: 26
- Joined: Fri Apr 27, 2007 8:13 am