DRAG DROP
You have a database named DB1 that uses the full recover/ model. DB1 uses the following filegroups: FGA, FGB.
You have the following backup sets:
On January 6. 2018, you observe that the data files for DB1 are corrupt. The log file is not affected. You must perform a piecemeal restore to restore FGA as soon as possible. You must minimize the amount of time required to restore the logs.
You need to restore the primary filegroup and FG
A . You observe issues with indexes as well as other minor consistency problems.
You need to identify and repair all physical database problems while minimizing data loss and database downtime.
Which four Transact-SQL statements should you use to develop the solution? To answer, move the appropriate Transact-SQL statements from the list of Transact-SQL statements to the answer area and arrange them in the correct order.
Answer: 
Leave a Reply