Thursday, March 29, 2012

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

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: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft]&#
91;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: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
Please HelpHi
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/
"Rafet Ducic" <rducic@.hotmail.com> wrote in message
news:OZbJL6iNFHA.164@.TK2MSFTNGP12.phx.gbl...
>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: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.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 networ
k error.
> Check
> your network documentation.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pag
es for
> database 'master', file 'mastlog' on file 1.
> [3] Database model: Database Backup...
> Destination: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
> Please Help
>

No comments:

Post a Comment