Link to home
Start Free TrialLog in
Avatar of hutnor
hutnorFlag for United States of America

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?
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.

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of PlusIT
PlusIT
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hutnor

ASKER

I do not have any backup set for this SQL server.

Would setting one remove the problem? Even if it is setting SQL to back itself up to the same location as the current DB.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hutnor

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hutnor

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?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hutnor

ASKER

Working now