Backup over network

Hi ,
From last year I have created a backups over network
but form few days for two dbs which are more than 3gb
the backup is failing .
its showing operating system error 64 & 87
any idea
Regards
ajaySystem error 64 says: "The specified network name is no longer available."
Check if the network share is still available. Maybe somebodey renamed
computer?
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"R. Ajay" <ajudba@.yahoo.co.in> wrote in message
news:#tWkBdzrDHA.1996@.TK2MSFTNGP09.phx.gbl...
> Hi ,
> From last year I have created a backups over network
> but form few days for two dbs which are more than 3gb
> the backup is failing .
> its showing operating system error 64 & 87
> any idea
> Regards
> ajay
>
>|||Hi
Thanks for reply
right now more than 100 dbs are getting backed up on the same server all are
getting success but except two which are of 3 gb size .
Regards
Ajay
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:#4yqZe0rDHA.2148@.TK2MSFTNGP12.phx.gbl...
> System error 64 says: "The specified network name is no longer available."
> Check if the network share is still available. Maybe somebodey renamed
> computer?
> --
> Dejan Sarka, SQL Server MVP
> Please reply only to the newsgroups.
> "R. Ajay" <ajudba@.yahoo.co.in> wrote in message
> news:#tWkBdzrDHA.1996@.TK2MSFTNGP09.phx.gbl...
> > Hi ,
> > From last year I have created a backups over network
> > but form few days for two dbs which are more than 3gb
> > the backup is failing .
> > its showing operating system error 64 & 87
> > any idea
> >
> > Regards
> > ajay
> >
> >
> >
> >
>|||We see those problems all the times posted here. Seems like SQL Server isn't that happy with writing
over the network for larger databases. I guess you could open a case with MS Support, don't know how
much that would help, though. One option can be to backup locally and then copy the file (possibly
packing it first).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"R. Ajay" <ajudba@.yahoo.co.in> wrote in message news:%238QOeG1rDHA.2248@.TK2MSFTNGP09.phx.gbl...
> Hi
> Thanks for reply
> right now more than 100 dbs are getting backed up on the same server all are
> getting success but except two which are of 3 gb size .
> Regards
> Ajay
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:#4yqZe0rDHA.2148@.TK2MSFTNGP12.phx.gbl...
> > System error 64 says: "The specified network name is no longer available."
> > Check if the network share is still available. Maybe somebodey renamed
> > computer?
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Please reply only to the newsgroups.
> >
> > "R. Ajay" <ajudba@.yahoo.co.in> wrote in message
> > news:#tWkBdzrDHA.1996@.TK2MSFTNGP09.phx.gbl...
> > > Hi ,
> > > From last year I have created a backups over network
> > > but form few days for two dbs which are more than 3gb
> > > the backup is failing .
> > > its showing operating system error 64 & 87
> > > any idea
> > >
> > > Regards
> > > ajay
> > >
> > >
> > >
> > >
> >
> >
>|||Hi Tibor,
Every day I am doing backup over network for the database which has a size
of 56 GB. No issues so far.
I feel Ajay's issue was due to some network problems.
Ajay ,
What you can do is from command prompt put a "Ping" to the network server
and see to that always you are getting reply.
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:uL9$tU1rDHA.1784@.TK2MSFTNGP09.phx.gbl...
> We see those problems all the times posted here. Seems like SQL Server
isn't that happy with writing
> over the network for larger databases. I guess you could open a case with
MS Support, don't know how
> much that would help, though. One option can be to backup locally and then
copy the file (possibly
> packing it first).
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "R. Ajay" <ajudba@.yahoo.co.in> wrote in message
news:%238QOeG1rDHA.2248@.TK2MSFTNGP09.phx.gbl...
> > Hi
> > Thanks for reply
> > right now more than 100 dbs are getting backed up on the same server all
are
> > getting success but except two which are of 3 gb size .
> >
> > Regards
> > Ajay
> > "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote
in
> > message news:#4yqZe0rDHA.2148@.TK2MSFTNGP12.phx.gbl...
> > > System error 64 says: "The specified network name is no longer
available."
> > > Check if the network share is still available. Maybe somebodey renamed
> > > computer?
> > >
> > > --
> > > Dejan Sarka, SQL Server MVP
> > > Please reply only to the newsgroups.
> > >
> > > "R. Ajay" <ajudba@.yahoo.co.in> wrote in message
> > > news:#tWkBdzrDHA.1996@.TK2MSFTNGP09.phx.gbl...
> > > > Hi ,
> > > > From last year I have created a backups over network
> > > > but form few days for two dbs which are more than 3gb
> > > > the backup is failing .
> > > > its showing operating system error 64 & 87
> > > > any idea
> > > >
> > > > Regards
> > > > ajay
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I now that it work in some installations, but if you check the newsgroup archive, you will see that
this is a frequent post, and frequently smaller databases are OK - which rules out permissions,
share mappings UNC naming etc.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hari" <hari_prasad_k@.hotmail.com> wrote in message news:%236Dz$W2rDHA.3436@.tk2msftngp13.phx.gbl...
> Hi Tibor,
> Every day I am doing backup over network for the database which has a size
> of 56 GB. No issues so far.
> I feel Ajay's issue was due to some network problems.
> Ajay ,
> What you can do is from command prompt put a "Ping" to the network server
> and see to that always you are getting reply.
>
> Thanks
> Hari
> MCDBA
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:uL9$tU1rDHA.1784@.TK2MSFTNGP09.phx.gbl...
> > We see those problems all the times posted here. Seems like SQL Server
> isn't that happy with writing
> > over the network for larger databases. I guess you could open a case with
> MS Support, don't know how
> > much that would help, though. One option can be to backup locally and then
> copy the file (possibly
> > packing it first).
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "R. Ajay" <ajudba@.yahoo.co.in> wrote in message
> news:%238QOeG1rDHA.2248@.TK2MSFTNGP09.phx.gbl...
> > > Hi
> > > Thanks for reply
> > > right now more than 100 dbs are getting backed up on the same server all
> are
> > > getting success but except two which are of 3 gb size .
> > >
> > > Regards
> > > Ajay
> > > "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote
> in
> > > message news:#4yqZe0rDHA.2148@.TK2MSFTNGP12.phx.gbl...
> > > > System error 64 says: "The specified network name is no longer
> available."
> > > > Check if the network share is still available. Maybe somebodey renamed
> > > > computer?
> > > >
> > > > --
> > > > Dejan Sarka, SQL Server MVP
> > > > Please reply only to the newsgroups.
> > > >
> > > > "R. Ajay" <ajudba@.yahoo.co.in> wrote in message
> > > > news:#tWkBdzrDHA.1996@.TK2MSFTNGP09.phx.gbl...
> > > > > Hi ,
> > > > > From last year I have created a backups over network
> > > > > but form few days for two dbs which are more than 3gb
> > > > > the backup is failing .
> > > > > its showing operating system error 64 & 87
> > > > > any idea
> > > > >
> > > > > Regards
> > > > > ajay
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>