Backup error on Microsoft CMS 2002 SP1A Database

I have set up a Database maintenance plan to perform full backup on all
databases on a daily basis. Recently I notice that it is failing to backup
the Microsoft Content Management Server 2002 SP1a Database on SQL Server
2000 with SP3a. The error log for the maintenance job is:
[21] Database Website: Database Backup...
Destination: & #91;d:\MSSQL\BACKUP\Website\Website_db_2
00403091753.BAK]
** Execution Time: 0 hrs, 0 mins, 4 secs **
[22] Database Website: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'd:\MSSQL\BACKUP\Website\Website_db_2004
03091753.BAK'. Device error or
device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE i
s
terminating abnormally.
Deleting old text reports... 0 file(s) deleted.
The file d:\MSSQL\Log\ERROR contains the following corresponding entry
2004-03-09 17:53:51.51 backup BACKUP failed to complete the command
BACKUP DATABASE [Website] TO DISK =
N'd:\MSSQL\BACKUP\Website\Website_db_200
403091753.BAK' WITH INIT ,
NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
2004-03-09 17:53:51.53 spid64 BackupDiskFile::OpenMedia: Backup device
'd:\MSSQL\BACKUP\Website\Website_db_2004
03091753.BAK' failed to open.
Operating system error = 32(error not found).
What is going on and how could I rectify this (without stopping and
service)?hi Patrick,
this seems to be a SQL related question.
Please post to an SQL related newsgroup.
Cheers,
Stefan.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
news:e6kihBgBEHA.688@.tk2msftngp13.phx.gbl...
> I have set up a Database maintenance plan to perform full backup on all
> databases on a daily basis. Recently I notice that it is failing to
backup
> the Microsoft Content Management Server 2002 SP1a Database on SQL Server
> 2000 with SP3a. The error log for the maintenance job is:
> [21] Database Website: Database Backup...
> Destination: & #91;d:\MSSQL\BACKUP\Website\Website_db_2
00403091753.BAK]
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> [22] Database Website: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODB
C
SQL
> Server Driver][SQL Server]Cannot open backup device
> 'd:\MSSQL\BACKUP\Website\Website_db_2004
03091753.BAK'. Device error or
> device off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE
is
> terminating abnormally.
> Deleting old text reports... 0 file(s) deleted.
>
> The file d:\MSSQL\Log\ERROR contains the following corresponding entry
> 2004-03-09 17:53:51.51 backup BACKUP failed to complete the command
> BACKUP DATABASE [Website] TO DISK =
> N'd:\MSSQL\BACKUP\Website\Website_db_200
403091753.BAK' WITH INIT ,
> NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> 2004-03-09 17:53:51.53 spid64 BackupDiskFile::OpenMedia: Backup device
> 'd:\MSSQL\BACKUP\Website\Website_db_2004
03091753.BAK' failed to open.
> Operating system error = 32(error not found).
> What is going on and how could I rectify this (without stopping and
> service)?
>|||Patrick,
It sounds like it could be a rights problem, such as described in:
PRB: Unable to Back Up Database to a Network Drive Without Permissions
http://support.microsoft.com/defaul...kb;en-us;207187
Alternatively, the device is offline.
(OR the disk is full and cannot create another file. But I would have
expected a different message.)
Russell Fields
"Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
news:e6kihBgBEHA.688@.tk2msftngp13.phx.gbl...
> I have set up a Database maintenance plan to perform full backup on all
> databases on a daily basis. Recently I notice that it is failing to
backup
> the Microsoft Content Management Server 2002 SP1a Database on SQL Server
> 2000 with SP3a. The error log for the maintenance job is:
> [21] Database Website: Database Backup...
> Destination: & #91;d:\MSSQL\BACKUP\Website\Website_db_2
00403091753.BAK]
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> [22] Database Website: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODB
C
SQL
> Server Driver][SQL Server]Cannot open backup device
> 'd:\MSSQL\BACKUP\Website\Website_db_2004
03091753.BAK'. Device error or
> device off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE
is
> terminating abnormally.
> Deleting old text reports... 0 file(s) deleted.
>
> The file d:\MSSQL\Log\ERROR contains the following corresponding entry
> 2004-03-09 17:53:51.51 backup BACKUP failed to complete the command
> BACKUP DATABASE [Website] TO DISK =
> N'd:\MSSQL\BACKUP\Website\Website_db_200
403091753.BAK' WITH INIT ,
> NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> 2004-03-09 17:53:51.53 spid64 BackupDiskFile::OpenMedia: Backup device
> 'd:\MSSQL\BACKUP\Website\Website_db_2004
03091753.BAK' failed to open.
> Operating system error = 32(error not found).
> What is going on and how could I rectify this (without stopping and
> service)?
>|||I don't think the two reasons apply to me, because
1) The backup is done to d:\MSSQL\Backup (a local drive), which the SQL
Server and SQL Agent service account user has permission to right to (the
service account user has local admin priviledges)
2) The database is online (it is functioning otherwise) and so is d:\
The Maintenance plan succeeded in backing up *All* other database on the
same local server running:
1) SQL Server 2000 SP3a
2) Windows 2000 with SP4
The Maintenance plan also succeeded in backing up that database for >1 week
before it become persistently failing!
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OY5grWgBEHA.1380@.TK2MSFTNGP10.phx.gbl...
> Patrick,
> It sounds like it could be a rights problem, such as described in:
> PRB: Unable to Back Up Database to a Network Drive Without Permissions
> http://support.microsoft.com/defaul...kb;en-us;207187
> Alternatively, the device is offline.
> (OR the disk is full and cannot create another file. But I would have
> expected a different message.)
> Russell Fields
> "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> news:e6kihBgBEHA.688@.tk2msftngp13.phx.gbl...
> backup
> SQL
device
>|||I just did another search and found
http://groups.google.com/groups?hl=...r />
ie%3DUTF-
8%26oe%3DUTF-8%26hl%3Den%26btnG%3DGoogle%2BSearch
I am using Symantec Anti Virus Corporate Edition Client (although will move
over to McAfee Virus Scan 7 soon), but confused as to why the DB Maintenance
plan is just failing to back up on this single database. The only thing
special about this database is that there might be people *reading* from it
whilst the backup is being one, but I should have thought that SQL Server
should cope with this OK.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OY5grWgBEHA.1380@.TK2MSFTNGP10.phx.gbl...
> Patrick,
> It sounds like it could be a rights problem, such as described in:
> PRB: Unable to Back Up Database to a Network Drive Without Permissions
> http://support.microsoft.com/defaul...kb;en-us;207187
> Alternatively, the device is offline.
> (OR the disk is full and cannot create another file. But I would have
> expected a different message.)
> Russell Fields
> "Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
> news:e6kihBgBEHA.688@.tk2msftngp13.phx.gbl...
> backup
> SQL
device
>|||Hi Patrick,
Thank your for using the newsgroup. It is my pleasure to help you with your
issue.
From you information, you job to maintenance the database 'Website' ran
fine in the past, however, just recently, it persistently failed.
There must be some change that different with before, so I want to confirm
that when you disable the Anti-Virus Software on your computer, do you
still meet the problem? The following link would take you to the download
of the Utility called ProcessExplorer that you can use to monitor access of
files by different processes.
To find what processes are accessing a particular file, you would need to
Search and enter the File Name for obtaining a list of the processes.
http://www.sysinternals.com/ntw2k/f...e/procexp.shtml
If it is not caused by the Anti-Virus software, you could try the following
steps to narrow down the problem. First, stop the antivirus software and:
1) In the Enterprise Manager, using the Backup Wizard to backup the
database, any problems?
2) Run in you Query Analyzer the following code (Suppose you are using sa
and you login into the Query Analyzer by the account starting the SQL Agent
Service):
Exec xp_cmdshell 'md d:\MSSQL\BACKUP\Website\aaa'
Go
Exec xp_cmdshell 'rd d:\MSSQL\BACKUP\Website\aaa'
go
BACKUP DATABASE [Website] TO DISK
=N'd:\MSSQL\BACKUP\Website\Website_db_20
0403091753.BAK' WITH INIT ,
NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
Is there any Problems and messages?
Looking forward to you reply.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||1) I did a serach for handle *.BAK with SysInternal's process explorer and
could not find Symantec Anti Virus trying to access the *.BAK file.
2) I could select the Website database, right click All Task->Backup
Database to do a complete backup successfully
3) For some reason if I log on as a user with DBA role (by Windows admin
group membership) into query analyser, the execution of EXEC xp_cmdshell
failed saying command not found, but more worrying is that when I execute
the backup command, I get the following error
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
10 percent backed up.
Connection Broken
The SQLServer 2000 with SP3a is installed on a Windows 2000 SP4 running
Microsoft Content Management Server 2002 SP1A, ASP.NET, ASP applications and
it is a domain controller. The SQL Client Network utility is configured as
followed:
- Enabled Shared memory protocol not ticked
- enabled Protocol by order- Named Piped, TCP/IP
SQL Client was set up as above because there were timed-out issues when
using the Microsoft Content Management Server 2002 SP1A Site deployment
import scripts.
What is wrong?
"Baisong Wei[MSFT]" <v-baiwei@.online.microsoft.com> wrote in message
news:jA66KVmBEHA.660@.cpmsftngxa06.phx.gbl...
> Hi Patrick,
> Thank your for using the newsgroup. It is my pleasure to help you with
your
> issue.
> From you information, you job to maintenance the database 'Website' ran
> fine in the past, however, just recently, it persistently failed.
> There must be some change that different with before, so I want to confirm
> that when you disable the Anti-Virus Software on your computer, do you
> still meet the problem? The following link would take you to the download
> of the Utility called ProcessExplorer that you can use to monitor access
of
> files by different processes.

> To find what processes are accessing a particular file, you would need to
> Search and enter the File Name for obtaining a list of the processes.
> http://www.sysinternals.com/ntw2k/f...e/procexp.shtml
> If it is not caused by the Anti-Virus software, you could try the
following
> steps to narrow down the problem. First, stop the antivirus software and:
> 1) In the Enterprise Manager, using the Backup Wizard to backup the
> database, any problems?
> 2) Run in you Query Analyzer the following code (Suppose you are using sa
> and you login into the Query Analyzer by the account starting the SQL
Agent
> Service):
> Exec xp_cmdshell 'md d:\MSSQL\BACKUP\Website\aaa'
> Go
> Exec xp_cmdshell 'rd d:\MSSQL\BACKUP\Website\aaa'
> go
> BACKUP DATABASE [Website] TO DISK
> =N'd:\MSSQL\BACKUP\Website\Website_db_20
0403091753.BAK' WITH INIT ,
> NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
> Is there any Problems and messages?
> Looking forward to you reply.
> Thanks
> Best regards
> Baisong Wei
> Microsoft Online Support
> ----
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>
>|||Strangely, if I change SQL Client Network utility to use TCP/IP before
Named-pipes, then the problem seems to have gone. But why is this? I
thought when SQL Server is installed locally to the server, named-pipes go
via the system kernel which is meant to be super fast?
"Patrick" <patl@.reply.newsgroup.msn.com> wrote in message
news:uy6S1VoBEHA.2888@.TK2MSFTNGP09.phx.gbl...
> 1) I did a serach for handle *.BAK with SysInternal's process explorer and
> could not find Symantec Anti Virus trying to access the *.BAK file.
> 2) I could select the Website database, right click All Task->Backup
> Database to do a complete backup successfully
> 3) For some reason if I log on as a user with DBA role (by Windows admin
> group membership) into query analyser, the execution of EXEC xp_cmdshell
> failed saying command not found, but more worrying is that when I execute
> the backup command, I get the following error
> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRe
ad
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 10 percent backed up.
> Connection Broken
> The SQLServer 2000 with SP3a is installed on a Windows 2000 SP4 running
> Microsoft Content Management Server 2002 SP1A, ASP.NET, ASP applications
and
> it is a domain controller. The SQL Client Network utility is configured
as
> followed:
> - Enabled Shared memory protocol not ticked
> - enabled Protocol by order- Named Piped, TCP/IP
> SQL Client was set up as above because there were timed-out issues when
> using the Microsoft Content Management Server 2002 SP1A Site deployment
> import scripts.
> What is wrong?
> "Baisong Wei[MSFT]" <v-baiwei@.online.microsoft.com> wrote in message
> news:jA66KVmBEHA.660@.cpmsftngxa06.phx.gbl...
> your
confirm
download
> of
>
to
> following
and:
sa
> Agent
rights.
>|||Hi Patrick,
Thanks for your update. You did a lot of work in troubleshooting this
problem and it seems that you have found a workaround for the this problem.
It is much helpful and appreciated.
For the xp_cmdshell, the execute permissions for xp_cmdshell default to
members of the sysadmin fixed server role, but can be granted to other
users. I just want to make sure the account to run the backup job (SQL
Agent Service Account is the account that will finally run the job, if
proxy is not used) has the permission on the specific folder.
For your question of using TCP/IP instead of the Named Pipe, please refer
to the following article:
General Network Error When You Try to Back up or Restore a SQL Server
Database on a Computer That Is Running Windows Server 2003 (also apply to
Windows Server 2000)
http://support.microsoft.com/?id=827452
Then you could use the SQL Agent starting service account to run the backup
statement successfully, you could create the maintance job. If there is
any more problems about it, I will be ready to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.