Interview Questions
1. What are the restrictions in Database Snapshots?
- Database snapshots depend on the source database. They can only be created on the same server as where the database resides (or the server to which the database is mirrored.)
- While there are snapshots present, you cannot drop the database or add any new files to it
- Once a database snapshot becomes suspect it cannot be saved. It just has to be deleted. This can happen if the snapshot runs out of space or reaches the maximum sparse file size limit
- You cannot create indexes on snapshots, they are strictly read only
- The user permissions are exactly the same as it was in the source database. You cannot grant a user access to a
snapshot. You have to grant the access in the source database and then take another snapshot first before the user will
be able to access it
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment