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

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.B AK]
Please Help
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/
"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: [\\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.B AK]
> Please Help
>

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
>

future enhancement

I would like to see bread crumbs in report manager for linked reports and drill through to make it easier for users to navigate back to the parent and intermediary reports. The browser back button can be a little flakey. It would be REALLY nice if this could be put into the new report viewer control in VS 2005 also.

I would also like to see a "My Reports" feature that would allow a user to create a list of reports they most frequently access. I have created a custom solution to do this and only told a few users about it; now there are 276 entries in it. We have about 80 users total. I looked at the subscription option but it requires to many settings. Most of our reports have parameters, a date range being the most common, that are not static and therefore subscriptions would be a little tedious to use.

By the way, I am not sure if there is a better forum for this.

Further to 'slow backups'

I'm backing up to a tape drive
Why does each db take the same time to back up, regardless
of db size...''?Read the page titled "Optimizing Backup and Restore Performance" in SQL
Server 2000 Books Online. It discusses how to optimize backups to tape.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"H jones" <anonymous@.discussions.microsoft.com> wrote in message
news:031201c3db58$a1d52010$a001280a@.phx.gbl...
I'm backing up to a tape drive
Why does each db take the same time to back up, regardless
of db size...''?

Further to 'slow backups'

I'm backing up to a tape drive
Why does each db take the same time to back up, regardless
of db size...''?Read the page titled "Optimizing Backup and Restore Performance" in SQL
Server 2000 Books Online. It discusses how to optimize backups to tape.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"H jones" <anonymous@.discussions.microsoft.com> wrote in message
news:031201c3db58$a1d52010$a001280a@.phx.gbl...
I'm backing up to a tape drive
Why does each db take the same time to back up, regardless
of db size...''?

Funny search error

I have two fields I am searching on ... address and zipCode

When I have both pieces of data, everything is fine, i get back the expected results, but i am unable able to search on the individual pieces. Here is the SQL I am using. It's placed within a store procedure in Sqlserver that I amreferencing from my VB.net code... any help??

 IF ((NOT @.address IS NULL) AND( NOT @.zipCode IS NULL))
 BEGIN
SELECT OrderNumber FROM Orders WHERE ShpAddr_Address1 = @.address AND ShpAddr_ZipCode = @.zipCode
 END
ELSE IF NOT @.address IS NULL
 BEGIN
SELECT OrderNumber FROM Orders WHERE ShpAddr_Address1 = @.address
 END
ELSE IF NOT @.zipCode IS NULL
 BEGIN
SELECT OrderNumber FROM Orders WHERE ShpAddr_ZipCode = @.zipCode
 END

any help would be great. thanksMy guess is that your parameters (@.address and @.zipCode) contain empty strings, not NULLs.

You VB.NET code should be setting the parameter value to SQLString.Null if the user did not choose to use the parameter.

I would then also consider changing your stored procedure to simply this:

SELECT OrderNumber FROM Orders WHERE ShpAddr_Address1 = ISNULL(@.address,ShpAddr_Address1) AND ShpAddr_ZipCode = ISNULL(@.zipCode,ShpAddr_ZipCode)

I make this suggestion for ease of code maintenance. I myself have gotten burned several times over the past month by not changing all relevant similar blocks of code in a stored procedure when the logic needed to change.

Terri|||I'm trying this right now as we speak, but my program refuses to reconize what a "SqlString" is. Is there anything special i have to import?|||It's in the System.Data.SqlTypes namespace, so you can either import the namespace or reference it with the fully qualified name: System.Data.SqlTypes.SqlString.Null.

Terri