Veritas-bu

[Veritas-bu] SQL Restore issue...

2005-01-07 14:44:40
Subject: [Veritas-bu] SQL Restore issue...
From: ida3248b AT post.cybercity DOT dk (ida3248b AT post.cybercity DOT dk)
Date: Fri, 7 Jan 2005 20:44:40 +0100
This is a multi-part message in MIME format.

------=OPENWEBMAIL_ATT_0.453697467561668
Content-Type: text/plain;
        charset=iso-8859-1

Hi Marx

We found that you need to create the DWORD registry values CLIENT_READ_TIMEOUT 
and CLIENT_CONNECT_TIMEOUT on client, media and master server.

 These values is in seconds, so I would suggest to start with at least 7200 (2 
hours).

You need to restart the Netbackup Client Service, after changing the values.

Regards

Michael

On Fri, 7 Jan 2005 10:42:20 -0500, Marx, Keath wrote
> Hi Gang,
>   Hope the new year is finding everyone happy and healthy.  Well I have an 
> issue with trying to restore an SQL database.  
> Background:
> Master: Win2k SP4, NBU 4.5_FP6
> Media: Win2k SP4, NBU 4.5_FP6
> Client: Win2k SP4, SQL2000 SP3, NBU 4.5_FP6 (SQL Agent ONLY is used on this 
> machine)
> A large database didn't come back online after a reboot. The system marked it 
> as Suspect and indicated one of the files was in use by something else.  
> Several things were tried.  The database files were moved off the server.  
> Restores via the SQL agent failed with a code 5.  Turned out the database had 
> been in a compressed folder and uncompressed was too large for the drive.  
> Lots of tinkering and working later there is now room on the drive for the 
> database.
> Without creating the database we tried a restore.  It created the database 
> and creates the 60 some odd gig worth of files but does not restore the 
> data.  We keep getting a failure of Connection timed out.
> I have not used the SQL restore much so I don't really know what to be doing 
> here.  Do we need to follow the DR restore instructions?  Thanks
> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is 
> for the sole use of the intended recipient(s) and may contain confidential 
> and privileged information or otherwise be protected by law. Any unauthorized 
> review, use, disclosure or distribution is prohibited. If you are not the 
> intended recipient, please contact the sender by reply e-mail and destroy all 
> copies of the original message.

--
Cybercity Webhosting (http://www.cybercity.dk)



------=OPENWEBMAIL_ATT_0.453697467561668
Content-Type: text/html;
        charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<HTML>
<HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"Cybercity Webmail 2.21 20031110" name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>

<p><font face=3D"Arial" color=3D"#000080" size=3D"2">Hi Marx</font></p>

<p><font face=3D"Arial" color=3D"#000080" size=3D"2">We found that you need=
 to create the DWORD registry values CLIENT_READ_TIMEOUT and CLIENT_CONNECT=
_TIMEOUT on=A0client, media and=A0master server.</font></p>

<p><font face=3D"Arial" color=3D"#000080" size=3D"2">=A0These values is in =
seconds, so I would suggest to start with at least 7200 (2 hours).</font></=
p>

<p><font face=3D"Arial" color=3D"#000080" size=3D"2">You=A0need to restart =
the Netbackup Client Service, after changing the values.</font></p>

<p><font face=3D"Arial" color=3D"#000080" size=3D"2">Regards</font></p>

<p><font face=3D"Arial" color=3D"#000080" size=3D"2">Michael</font></p>

<p><font size=3D"2"><b>On Fri, 7 Jan 2005 10:42:20 -0500, Marx, Keath wrote=
</b>
<br />&gt; <font face=3D"Arial" color=3D"#000080" size=3D"2">Hi Gang,</font=
>=20
<br />&gt; <font face=3D"Arial" color=3D"#000080" size=3D"2">=A0 Hope the n=
ew year is finding everyone happy and healthy.=A0 Well I have an issue with=
 trying to restore an SQL database.=A0 </font>
<br />&gt; <font face=3D"Arial" color=3D"#000080" size=3D"2">Background:</f=
ont>=20
<br />&gt; <font face=3D"Arial" color=3D"#000080" size=3D"2">Master: Win2k =
SP4, NBU 4.5_FP6</font>=20
<br />&gt; <font face=3D"Arial" color=3D"#000080" size=3D"2">Media: Win2k S=
P4, NBU 4.5_FP6</font>=20
<br />&gt; <font face=3D"Arial" color=3D"#000080" size=3D"2">Client: Win2k =
SP4, SQL2000 SP3, NBU 4.5_FP6 (SQL Agent ONLY is used on this machine)</fon=
t>=20
<br />&gt; <font face=3D"Arial" color=3D"#000080" size=3D"2">A large databa=
se didn</font><font face=3D"Arial" color=3D"#000080" size=3D"2">'</font><fo=
nt face=3D"Arial" color=3D"#000080" size=3D"2">t come back online after a r=
eboot. The system marked it as Suspect and indicated one of the files was i=
n use by something else.=A0 Several things were tried.=A0 The database file=
s were moved off the server.=A0 Restores via the SQL agent failed with a co=
de 5.=A0 Turned out the database had been in a compressed folder and uncomp=
ressed was too large for the drive.=A0 Lots of tinkering and working later =
there is now room on the drive for the database.</font>=20
<br />&gt; <font face=3D"Arial" color=3D"#000080" size=3D"2">Without creati=
ng the database we tried a restore.=A0 It created the database and creates =
the 60 some odd gig worth of files but does not restore the data.=A0 We kee=
p getting a failure of</font> <font face=3D"Arial" color=3D"#000080" size=
=3D"2">Connection timed out.</font>=20
<br />&gt; <font face=3D"Arial" color=3D"#000080" size=3D"2">I have not use=
d the SQL restore much</font> <font face=3D"Arial" color=3D"#000080" size=
=3D"2">so I don</font><font face=3D"Arial" color=3D"#000080" size=3D"2">'</=
font><font face=3D"Arial" color=3D"#000080" size=3D"2">t really know what t=
o be doing here.=A0 Do we need to follow the DR restore instructions?=A0 Th=
anks</font>=20
<br />&gt; CONFIDENTIALITY NOTICE: This e-mail message, including any attac=
hments, is for the sole use of the intended recipient(s) and may contain co=
nfidential and privileged information or otherwise be protected by law. Any=
 unauthorized review, use, disclosure or distribution is prohibited. If you=
 are not the intended recipient, please contact the sender by reply e-mail =
and destroy all copies of the original message.=20
<br />
<br />
<br />--=20
<br />Cybercity Webhosting (<a href=3D"http://www.cybercity.dk/"; target=3D"=
_blank">http://www.cybercity.dk</a>)=20
<br />
<br /></font></p>

</BODY>
</HTML>


------=OPENWEBMAIL_ATT_0.453697467561668--

<Prev in Thread] Current Thread [Next in Thread>