You wish to ensure you can recover your SQL Serv

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

(Continued from previous question...)

You wish to ensure you can recover your SQL Server 2005 database to a point in time if necessary. Which recovery models can you use?

Answer
Full
Explanation
Only the Full recovery model supports point in time restoration of your database.

(Continued on next question...)

Other Job Interview Questions

• What the heck does ATN2 do?
• A certificate is which type of security mechanism?
• What value should you use for the BROKER_INSTANCE parameter?
• In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• How can SQL Server Agent Mail send messages in SQL Server 2005?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• What type of connectivity does the readpipe/makepipe utility test?
• When using the SQLCMD tool, what does the -V parameter do?
• What does the Log Reader agent in SQL Server 2005 replication do?
• More...