Welcome to Sign in | Help

Re: intrebari/raspunsuri de pe la interviuri

  •  05-25-2007, 11:05 AM

    Re: intrebari/raspunsuri de pe la interviuri

    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.

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems