Guest_imported
New member
- Jan 1, 1970
- 0
I know that in mySQL database, the data is stored in the memory but in MSSQL server, where is the data stored ? Is it stored in the memory(RAM) or harddisk?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
where's data stored
- Thread starter Guest_imported
- Start date
- Status
tlbroadbent
MIS
The database is stored on disk. However, SQL Server caches a lot of data in memmory for fast access. When updated it is written back to disk.
I've not worked with MySQL but it seems to me that it must also store data on disk. Otherwise the data would be lost upon a system reboot. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Locked
- Question
- Locked
- Question