July 2, 2004 at 6:02 am
Each time I run a backup the following error appears in
SQL Server's error log: Error: 4035, Severity: 10, State: 1
Can anyone help in explaining why I keep getting the above
error? I am running SQL Server 2000 enterprise edition service pack 3.Your help will be greatly appreciated.
July 5, 2004 at 8:00 am
This was removed by the editor as SPAM
July 6, 2004 at 8:15 pm
found this for you:
ou will get this error in a couple of instances:
When you attempt to span media and the volume label is different. KB Article 158326.
or
The LOAD HEADERONLY command does not report the correct size of a dump on the correct row of the query's results. KB Article 166031.
I believe you can avoid these errors by creating a device for each database and not put multiple databases on a single device. You may need to create a database maintenance plan to perform some optimizations and integrity checks.
Microsoft has confirmed both these situations have been around since 6.5 SP2. So they have been around a while.
Without significantly more information I would not be able to advise you, however, maybe these KB articles will point you the right direction.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply