Which actions should you perform to initialize the secondary database from the primary database?
You are the database administrator for your company. You are maintaining the SQL Server instance named Sql1 on the Sqlserver1 server.
The Sql1 instance stores the Prod1 database. The Prod1 database is configured touse the full recovery model.
You are required to configure a secondary database for Prod1 to provide high availability of the database.
You are required to initialize the secondary database from a full database backup of the Prod1 database and restorethe logs from the online primary server to the secondary server.
You do not want to bring the secondary databaseonline immediately.
Which actions should you perform to initialize the secondary database from the primary database? (Choose two.Each correct answer represents part of the solution.)
What should you do?
You are the SQL administrator for your company. A SQL Server 2008 instance named SQL_Prod containsseveral databases your company uses on a daily basis.
You decide to create a maintenance plan to meet the following objectives:
? The database structure of all databases and indexes on SQL_Prod must be verified.
? All user databases must be backed up before the structure of the databases is verified.
? You must be notified when the maintenance plan has completed.
What should you do?
What should you do?
You are the database administrator for your company. You are managing the SQL Server database named Sql_prod1 located on your company’s server.
You adhere to the following backup strategy for the Sql_prod1 database:
? a transaction log backup at noon
? a snapshot of the database at 3:00 P.M.
? a complete backup of the database at 8:00 A.M.
? a differential backup of the database at noon and at 5:00 P.M.
Between 3:00 PM and 3:14 PM there are no changes made. At 3:15 P.M., a programmer issues the followingstatement:
DELETE FROM emp WHERE department_id = 40;
After this statement is issued and the changes have been committed, all the data for the employees in departmentID 40 is lost.
You want to recover the lost data using the least administrative effort. What should you do?
What should you do first?
You are the database administrator of your company. Your server named Server1 contains an instance of SQLServer 2008 named SQL1.
Server1 contains two hard disks named Disk1 and Disk2 . A database named Corpdb contains sensitive information and is stored on Disk1.
The transaction log for Corpdb is stored on Disk2 .Your company policy states that data loss must never exceed one hour’s worth of data.
You configure a full backup to be performed on SQL1 every Sunday at 1:00 A.M.
You configure a differentialbackup to be performed daily on SQL1 at 4:00 A.M.
You also configure the transaction log to be backed up everyhour. The database becomes corrupt on Wednesday at 3:20 P.M.
You want to restore the database to the point offailure. What should you do first?
Which arguments should you use?
You are your company’s SQL administrator. A SQL Server 2008 instance named SQL1 contains severaldatabases, including a database named Products.
Several users are experiencing problems with the Product_details table of the Products database. The Product_details table is very large.
You decide to check the integrity of the table using a DBCC CHECKTABLE statement. The statement youexecute must meet the following goals:
? The run time for the statement must be minimized.
? Other users should only be able to read the table’s data during the statement’s execution.
Which arguments should you use? (Choose all that apply.)
Which restoration method will you use to recover the dropped table to the most recent point in time?
You are the database administrator for your company. You manage the production database named Prod . The database is configured to use the Simple Recovery model. You perform a full backup of the database at 1:00 A.M.and 1:00 P.M. daily. A differential backup is performed every two hours beginning at midnight.
A user in the database drops the table at 11:30 A.M.
Which restoration method will you use to recover the dropped table to the most recent point in time?
Which permission do you require to perform this task?
You manage an instance of SQL Server 2008 that contains five databases. You perform database snapshots forall five databases on a daily basis.
A user reports that he accidentally deleted a table from the Mktgdb database.
You verify that a snapshot named Mktgdbsnapshot contains the deleted table. You want to revert the Mktgdb database to the Mktgdbsnapshot snapshot.
Which permission do you require to perform this task?
Which method should you use to perform the tasks by using the least administrative effort?
You are a database administrator for Verigon Corporation. You maintain all the SQL Server 2008 databases forthe company. The company receives data regarding the processed orders from the various branches of thecompany. After the data is verified by the audit department, the appropriate tables in the database are updatedwith the data by 6 A.M. You are required to perform the following tasks after the tables have been updated:
? Rebuild the indexes in the tables at 8:00 A.M.
? Update the statistics for the tables and indexes in the database at 10:00 P.M.
? Perform a differential backup of the database at 7:00 P.M.
Which method should you use to perform the tasks by using the least administrative effort?
Which Transact-SQL statement should you run?
You are the database administrator of your company. The network contains five instances of SQL Server 2008.
An instance named SQL1 contains a database named Salesdb that is used by users in the sales department.
Some users report that when they query the Salesdb database, they receive out-of-range values from severaltables.
You want to identify out-of-range values for columns in all the tables in the Salesdb database.
Which Transact-SQL statement should you run?
Which type of backup should you create?
You are the database administrator of your company. The network contains an instance of SQL Server 2008. Youare implementing a backup strategy for a database named Empdb stored on the SQL server. You want to be ableto instantly create a copy of the Empdb database to create reports.
Which type of backup should you create?