SQL restore failing on arcserve

[crveni]

Hello

I have a problem with restoring an sql database. The following error appears

ARCServe for Windows 2000 -- Restore

Job ID........................ 368
Source........................ nikfile wednesday, ID 8704, Sequence #1
Session....................... 34
Target........................ \\ACCOUNTSNT\dbasql70
Start Time.................... 3/11/04 3:32 PM
E8603 Failed to write to database. (DBNAME=EfW_030, EC=)
Total Directories............. 0
Total Files................... 0
Total Databases............... 0
Total Skips................... 0
Total Size (Disk)............. 1 KB
Total Size (DB)............... 0 KB
Total Size (Media)............ 64 KB
Elapsed Time.................. 0s
Average Throughput............ 3.75 MB/min
Total Errors/Warnings......... 1/0

Totals For.................... Job
Total Sessions................ 1
Total Directories............. 0
Total Files................... 0
Total Databases............... 0
Total Skips................... 0
Total Size (Disk)............. 1 KB
Total Size (DB)............... 0 KB
Total Size (Media)............ 64 KB
Elapsed Time.................. 0s
Average Throughput............ 3.75 MB/min
Total Errors/Warnings......... 1/0

Restore Operation Failed.


The machine I am restoring to is a Windows NT SP 6a. Running SQL server Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86). Looking at Microsofts page this confirms that service pack 4 has been installed.

The arcserve server runs windows 2000 sp4, Arcserve 2000 Advanced edition Version 7(build 1100).

Both machines are patched to arcserve service pack 4.

I can confirm that the data is definately on tape by looking at arcserve tape utilities/sessions.

Any ideas?

 

[davidmichel]

Check the activity log instead of the job log to see if the error code is listed at the end of the message.
Check the DB Agent log for the error.
Put the DB Agent in debug and restest it. faq478-4684
Check the SQL Error log.