[Veritas-bu] SQL Differential Backups
2002-09-06 09:22:42
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_01C255A8.7B1E5F90
Content-Type: text/plain
You have to perform the differential restore from Query Analyzer since
Enterprise Manager doesn't support differentials. Look up restore
(described) in books online for more info. Make sure you use the norecovery
option until the last transaction log restore. For example:
use master
go
restore database briandb from disk = 'c:\temp\briandb_full.bak' with
norecovery
go
restore database briandb from disk = 'c:\temp\briandb_diff.bak' with
norecovery -- SQL will know that this is a differential backup
go
restore log briandb from disk = 'c:\temp\briandb_log.trn' with recovery
go
Good luck,
Matt
-----Original Message-----
From: Hall, Brian [mailto:hallb2 AT educationcentral DOT org]
Sent: Friday, September 06, 2002 9:02 AM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: [Veritas-bu] SQL Differential Backups
Hello All,
I am trying to restore a SQL database that had 1 SQL database backup, 1 SQL
differential, and 1 Transaction Log. When I go into the SQL GUI on my
Windows NT4 Machine to initiate the restore, all I see is the Full Database
backup and the Transaction Log. I do not see the differential. Does anyone
know why?
Thanks for any help given!
Brian Hall
------_=_NextPart_001_01C255A8.7B1E5F90
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2719.2200" name=GENERATOR>
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY:
"Times New Roman"
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2>You have to perform the differential <SPAN
class=967141413-06092002>restore </SPAN>from Query Analyzer<SPAN
class=967141413-06092002> since </SPAN>Enterprise Manager doesn't support
differential<SPAN class=967141413-06092002>s</SPAN>.<SPAN
class=967141413-06092002> Look up restore (described) in books online for
more info. Make sure you use the norecovery option until the last
transaction log restore. For
example:</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=967141413-06092002></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=967141413-06092002>use
master</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=967141413-06092002>go</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=967141413-06092002>restore database briandb from disk =
'c:\temp\briandb_full.bak' with
norecovery</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=967141413-06092002>go</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=967141413-06092002>restore database briandb from disk =
'c:\temp\briandb_diff.bak' with norecovery -- SQL will know that this is
a
differential backup</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=967141413-06092002>go</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=967141413-06092002>restore log briandb from disk =
'c:\temp\briandb_log.trn' with recovery</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=967141413-06092002>go</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=967141413-06092002></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=967141413-06092002>Good
luck,</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=967141413-06092002>Matt</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=796311313-06092002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hall, Brian
[mailto:hallb2 AT educationcentral DOT org] <BR><B>Sent:</B> Friday, September
06, 2002
9:02 AM<BR><B>To:</B> 'veritas-bu AT mailman.eng.auburn DOT
edu'<BR><B>Subject:</B>
[Veritas-bu] SQL Differential Backups<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hello All,</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am trying to restore a SQL
database that had 1 SQL database backup, 1 SQL differential, and 1 Transaction
Log. When I go into the SQL GUI on my Windows NT4 Machine to initiate the
restore, all I see is the Full Database backup and the Transaction Log. I
do not see the differential. Does anyone know why?</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks for any help
given!</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=green size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: Arial">Brian
Hall</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></BODY></HTML>
------_=_NextPart_001_01C255A8.7B1E5F90--
|
|
|