Reputation
Next privilege 125 Rep.
Vote down
Badges
6
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Sep
23
comment SQL Server 2008 R2 - Cannot create database snapshot
Yes it is NTFS, it is a new server formatted by Windows 2008 R2 and I have replicated the problem using virtual machine. Also when I apply full control permissions to the service account on 'e:\' the snapshot works fine.
Sep
22
comment SQL Server 2008 R2 - Cannot create database snapshot
Yes that is the file I am trying to create. I have tried to give the service account the SE_MANAGE_VOLUME_NAME permission so it can use instant file initalization but it made no difference.
Aug
4
comment I have problem installing the sql server 2008 r2 on windows server 2008 r2. It gives me the following error
Did you verify that the file exists and that you can access it?
Jul
26
comment .NET huge Issues
Anything in your event log?
Jul
23
comment Sql Server 2008 Database Mirroring
Oh well that won't work then. Thanks for the info and the link, i'll have a read.
Jul
23
comment Sql Server 2008 Database Mirroring
thank you, i had planned on using a witness but haven't got that far with it yet, if I had two witnesses and a mirror (which is what i'm planning), would I need to lose all three before the principal becomes unavailable?