This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C4F4CF.7941A2AE
Content-Type: text/plain
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 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.
------_=_NextPart_001_01C4F4CF.7941A2AE
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-asci=
i">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 5.5.2657.7=
3">
<TITLE>SQL Restore issue...</TITLE>
</HEAD>
<BODY>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">Hi Gang,<=
/FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial"> Ho=
pe the new year is finding everyone happy and healthy. Well I have =
an issue with trying to restore an SQL database. </FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">Backgroun=
d:</FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">Master: W=
in2k SP4, NBU 4.5_FP6</FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">Media: Wi=
n2k SP4, NBU 4.5_FP6</FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">Client: W=
in2k SP4, SQL2000 SP3, NBU 4.5_FP6 (SQL Agent ONLY is used on this machin=
e)</FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">A large d=
atabase didn</FONT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">'</FON=
T><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">t come back online afte=
r a reboot. The system marked it as Suspect and indicated one of the file=
s was in use by something else. Several things were tried. Th=
e database files were moved off the server. Restores via the SQL ag=
ent failed with a code 5. Turned out the database had been in a com=
pressed folder and uncompressed was too large for the drive. Lots o=
f tinkering and working later there is now room on the drive for the data=
base.</FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">Without c=
reating the database we tried a restore. It created the database an=
d creates the 60 some odd gig worth of files but does not restore the dat=
a. We keep getting a failure of</FONT> <FONT COLOR=3D"#000080" SIZE=
=3D2 FACE=3D"Arial">Connection timed out.</FONT></P>
<P ALIGN=3DLEFT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">I have no=
t used the SQL restore much</FONT> <FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D=
"Arial">so I don</FONT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">'<=
/FONT><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Arial">t really know what =
to be doing here. Do we need to follow the DR restore instructions?=
Thanks</FONT></P>
</BODY>
</HTML>
<BR>
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,=20
is for the sole use of the intended recipient(s) and may contain confiden=
tial
and privileged information or otherwise be protected by law. Any unautho=
rized
review, use, disclosure or distribution is prohibited. If you are not th=
e
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.
------_=_NextPart_001_01C4F4CF.7941A2AE--
|
