BackUp error

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,
CraigThere 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 timeou
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassconnectionstringtopic.asp
Command timeou
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlcommandclasscommandtimeouttopic.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|||Hi
Yes you should be able to backup. General network error may mean that the
client is timing out, therefore you may want to increase the timeout or use a
scheduled task instead.
John
"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|||Hi,
Yes, Backup is an online operation. Database size is not an issue for the
backup. Could you install SP3a or SP 4 (if not AWE enabled)
and try to do a backup again from Server machine Query analyzer (USE the
below command).
Backup database <dbname> to disk='d:\backup\dbname.bak' with init,stats=10
Thanks
Hari
SQL Server MVP
"Craig HB" <CraigHB@.discussions.microsoft.com> wrote in message
news:532C1A36-2C2E-4F06-B0F0-7F2342D144E6@.microsoft.com...
>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