Very Computer

I am having problems when I try to backup user
databases.  I get this message when I try to backup
manually or using the maintenace plan.

 Database BuildingData: Database Backup...
    Destination:
[\\Earth\SQLBackups\BuildingData\BuildingData_db_200302151
730.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3013:
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
DATABASE is terminating abnormally.

This does not occur when I make a backup to the server
that the databases are located on.

The problem does not always occur on the same database.  
The database that has the problem changes with each
backup.

I suspect the problem is either a network problem or (less likely)
security....

Check (with your network guy) on the number of network errors during the
backup...Also the SQL NT login must have write access to the network share.

--
Wayne Snyder MCDBA, SQL Server MVP
Computer  Education Services Corp (CESC), C*te, NC
(Please respond only to the newsgroups.)

PASS - the definitive, global community
for SQL Server professionals - http://www.veryComputer.com/

Quote:> I am having problems when I try to backup user
> databases.  I get this message when I try to backup
> manually or using the maintenace plan.

>  Database BuildingData: Database Backup...
>     Destination:
> [\\Earth\SQLBackups\BuildingData\BuildingData_db_200302151
> 730.BAK]
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3013:
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
> DATABASE is terminating abnormally.

> This does not occur when I make a backup to the server
> that the databases are located on.

> The problem does not always occur on the same database.
> The database that has the problem changes with each
> backup.

Would you have any other suggestions?
The network guy does not monitor network traffic.  He said that we there
is a gig of data passing between the servers and nothing else it going
on at the time the maintenance plans are scheduled.  We have them
scheduled for late at night when there is very little, if any traffic.
We are not having problem with our network during the day when network
traffic is heavy.  The SQL NT login does have write access to the
network share.  Thanks for your help.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I'd agree with Wayne in that it is likely network related
(but other issues are always a possibility). With network
issues, traffic isn't necessarily the one and only cause.
Have you checked the NT event logs? Being that you are
trying to backup to a network location, I'd look for issues
like redirector timeouts which would be in the event logs.
Could be a lot of other network related things - issues with
the NIC, etc. I'd comb through the logs for other clues on
where network communication could be causing the problems.  

-Sue

On Mon, 17 Feb 2003 11:51:40 -0800, Lynette Schlemmer