Preserve MSSQLSERVER access to RAM Disk after reboot
2 posts · Closed
Alex Guest
We have RAM Disk running on Windows Server 2008 R2. It has MS SQL TempDB stationed on it. Is there a way to preserve NT Service\MSSQLSERVER full access to that disk after reboot besides adding NT Service\MSSQLSERVER to the Administrators group?
Andrew SoftPerfect
The file system is initialised with default security settings.
Another possible way is to use an image file and discard any changes:
- Create an image file of the required size. In the latest version of RAM Disk is will be sparse and take very little physical space.
- Mount the image file and format is as NTFS. Then set the security permissions that allow full access for MSSQLSERVER.
- Unmount the image file and create a RAM Disk based on it. Ensure Save Contents to Image remains unchecked.
As a result, the RAM disk will be initialised from the contents of the image file. Because the image file is sparse, it will be loaded very fast regardless of its size. No changes will be written back to the image.
This topic is closed.
It has had no new posts for over a year, so the software versions it talks about may be out of date.
Start a new topic in RAM Disk if you have a similar question.