What does the SQL Writer service do?

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

(Continued from previous question...)

What does the SQL Writer service do?

Answer
Handles Volume Shadow Service Copy functions.

Explanation
The SQL Writer service was introduced to handle access to the data files in SQL Server. It allows backup programs, like VSS, to function while SQL Server is still running.

(Continued on next question...)

Other Job Interview Questions

• What feature of SQL Server 2005 would help you get the snapshot transferred?
• To maintain the best performance of your SQL Server 2005 databases, how should you deploy encryption technologies?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• What security role should you assign them?
• You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragments the indexes in an online manner. What command should you use?
• Can you use Full-text search to index this column?
• You cannot execute procedures on the 2005 server. Why not?
• What does VARP() do in SQL Server 2005?
• How can you easily monitor to see if this assembly is being used?
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• More...