Sunday, March 25, 2012

backup error

Hi all,
Sql server 7.0
I have backup job which takes the backup of the databases
at particular time once in a day. when i go to the
destination i can see the backup is taken and find
the .bak file in it. but i am getting the following error
message in sql error logs pls help me in identifying and
resolving this problem
BackupVirtualDeviceSet::Initialize: Open failure on backup
device 'BackupExecSqlAgent_Bas_BBC_PUND_00'. Operating
system error -2147024894(The system cannot find the file
specified.).
TIA
Seems you are using BackupExec. I suggest you discuss this when them, as the error suggests that SQL
Server cannot write to the virtual backup device...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"haseeb" <anonymous@.discussions.microsoft.com> wrote in message
news:b15001c499a2$4bdb4730$a601280a@.phx.gbl...
> Hi all,
> Sql server 7.0
> I have backup job which takes the backup of the databases
> at particular time once in a day. when i go to the
> destination i can see the backup is taken and find
> the .bak file in it. but i am getting the following error
> message in sql error logs pls help me in identifying and
> resolving this problem
> BackupVirtualDeviceSet::Initialize: Open failure on backup
> device 'BackupExecSqlAgent_Bas_BBC_PUND_00'. Operating
> system error -2147024894(The system cannot find the file
> specified.).
> TIA
>
|||There is a timeout property that you need to increase.
It seems like backup in your case takes for a while and client
just doesn't wait til end of it.
Connection timeout
http://msdn.microsoft.com/library/de...tringtopic.asp
Command timeout
http://msdn.microsoft.com/library/de... outtopic.asp
Regards.
"Craig HB" wrote:

> I had a backup scheduled for a a time when people are using the website.
> I got this error...
> 59System.Data.SqlClient.SqlException: General network error. Check your
> network documentation
> Shouldn't you be able to backup while people are using the database ?
> It is about 4.5 Gigs in size -- would that make a difference ?
> Thanks,
> Craig

No comments:

Post a Comment