| Author |
Help (different answers)
|
|
| Stacie 2003-05-26, 5:23 pm |
| The 3 ?'s are what I don't know which one to do. One
study guide says to use the new location and Import the
data - the other study guide said to the existing database
and doesnot mention importing the data.
Here's the question and the answer(s) w/? marks are below:
Qu is: you are administrator of SQL server 2000 and it
has a database that tracks requests for product
information. The database has 2 filegroups. The primary
filegroup stores current transactional data, and the
secondary filegroup stores historical data. Your backup
strategy includes full database and transactional log
backups. On June 27 at 4:18 someone deleted the current
version and immediately notified you. You need to recover
as much data as quickly as possible to minimize downtime.
Answer: You would do the below:
Back up the transaction log
Restore the primary filegroup to ?new or ?existing
database? (which one??)
Restore the subsequent transaction logs in sequence
Use the stopat option to restore the final transaction log
backup
?Import the deleted data from the new location. (Do you do
this?)
| |
| Andy Foster 2003-05-27, 5:23 am |
| "Stacie" <stacie.cato@peedee.ncemcs.com> wrote in message news:< 288701c323cd$529c03d0$a601280a
@phx.gbl>...
> The 3 ?'s are what I don't know which one to do. One
> study guide says to use the new location and Import the
> data - the other study guide said to the existing database
> and doesnot mention importing the data.
>
> Here's the question and the answer(s) w/? marks are below:
>
> Qu is: you are administrator of SQL server 2000 and it
> has a database that tracks requests for product
> information. The database has 2 filegroups. The primary
> filegroup stores current transactional data, and the
> secondary filegroup stores historical data. Your backup
> strategy includes full database and transactional log
> backups. On June 27 at 4:18 someone deleted the current
> version and immediately notified you. You need to recover
> as much data as quickly as possible to minimize downtime.
>
> Answer: You would do the below:
> Back up the transaction log
> Restore the primary filegroup to ?new or ?existing
> database? (which one??)
> Restore the subsequent transaction logs in sequence
> Use the stopat option to restore the final transaction log
> backup
> ?Import the deleted data from the new location. (Do you do
> this?)
Looks like GI Joe has missed this one. Never mind I'm sure you can
figure out what his reply would have been
| |
| S. O'Brien 2003-05-27, 10:23 am |
| me thinks she needs to learn how to do research instead of asking for
answers... she hasnt got one yet... annoyingly keeps asking though. But
then, as you mentioned repeatedly, using braindumps are not the answer
either.
sue
"Andy Foster" <andyn05p4m@hotmail.com> wrote in message
news:9f341f2f.0305270130.6dad8776@posting.google.com...
> "Stacie" <stacie.cato@peedee.ncemcs.com> wrote in message
news:< 288701c323cd$529c03d0$a601280a
@phx.gbl>...
> > The 3 ?'s are what I don't know which one to do. One
> > study guide says to use the new location and Import the
> > data - the other study guide said to the existing database
> > and doesnot mention importing the data.
> >
> > Here's the question and the answer(s) w/? marks are below:
> >
> > Qu is: you are administrator of SQL server 2000 and it
> > has a database that tracks requests for product
> > information. The database has 2 filegroups. The primary
> > filegroup stores current transactional data, and the
> > secondary filegroup stores historical data. Your backup
> > strategy includes full database and transactional log
> > backups. On June 27 at 4:18 someone deleted the current
> > version and immediately notified you. You need to recover
> > as much data as quickly as possible to minimize downtime.
> >
> > Answer: You would do the below:
> > Back up the transaction log
> > Restore the primary filegroup to ?new or ?existing
> > database? (which one??)
> > Restore the subsequent transaction logs in sequence
> > Use the stopat option to restore the final transaction log
> > backup
> > ?Import the deleted data from the new location. (Do you do
> > this?)
>
> Looks like GI Joe has missed this one. Never mind I'm sure you can
> figure out what his reply would have been
| |
| Gary - US 2003-05-27, 10:23 pm |
| GI Joe? You talking to me numbnuts?
--
Semper Fi & God Bless America,
Gary - US MCNGP #20
http://www.mcngp.tk
The MCNGP Team - We're here to help
"Andy Foster" <andyn05p4m@hotmail.com> wrote in message
news:9f341f2f.0305270130.6dad8776@posting.google.com...
> "Stacie" <stacie.cato@peedee.ncemcs.com> wrote in message
news:< 288701c323cd$529c03d0$a601280a
@phx.gbl>...
> > The 3 ?'s are what I don't know which one to do. One
> > study guide says to use the new location and Import the
> > data - the other study guide said to the existing database
> > and doesnot mention importing the data.
> >
> > Here's the question and the answer(s) w/? marks are below:
> >
> > Qu is: you are administrator of SQL server 2000 and it
> > has a database that tracks requests for product
> > information. The database has 2 filegroups. The primary
> > filegroup stores current transactional data, and the
> > secondary filegroup stores historical data. Your backup
> > strategy includes full database and transactional log
> > backups. On June 27 at 4:18 someone deleted the current
> > version and immediately notified you. You need to recover
> > as much data as quickly as possible to minimize downtime.
> >
> > Answer: You would do the below:
> > Back up the transaction log
> > Restore the primary filegroup to ?new or ?existing
> > database? (which one??)
> > Restore the subsequent transaction logs in sequence
> > Use the stopat option to restore the final transaction log
> > backup
> > ?Import the deleted data from the new location. (Do you do
> > this?)
>
> Looks like GI Joe has missed this one. Never mind I'm sure you can
> figure out what his reply would have been
|
|
|
|