Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Question on restores

Author  Topic 

JamesAx
Starting Member

4 Posts

Posted - 2010-03-15 : 08:47:55
Hi,

Can someone help me with understanding what goes on when restoring a database please. Specifically, the first time you run a query on the restored db it has to get the data directly from the physical disk right? Subsequent runs are then stored in memory which can be accessed more quickly.
At least that's how I understood it to work at a very basic level. Is this correct?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-15 : 13:59:46
Yes that's correct. Data pages will get moved in and out of cache though depending upon how much memory you have.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -