I want to store my databases only on RAM. I see that in MySQL server I can choose the "MEMORY" engine and the table with be stored only in the RAM. How about MS SQL Server? How can that be done there?

Thank you

4 Years
Discussion Span
Last Post by Reverend Jim

Yes, you can use the MEMORY engine, If you are using Linux then mount your database in tmpfs

Edited by Kim Thomas


If you keep your database in RAM then you could set it up for replication to a database on disk so that you would have a permanent version in case of failure. As an alternative to configuring the DBMS to use RAM, you can also create a RAMDISK, then create that particular database on the RAMDISK. One option is a free program from SoftPerfect which is available here. One of the options with this program is to make the disk permanent. With the permanent option, when you unmount the disk, the contents are saved to an image file which is reloaded when you remount the RAMDISK. This would be appropriate if your application is not required 24x7.

Edited by Reverend Jim

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.