Hello,
SQL Server 2000 sitting on cluster windows2003. Complete backup to local
disk file, file size was about 4G if sometimes it could be finished
successfuly. Most times (80%) it failed.
Successful complete backup running took less than 4 minutes.
If failed, normally stopped at about 23 seconds.
Tansaction log backup is no problem.
job step:
BACKUP DATABASE [dbname] TO DISK = N'E:\Program Files\Microsoft SQL
Server\MSSQL$SQLC02\BACKUP\dbname.bak' WITH INIT , NOUNLOAD , NAME = N'dbname full backup', NOSKIP , STATS = 10, NOFORMAT
manually run the job get this err:
Executed as user: domainname\user1. ConnectionRead (WrapperRead()).
[SQLSTATE 01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) 10 percent backed up. [SQLSTATE
01000] (Error 3211). The step failed.
Database has 1 data file + 1 log file. (I know this is stupid to be having
only one data file, but nothing I can do to it now.)
I really need some directions. This issue is killing me.
Thanks for help!!!!!!!!!!
TomThis is a multi-part message in MIME format.
--010909050504010908020706
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Sorry to ask obvious questions but... How big is your full DB
(sp_helpdb)? About 4GB I assume. How much free disk space do you have
on your E: drive? Does it always fail around the same point (somewhere
between 10% and 20%)? Is E: a local disk, a SAN attached disk or some
network mapped disk?
--
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Tom Runzer wrote:
>Hello,
>SQL Server 2000 sitting on cluster windows2003. Complete backup to local
>disk file, file size was about 4G if sometimes it could be finished
>successfuly. Most times (80%) it failed.
>Successful complete backup running took less than 4 minutes.
>If failed, normally stopped at about 23 seconds.
>Tansaction log backup is no problem.
>job step:
>BACKUP DATABASE [dbname] TO DISK = N'E:\Program Files\Microsoft SQL
>Server\MSSQL$SQLC02\BACKUP\dbname.bak' WITH INIT , NOUNLOAD , NAME =>N'dbname full backup', NOSKIP , STATS = 10, NOFORMAT
>manually run the job get this err:
>Executed as user: domainname\user1. ConnectionRead (WrapperRead()).
>[SQLSTATE 01000] (Message 258) General network error. Check your network
>documentation. [SQLSTATE 08S01] (Error 11) 10 percent backed up. [SQLSTATE
>01000] (Error 3211). The step failed.
>Database has 1 data file + 1 log file. (I know this is stupid to be having
>only one data file, but nothing I can do to it now.)
>I really need some directions. This issue is killing me.
>Thanks for help!!!!!!!!!!
>Tom
>
--010909050504010908020706
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Sorry to ask obvious questions but... How big is your full DB
(sp_helpdb)? About 4GB I assume. How much free disk space do you have
on your E: drive? Does it always fail around the same point (somewhere
between 10% and 20%)? Is E: a local disk, a SAN attached disk or some
network mapped disk?</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2">blog:</font><font face="Tahoma" size="2"> <a
href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Tom Runzer wrote:
<blockquote cite="mid43F74958-2081-4A5C-B5F3-55ECDFD62FB8@.microsoft.com"
type="cite">
<pre wrap="">Hello,
SQL Server 2000 sitting on cluster windows2003. Complete backup to local
disk file, file size was about 4G if sometimes it could be finished
successfuly. Most times (80%) it failed.
Successful complete backup running took less than 4 minutes.
If failed, normally stopped at about 23 seconds.
Tansaction log backup is no problem.
job step:
BACKUP DATABASE [dbname] TO DISK = N'E:\Program Files\Microsoft SQL
Server\MSSQL$SQLC02\BACKUP\dbname.bak' WITH INIT , NOUNLOAD , NAME =N'dbname full backup', NOSKIP , STATS = 10, NOFORMAT
manually run the job get this err:
Executed as user: domainname\user1. ConnectionRead (WrapperRead()).
[SQLSTATE 01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) 10 percent backed up. [SQLSTATE
01000] (Error 3211). The step failed.
Database has 1 data file + 1 log file. (I know this is stupid to be having
only one data file, but nothing I can do to it now.)
I really need some directions. This issue is killing me.
Thanks for help!!!!!!!!!!
Tom
</pre>
</blockquote>
</body>
</html>
--010909050504010908020706--|||How big is your full DB (sp_helpdb)? About 4GB I assume.
4471 MB
How much free disk space do you have on your E: drive?
55 GB free, also host data file and log file.
Does it always fail around the same point (somewhere > between 10% and 20%)?
yes, after 22 sec, but I couldn't see the percentage, but should be
within 10%
Is E: a local disk, a SAN attached disk or some network mapped disk?
local disk.
Thanks for help!!!!!
"Mike Hodgson" wrote:
> Sorry to ask obvious questions but... How big is your full DB
> (sp_helpdb)? About 4GB I assume. How much free disk space do you have
> on your E: drive? Does it always fail around the same point (somewhere
> between 10% and 20%)? Is E: a local disk, a SAN attached disk or some
> network mapped disk?
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> Tom Runzer wrote:
> >Hello,
> >
> >SQL Server 2000 sitting on cluster windows2003. Complete backup to local
> >disk file, file size was about 4G if sometimes it could be finished
> >successfuly. Most times (80%) it failed.
> >
> >Successful complete backup running took less than 4 minutes.
> >If failed, normally stopped at about 23 seconds.
> >Tansaction log backup is no problem.
> >
> >job step:
> >BACKUP DATABASE [dbname] TO DISK = N'E:\Program Files\Microsoft SQL
> >Server\MSSQL$SQLC02\BACKUP\dbname.bak' WITH INIT , NOUNLOAD , NAME => >N'dbname full backup', NOSKIP , STATS = 10, NOFORMAT
> >
> >manually run the job get this err:
> >Executed as user: domainname\user1. ConnectionRead (WrapperRead()).
> >[SQLSTATE 01000] (Message 258) General network error. Check your network
> >documentation. [SQLSTATE 08S01] (Error 11) 10 percent backed up. [SQLSTATE
> >01000] (Error 3211). The step failed.
> >
> >Database has 1 data file + 1 log file. (I know this is stupid to be having
> >only one data file, but nothing I can do to it now.)
> >
> >I really need some directions. This issue is killing me.
> >
> >Thanks for help!!!!!!!!!!
> >
> >Tom
> >
> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment