sql2005 dbase snapshot - first

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 1

1. As long as you perform DML operations in small chunks it should'nt be a problem.

2. Since the snapshot uses sparse files it the more modifications you perform to source database the more the snapshot grows in size

3. Yep I agree

4. Difficult to answer. I think you might end up running out of disk space if there no available disk space

5. Nothing else I believe.

[font="Verdana"]- Deepak[/font]

steve smith-401573 SSChampion Points: 10889 More actions · Answer 2

You didn't describe your disk configuration, which greatly affects your question about system response.

N J Right there with Babe Points: 732 More actions · Answer 3

If drive space is constraint, you can create new database snapshot after every update in chnuk. This way disk space issue will be minimal .