Dear Sir,
I use SQL 2000 server. I want to load all the table content to the
memory the SQL server startup.
How can I do that?
My computer has 2 G RAM. The total space of the databse is 1G.
I have set the mininum memory is 1G (in dynamic configue SQL memory) in SQL
server and check the "Reserved physical memory for SQL server". But no all
data load into the memory during SQL server startup.
I just know that if I write a SQL statement to request records, these
records will be load into memory.
SO, I think it is not a good method to select all tables once after the SQL
server just startup.
Thank you for your help!
--
Regards,
Anthony LamAssuming you really want to do this, create a stored procedure which reads the rows and mark it as a
startup proc (sp_procoption).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"AA" <anthony@.jadeflex.com> wrote in message news:%23ARNLe$gDHA.3272@.tk2msftngp13.phx.gbl...
> Dear Sir,
> I use SQL 2000 server. I want to load all the table content to the
> memory the SQL server startup.
> How can I do that?
> My computer has 2 G RAM. The total space of the databse is 1G.
> I have set the mininum memory is 1G (in dynamic configue SQL memory) in SQL
> server and check the "Reserved physical memory for SQL server". But no all
> data load into the memory during SQL server startup.
> I just know that if I write a SQL statement to request records, these
> records will be load into memory.
> SO, I think it is not a good method to select all tables once after the SQL
> server just startup.
> Thank you for your help!
> --
> Regards,
> Anthony Lam
>
Showing posts with label computer. Show all posts
Showing posts with label computer. Show all posts
Sunday, February 19, 2012
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:
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:
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 LieRobert,
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:
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 LieRobert,
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:
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 LieRobert,
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:
> 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|||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:
> > 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
> >>
>|||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...
> 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:
>> 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|||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:
> 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:
>> 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
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 LieRobert,
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:
> 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|||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:
> > 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
> >>
>|||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...
> 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:
>> 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|||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:
> 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:
>> 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
Subscribe to:
Posts (Atom)