Snapshot

Question

1. What is the initial size of dbsnap shot?
2. How to make table readlonly?

Answer 1

Hello,

The first question is sort of a loaded "it depends" question... The "initial" size of a database snapshot is 64k for the NTFS file information PLUS whatever is needed to bring the database snapshot to a CONSISTENT state. If there is a VERY LARGE and LONG transaction running, it could be the size of the original database! If it's extremely quiet, not much more than the NTFS file information could be needed.

It's not possible to designate a single table as read-only at the table level. The way to do this is to move the table to a different filegroup by itself and then make the filegroup read-only.

-Sean

---

Sean Gallardy | Blog | Twitter

Answer 2

Hello,

The first question is sort of a loaded "it depends" question... The "initial" size of a database snapshot is 64k for the NTFS file information PLUS whatever is needed to bring the database snapshot to a CONSISTENT state. If there is a VERY LARGE and LONG transaction running, it could be the size of the original database! If it's extremely quiet, not much more than the NTFS file information could be needed.

It's not possible to designate a single table as read-only at the table level. The way to do this is to move the table to a different filegroup by itself and then make the filegroup read-only.

-Sean

---

Sean Gallardy | Blog | Twitter

To add to the solution to the second question: if at all it  is feasible in your condition - deny all Rights on this table except Select :) It will be read-only.

---

Sarabpreet Singh Anand

Blog , Personal website

This posting is provided , "AS IS" with no warranties, and confers no rights.

Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.