Unable to restore *.BAK files from NTBackup

From: "Ramjet99" <parry.richard@xxxxxxxxx>
Date: 19 Nov 2006 17:42:57 -0800

Hi,

I have an issue where a SBS2003 SP1 server is having it's SQL backups
being performed to disk by enterprise manager and then backed up to
tape via NTBackup.

I cannot restore the SQL *.BAK files (created using enterprise manager)
from tape to either the original or alternate location.

I get message:

event id 1000

Faulting application ntbackup.exe, version 5.2.3790.1830, faulting
module ntbackup.exe, version 5.2.3790.1830, fault address 0x000c77a0.

I can restore them from existing disk backups with SQL manager.

I can restore other files without issue.

SBS 2003 SP1, HP LTO3 drive with latest firmware

Backups using NTBackup, was version 2.3790.1830 but applied hotfix
894390 and now version 5.2.3790.274 (after fudging the file
protection to let me update to this version)

Anyone have anything else I can try?

.

Follow-Ups:
- Re: Unable to restore *.BAK files from NTBackup
  - From: Frank McCallister SBS MVP

Prev by Date: Re: How do you stop a loop in installation?
Next by Date: Re: POP3 connector errors
Previous by thread: Sharepoint services 3.0 search in SBS 2003 More options
Next by thread: Re: Unable to restore *.BAK files from NTBackup
Index(es):
- Date
- Thread

Relevant Pages

Re: Creating specific users
... A user does not need to be sysadmin to run backups (such as through Query ... but I believe that Enterprise Manager for SQL ...
(microsoft.public.sqlserver.security)
Re: SQL Backup
... Try formatting the tape or using a new, formatted tape - SQL ... Server may not recognize the format from whatever backups ...
(microsoft.public.sqlserver.server)
Re: Location of Data
... > As far as SQL backups, use SQL Enterprise manager to do at least daily ... > backups to your D drive and then let your Backup program bakup the SQL .bak ...
(microsoft.public.windows.server.sbs)
Re: ReportIoError 2 - any ideas?
... job - then modify the schedule as required. ... using DBCC SHRINKFILE to reduce the ldf file size. ... Rerunning the backups through Enterprise Manager. ... My colleagues know even less about SQL Server ...
(microsoft.public.sqlserver.server)
Re: software needed to input data
... ENTERPRISE MANAGER give you a simple one table at a time ... Your programmer might have proprietary rights to the ... >If you are database savvy, you can always get into SQL ...
(microsoft.public.sqlserver.server)