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.
| Author |
Topic |
|
kfb5926
Starting Member
7 Posts |
 Posted - 2010-12-09 : 11:28:52
|
| I have several databases mirrored. I was looking in the file explorer on the Mirror server and noticed the mdf and ldf files never grow. That's always made me a little nervous since the databases are write-only and you can't dig into a table and verify that new data is being entered. You just have to take it on faith.Shouldn't the files grow. I'm sure we enter 500 MBs worth of data some days. Also, the Date Modified never changes either, unless I pause and resume mirroring.Where's all that data being stored if not the mdf and ldf files? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-09 : 11:47:26
|
| The databases are probably sized large enough to prevent growth to this point.The date modified will only change when service is restarted, or you manually modify the file someway.If you're concerned, you can recover the mirror and check. |
 |
|
|
kfb5926
Starting Member
7 Posts |
Posted - 2010-12-09 : 12:09:45
|
| That makes a lot of sense. Yes, the files are quite a bit larger than the data in them. I figured there was a simple explanation. |
|
|
|
|
|
|
Mirrored databases' MDF files