Friday, March 30, 2012

Problems with TLog Backup

To All:
TLog backups have been going smoothly for many months. Now, the following
messages are generated (always together) with increasing frequency.
3041 :
BACKUP failed to complete the command backup log "Apollo" to
VIRTUAL_DEVICE='VNBU0-2416-2316' with blocksize = 512, maxtransfersize = 65536, buffercount = 1
18210 :
BackupVirtualDeviceSet::Initialize: CoCreateInstance failure on
backup device 'VNBU0-2416-2316'. Operating system error -2147467262(No such
interface supported).
The fellow in charge of backups wants me to reboot the server daily. This
isn't the answer to this problem. Any suggestions are appreciated.
Regards,
Michael CliffordIs the backup device local ?
If not can you backup locally ?
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Michael Clifford" <mjclifford_nospam@.mindspring.com> wrote in message
news:ufZJblQiDHA.2164@.TK2MSFTNGP09.phx.gbl...
> To All:
> TLog backups have been going smoothly for many months. Now, the following
> messages are generated (always together) with increasing frequency.
> 3041 :
> BACKUP failed to complete the command backup log "Apollo" to
> VIRTUAL_DEVICE='VNBU0-2416-2316' with blocksize = 512, maxtransfersize => 65536, buffercount = 1
> 18210 :
> BackupVirtualDeviceSet::Initialize: CoCreateInstance failure on
> backup device 'VNBU0-2416-2316'. Operating system error -2147467262(No
such
> interface supported).
>
> The fellow in charge of backups wants me to reboot the server daily. This
> isn't the answer to this problem. Any suggestions are appreciated.
>
> Regards,
> Michael Clifford
>
>
>|||Allan,
Backups are done with an enterprise level Veritas SQL Agent on the local box
and a tape backup server remotely.
Michael
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:uEA1oASiDHA.1508@.TK2MSFTNGP10.phx.gbl...
> Is the backup device local ?
> If not can you backup locally ?
> --
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "Michael Clifford" <mjclifford_nospam@.mindspring.com> wrote in message
> news:ufZJblQiDHA.2164@.TK2MSFTNGP09.phx.gbl...
> > To All:
> >
> > TLog backups have been going smoothly for many months. Now, the
following
> > messages are generated (always together) with increasing frequency.
> >
> > 3041 :
> >
> > BACKUP failed to complete the command backup log "Apollo" to
> > VIRTUAL_DEVICE='VNBU0-2416-2316' with blocksize = 512, maxtransfersize => > 65536, buffercount = 1
> >
> > 18210 :
> >
> > BackupVirtualDeviceSet::Initialize: CoCreateInstance failure on
> > backup device 'VNBU0-2416-2316'. Operating system error -2147467262(No
> such
> > interface supported).
> >
> >
> >
> > The fellow in charge of backups wants me to reboot the server daily.
This
> > isn't the answer to this problem. Any suggestions are appreciated.
> >
> >
> >
> > Regards,
> >
> > Michael Clifford
> >
> >
> >
> >
> >
> >
>|||OK so these are those "Suck the guts" backups from an "Agent" ?
Can you issue a simple BACKUP DATABASE <<name>> TO DISK = '<<local disk
file>>'
Have you seen this
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q323/6/02.asp&NoWebContent=1
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Michael Clifford" <mjclifford_nospam@.mindspring.com> wrote in message
news:uzrz%23bZiDHA.1624@.tk2msftngp13.phx.gbl...
> Allan,
> Backups are done with an enterprise level Veritas SQL Agent on the local
box
> and a tape backup server remotely.
> Michael
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:uEA1oASiDHA.1508@.TK2MSFTNGP10.phx.gbl...
> > Is the backup device local ?
> > If not can you backup locally ?
> >
> > --
> > --
> >
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE,MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> > "Michael Clifford" <mjclifford_nospam@.mindspring.com> wrote in message
> > news:ufZJblQiDHA.2164@.TK2MSFTNGP09.phx.gbl...
> > > To All:
> > >
> > > TLog backups have been going smoothly for many months. Now, the
> following
> > > messages are generated (always together) with increasing frequency.
> > >
> > > 3041 :
> > >
> > > BACKUP failed to complete the command backup log "Apollo" to
> > > VIRTUAL_DEVICE='VNBU0-2416-2316' with blocksize = 512, maxtransfersize
=> > > 65536, buffercount = 1
> > >
> > > 18210 :
> > >
> > > BackupVirtualDeviceSet::Initialize: CoCreateInstance failure
on
> > > backup device 'VNBU0-2416-2316'. Operating system error -2147467262(No
> > such
> > > interface supported).
> > >
> > >
> > >
> > > The fellow in charge of backups wants me to reboot the server daily.
> This
> > > isn't the answer to this problem. Any suggestions are appreciated.
> > >
> > >
> > >
> > > Regards,
> > >
> > > Michael Clifford
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>sql

No comments:

Post a Comment