sql server connect: General network error when you try to back up or restore a SQL Server 2000 on Windows 2000 -- sql server connect

General network error when you try to back up or restore a SQL Server 2000 on Windows 2000

Rafet Ducic
3/31/2005 3:17:00 PM

sql server connect: I am receiving General network error when I try to back up a SQL Server
database on a computer that is running Windows Server 2000

I receive Following error when running DB maintenance job:

[2] Database master: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\master_db_200503311443.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft][ODBC SQL
Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network error. Check
your network documentation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for
database 'master', file 'mastlog' on file 1.
[3] Database model: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\model_db_200503311443.BAK]

Please Help

Re: General network error when you try to back up or restore a SQL Server 2000 on Windows 2000

Mike Epprecht (SQL MVP)
3/31/2005 11:36:24 PM

Hi

Maintenance plans do not support UNC paths. You need to use T-SQL to do
that.

At the same time, check that the account that the SQL Service is running
under has permissions on the destination directory.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]