Help: Backup Question

Dear All,
Does anyone can help me up to answer the question below:
=============
You are the administrator of a SQL Server 2000 computer The server
contains a database named Sales that has two data files and one
transaction log file. Each data file is located on its own hard disk and
exists in its own filegroup. You perform full database, differential,
and transaction log backups on a regular basis. All backups made during
a single week are striped across three disk backup devices. A portion of
the header information for the current week's backups is shown in the
following table
BackupName BackupType BackupFinishDate
Sales_db_20000625 1 2000-06-25 21 57 04.000
Sales_tl_20000626_1 2 2000-06-26 11 04 22.000
Sales_tl_20000626_2 2 2000-06-26 15 06 33.000
Sales_df_20000626 5 2000-06-26 21 15 48.000
Sales_tl_20000627_1 2 2000-06-27 11 03 39.000
Sales_tl_20000627_2 2 2000-06-27 15 04 59.000
Sales_df_20000627 5 2000-06-27 21 31 13.000
Sales_tl_20000628_1 2 2000-06-28 11 05 16.000
On June 28, 2000, at 1:47 P M , the hard disk that contains the PRIMARY
filegroup fails. You want to recover as much data as possible. What
should you do? (Each correct answer presents part of the solution,
Choose all that apply)
A. Backup the transaction log by using the NO_LOG option
B. Backup the transaction log by using the NO_TRUNCATE option
C. Restore the most recent full database backup
D. Restore the most recent differential backup
E. Restore all differential backups in sequence
F. Restore all transaction log backups in sequence
G. Restore all transaction logs since the most recent differential backup
===================
Thanks
Robert Lie
Robert,
I will say:
B, C, D, G (with no recovery) and then restore the backup done in option B
with RECOVERY.
AMB
"Robert Lie" wrote:

> Dear All,
> Does anyone can help me up to answer the question below:
>
> =============
> You are the administrator of a SQL Server 2000 computer The server
> contains a database named Sales that has two data files and one
> transaction log file. Each data file is located on its own hard disk and
> exists in its own filegroup. You perform full database, differential,
> and transaction log backups on a regular basis. All backups made during
> a single week are striped across three disk backup devices. A portion of
> the header information for the current week's backups is shown in the
> following table
> BackupName BackupType BackupFinishDate
> Sales_db_20000625 1 2000-06-25 21 57 04.000
> Sales_tl_20000626_1 2 2000-06-26 11 04 22.000
> Sales_tl_20000626_2 2 2000-06-26 15 06 33.000
> Sales_df_20000626 5 2000-06-26 21 15 48.000
> Sales_tl_20000627_1 2 2000-06-27 11 03 39.000
> Sales_tl_20000627_2 2 2000-06-27 15 04 59.000
> Sales_df_20000627 5 2000-06-27 21 31 13.000
> Sales_tl_20000628_1 2 2000-06-28 11 05 16.000
>
> On June 28, 2000, at 1:47 P M , the hard disk that contains the PRIMARY
> filegroup fails. You want to recover as much data as possible. What
> should you do? (Each correct answer presents part of the solution,
> Choose all that apply)
> A. Backup the transaction log by using the NO_LOG option
> B. Backup the transaction log by using the NO_TRUNCATE option
> C. Restore the most recent full database backup
> D. Restore the most recent differential backup
> E. Restore all differential backups in sequence
> F. Restore all transaction log backups in sequence
> G. Restore all transaction logs since the most recent differential backup
> ===================
>
> Thanks
> Robert Lie
>
|||Dear Alejandro Mesa,
Can you explain to me what's the meaning of number at the "Backup Type"
column?
Thanks
Robert Lie
Alejandro Mesa wrote:[vbcol=seagreen]
> Robert,
> I will say:
> B, C, D, G (with no recovery) and then restore the backup done in option B
> with RECOVERY.
>
> AMB
> "Robert Lie" wrote:
>
|||Hi,
Backup types: -
1 = Database
2 = Transaction Log
4 = File
5 = Differential Database
6 = Differential File
Thanks
Hari
SQL Server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:eu3vQsfYFHA.4036@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Dear Alejandro Mesa,
> Can you explain to me what's the meaning of number at the "Backup Type"
> column?
> Thanks
> Robert Lie
> Alejandro Mesa wrote:
|||I guess it is:
1 - db backup
2 - transaction log backup
5 - db differential backup.
Example:
use northwind
go
alter database northwind set recovery bulk_logged
go
backup database northwind to disk = 'c:\temp\nw.bak'
go
backup database northwind to disk = 'c:\temp\nw_diff.bak' with differential
go
backup log northwind to disk = 'c:\temp\nw_log.bak'
go
restore HEADERONLY from disk = 'c:\temp\nw.bak'
go
restore HEADERONLY from disk = 'c:\temp\nw_diff.bak'
go
restore HEADERONLY from disk = 'c:\temp\nw_log.bak'
go
alter database northwind set recovery simple
go
exec master..xp_cmdshell 'del c:\temp\nw*.bak'
go
AMB
"Robert Lie" wrote:

> Dear Alejandro Mesa,
> Can you explain to me what's the meaning of number at the "Backup Type"
> column?
> Thanks
> Robert Lie
> Alejandro Mesa wrote:
>
|||Instead of keep asking all the questions from the tests, it might be better
if you start reading some litterature about MS SQL Server. A good and easy
place to start, would be to read Books On Line - that's a great ressource to
start with....
Regards
Steen
Robert Lie wrote:[vbcol=seagreen]
> Dear Alejandro Mesa,
> Can you explain to me what's the meaning of number at the "Backup
> Type" column?
> Thanks
> Robert Lie
> Alejandro Mesa wrote: