Re: DB Maintenance Plan

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 06/03/04 

Date: Thu, 3 Jun 2004 08:34:24 -0400

This looks like a network or file system error. Try to determine if it
fails all of the time or some of the time. Does the failure relate to the
size of the database backup. or the space available on the hard drive...

It is not a good idea to use mapped drive letters, because that could change
if someone else logs on to the system...Perhaps that is happening..
Change the backup to use a UNC name ie

backup database prod to disk = '\\server\share\dbname.bak' with format
and see if that makes any difference..

Also check the event logs ( and check with network folks) to see if there
have been any funny network things happening lately. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ravi" <luckyguy_2200in@yahoo.co.in> wrote in message
news:515F80F2-A50E-4B6F-8C48-D510724951C6@microsoft.com...
> Hi Gurus,
>
> I am getting an error while the backup plan is getting executed. Until
last week it is fine working perfectly. Nothing has been changed as far as
the settings are concerned. The job is run every night. It is being executed
as a domain user (domain\administrator) and the backup is being written to
the network mapped drive
(\\ipaddress\<driveletter>\Backups\<servername>\<dbname.bak>).
>
> Whenever it is failed, the status is being shown as 64, see the SQL Server
error log for details. [SQLState 42000] (Erorr 3202) Backup database is
terminating abnormally. [SQLState 42000] (Error 3013). The step failed.
>
> The statement being used is
>
> Backup Database <dbname> to Disk =
'\\ipaddress\<driveletter>\Backups\<servername>\<dbname.bak>' With Format
>
> Other details are as follows:
>
> BackupMedium::ReportIoError: read failure on backup device
'\\ipaddress\<driveletter>\Backups\<servername>\<dbname_log.bak>'. Operating
system error 64(The specified network name is no longer available.).
>
> BACKUP failed to complete the command BACKUP DATABASE REPL TO DISK =
'\\ipaddress\<driveletter>\Backups\<servername>\<dbname.bak>' WITH FORMAT
>
> Internal I/O request 0x2B97F408: Op: Read, pBuffer: 0x00000000, Size: 52,
Position: 12884901921, RetryCount: 8454144, SubIoCount: 2, UMS: Internal:
0x2, InternalHigh: 0x1, Offset: 0x1, OffsetHigh: 0x1, m_buf: 0x00010001,
m_len: 1, m_actualBytes: 0, m_errcode: 64, BackupFile: n/a
>
> Any guidance will be highly appreciated as i am trying to find a solution
for a long time.
>
> Thanks in advance.
>

Relevant Pages

  • Re: backing up to network share issue.
    ... impersonation when it accesses the backup file on behalf of the SQL Server uses that executed the backup ... SQL Server just uses the SQL Server service account when accessing the backup share. ... > As Tibor stated, this is not an SQL Server issue, it is a network ...
    (microsoft.public.sqlserver.msde)
  • Re: Unable to Backup on Network
    ... service accoutn from the 'Local System' account to a specific account. ... I like to log in to the SQL server console as the service account to test ... > The operating system on which my SQL Server 2000 is there is Windows 2000> Server while i want to take the backup on another computer on network which> also has same operating system. ...
    (microsoft.public.sqlserver.security)
  • Re: Backing up database on a network machine
    ... You cant see the network drives. ... You Should start SQL server using Domain user who got access to remote ... Now you can execute the Backup script with UNC path ...
    (microsoft.public.sqlserver.msde)
  • Re: backing up to network share issue.
    ... As Tibor stated, this is not an SQL Server issue, it is a network ... The SQL login that is accessing the MSDE instance is not ... a factor in whether the process doing the backup has the correct permissions ...
    (microsoft.public.sqlserver.msde)
  • RE: HTTP 404 errors
    ... NIC (network Interface Card) in our configuration. ... "Company Web Page" or to list the backup results in the "Server ... Backup program is functioninng properly, but the part that lists the results ... Server Management -Backup - Monitoring and Reporting ...
    (microsoft.public.windows.server.sbs)
Quantcast