hutnor
asked on
How do I fix the database error?
Hello
I have the following two errors & do not understand what it mean or what I need to do to fix it. There is about 15 in total & they are all the same only with a few minor changes. So I assume if I fix one they will all go away together.
Any idea on what has gone wrong?
I have the following two errors & do not understand what it mean or what I need to do to fix it. There is about 15 in total & they are all the same only with a few minor changes. So I assume if I fix one they will all go away together.
Any idea on what has gone wrong?
Event Type: Error
Event Source: SQLWRITER
Event Category: None
Event ID: 24583
Date: 14/07/2010
Time: 10:12:13 PM
User: N/A
Computer: dbsvr01
Description:
Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft SQL Native Client
Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 01000, Native Error: 4035
Error state: 1, Severity: 0
Source: Microsoft SQL Native Client
Error message: Processed 0 pages for database 'db01', file 'db01' on file 1.
Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date: 14/07/2010
Time: 10:12:12 PM
User: N/A
Computer: dbsvr01
Description:
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=5556. Thread=10124. Client. Instance=avdb. VD=Global\{E6C09E69-8EB7-47A3-9179-C8343B8A5C45}4_SQLVDIMemoryName_0.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes it does happen during backups but they do not grab any data from SQL. Unless system state backup does something with SQL?
I am a bit confused as to how the error pops up to start with if I am not running a backup of SQL.
Where do I go to look at the self backups that SQL can do? Someone might have set one without me getting told.
I am a bit confused as to how the error pops up to start with if I am not running a backup of SQL.
Where do I go to look at the self backups that SQL can do? Someone might have set one without me getting told.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am not sure if it install SP2 for SQL or not. I went back in the windows update history & SP3 got installed in January this year.
The event is happening all around 10:10pm each day. This is when the backups run so would it be from high disk usage during the backup? However I have not had this problem before.
Arcserve backup is used for backup. On this server it backs up the system state & AD, exchange, file shares.
I was looking at the databases in SQL & they all got backed up yesterday (not sure how I never set anything) when this error is happening.
I assume SQL is doing backups of itself automatic every day at 10pm. Where can I go to change the time of backups happening?
The event is happening all around 10:10pm each day. This is when the backups run so would it be from high disk usage during the backup? However I have not had this problem before.
Arcserve backup is used for backup. On this server it backs up the system state & AD, exchange, file shares.
I was looking at the databases in SQL & they all got backed up yesterday (not sure how I never set anything) when this error is happening.
I assume SQL is doing backups of itself automatic every day at 10pm. Where can I go to change the time of backups happening?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Working now
ASKER
Would setting one remove the problem? Even if it is setting SQL to back itself up to the same location as the current DB.