题目

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. At present about 90 GB of data is stored in DB1. You made some rough calculations that every day about 1 GB of data is modified or inserted. You set the recovery model of DB1 to Simple. According to the company requirements, during business hours, data loss of more than 120 minutes worth of transactions is unacceptable. You have to choose a backup strategy which must comply with the following two requirements: Using as little disk space as possible Complying with the company requirements. So what action should you perform to achieve this goal?()  

A、A full database backup should be performed once daily. During business hour, a transaction log backup should be performed every two hours. 

B、A full database backup should be performed once daily 

C、A full database backup should be performed once daily. During business hours, a differential backup should be performed every two hours 

D、Perform a full database backup should be performed once every week. A differential backup should be performed once daily. During business hours a transaction log backup should be performed every two hours.

答案
查看答案
相关试题

川贝母与浙贝母均具有的功效是()

A、清肺养阴止咳

B、温肺化痰止咳

C、泻肺化痰止咳

D、燥湿化痰止咳

E、清热化痰止咳

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1, and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you.  So what action should you perform to achieve this goal?()  

A、All the SQL Server logins of the application developers have to be added to a fixed server role. 

B、All the database users of the application developers have to be added to a fixed database role 

C、All SQL Server logins of the application developers should be given the appropriate server-level permissions. 

D、All database users of the application developers should be given the appropriate database-level permissions. 

能润肠通便的药物是()

A、杏仁、苏子

B、桃仁、红花

C、麻仁、酸枣仁

D、决明子、莱菔子

E、白芥子、郁李仁

外用内服均具有收敛止血功效的药物是()

A、白矾

B、雄黄

C、降香

D、蜂房

E、硫黄

治疗脘腹或四肢挛急作痛,芍药应配伍的药物是()

A、甘草

B、大枣

C、党参

D、山药

E、白术

最新解答的试题
提出现代生物-心理-社会医学模式是()

A.恩格尔B.波特C.托马斯·帕茨瓦尔D.比彻尔E.桑德斯
付款人在进行付款时无()

A.形式审查义务

B.实质审查义务

C.附带审查义务

D.票据外有关事项的审查义务
根据《公司法》的规定,有限责任公司下列人员中,可以提议召开股东会临时会议的是()。
A.总经理B.人数过半数的股东C.监事会主席D.人数为半数的董事
关于股份有限公司中的监事会,下列说法错误的是()

A.监事会负责提议聘请或更换外部审计机构B.监事会主席和副主席由全体监事过半数选举产生C.监事会中的职工代表的比例不得低于三分之一D.监事会应至少每6个月召开一次会议
三北精神的科学内涵