You need to recover the corrupted data in the minimum amount of time

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size.
The Sales database is configured as shown in the following table.

You discover that all files except Sales_2.ndf are corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size.
The Sales database is configured as shown in the following table.

You discover that all files except Sales_2.ndf are corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?

A.
Perform a file restore.

B.
Perform a transaction log restore.

C.
Perform a restore from a full backup.

D.
Perform a filegroup restore.

Explanation:
http://technet.microsoft.com/en-us/library/ms187048.aspx
http://msdn.microsoft.com/en-us/library/aa337540.aspx
Under the simple recovery model, the file must belong to a read-only filegroup.
Under the full or bulk-logged recovery model, before you can restore files, you must back up the
active transaction log (known as the tail of the log). For more information, see Back Up a Transaction
Log (SQL Server).
To restore a database that is encrypted, you must have access to the certificate or asymmetric key
that was used to encrypt the database. Without the certificate or asymmetric key, the database
cannot be restored. As a result, the certificate that is used to encrypt the database encryption key
must be retained as long as the backup is needed. For more information, see SQL Server Certificates
and Asymmetric Keys.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Lil

Lil

You discover that all files except Sales_2.ndf are corrupt.
You need to recover the corrupted data in the minimum amount of time.

Isn’t it easier to restore the full backup instead?

DEREJE

DEREJE

I would say do restore from full backup. because all files are not good except one file. If it was only one file corrupt we can do file restore but in this case file restore is too much work

Kevin Burgess

Kevin Burgess

I agree. The minimum amount of time to perform a restore is the time taken to restore a single backup and not several….

KRanseyer

KRanseyer

Usually MS gives us any information we need to choose the right answer. The question does not tell us anything about the existence of a full backup, so we have to presume we don’t have one.

Karl Ranseyer

Karl Ranseyer

Had this question in exam today. It said that ONLY sales_2.ndf is corrupt, so file restore should be correct.

CJ

CJ

With the DB being 3 TB in size, Sales2 may be 500GB all by itself. Feels like it might be quicker if we could skip that one, even if it is a bit admin intensive. So file?

Txiki

Txiki

At this point i thought that correct answer was FULL BACKUP, but when a read to CJ… I changed. Maybe the correct file is 500Gb or 1Tb … so the file backup is easier….

The key of the correct answer is that the DB is 3Tb.