error restoring sql server 2000 db on win 2003

[Amer]

I am using 11d to back up sql server 2000 db on win 2003. it is successful in backup with & without consistency check.  BUT when i try to restore it fails with the following error

1. when consistency check is ON during backup /restore

Job completion status:

job ended             : monday, april ....

completed status: failed

final error             : 0xe0008443 - one or more sql database consistency checks have failed.

final error category : resource errors

for additional information regarding this error refer to link v-79-57344-33859

Errors:

restore                   : mytestserver

v-79-57344-65085 - there was problem runnin the dbcc

database 'mytestdb' cannot be opened. it is in the middle of restore.

2. when consistency check is OFF during backup /restore

Job completion status:

job ended             : monday, april ....

completed status: failed

final error             : 0xe0008443 - one or more sql database consistency checks have failed.

final error category : resource errors

for additional information regarding this error refer to link v-79-57344-33859

-------------

whats the problem and how to fix it.

[Patty_McGowan]

Hello,

This normally indicates that there is an issue with the SQL database.

I would recommend running DBCC Checkcatalog on that database.

This does require the database to be online.

If the database was corrupt and this is why you are restoring it I would suggest going back a couple of more days on the backups for restore.

Patty

[Amer]

1. i have run dbcc checkcatalog -- result is ok

2. when i take backup from sql server and restore.. its ok

3. my database  should be ok.( i run weekly db integrity check including indexes, as part of maintenance plan - never get any negative output out of it).

actually we have implement vertias recently and try to verify it by restoring in test machine.

the veritas options for backup and restore seems very straight forward.

[Patty_McGowan]

Amer,

Here is a technote that talks about the options for SQL:

http://support.veritas.com/docs/265692

You can also see errors when there is not enough disk space for the restore.

What version of SQL are you running?

Patty

[Amer]

1. i have gone thru the link and our setup is similar to it.

2. i can see lot of space still available at time of error. the disk space is lot more than the db i am trying to restore. further, when i see the job history in BE11d.. i can see that i has transfered 99 % of data to the new server and only few kb tranfer is left.

3. i am using sql server 2000 on win 2003 server on both (backup and restore) server.

i am searching all the possible areas still could not get any info about fixing it.

[Amer]

any help !!!

[Patty_McGowan]

Hi,

When you are running the restore, can you open task manager and watch the performance. 

A memory allocation request failed. The computer may be running low on virtual memory

Please let me know.

Thanks.

[Amer]

i dont think it can be a reason. for testing i create a small db (20 mb) and try to backup and restore using veritas.. it fails with the same error as our real db.

but everything is fine if we backup and restore with sql server itself.

we are restoring on a test server which is a good machine with no size or memory or configuration problem.

the thing is we recently added up the sql 2005 agent to veritas(in addition to sql 2000), before that we were having only sql 2000 and it was fine. is this has something to do with this change.

[Patty_McGowan]

Are you running BE 11.0.6235 or 7170?

Also, please try to restore the production DB and the test one that you have created in one job.

Thanks.

Patty