How many plans must you setup?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How many plans must you setup?

You are setting up the backup scheme for your SQL Server 2005 server and want to setup nightly full backups and hourly log backups in the Maintenance Plans subsystem. How many plans must you setup?


Answer
2

Explanation
Since you have two separate schedules for the maintenance operations, you will need to have two separate plans to handle this need. Each plan can only be executed on one schedule, so one is needed for a single daily execution, the nightly full backups, and another for the hourly log backups.

(Continued on next question...)

Other Job Interview Questions

• If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?
• You then write a function to use this assembly, but it does not work. What could be the problem?
• What rights does a user need to perform a truncate table command SQL Server 2005?
• What does the DEALLOCATE statement do in SQL Server 2005?
• What does the DUMP command do?
• What is the best way to have your junior DBA do this?
• What is a primary key? What is a foreign key?
• How are modified extents tracked in SQL Server 2005 (which internal structures)?
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• When discussing image support in Report Builder, which of the following is the most accurate statement?
• More...