October 4, 2009 at 9:02 am
repent_kog_is_near (10/4/2009)
If the data and index files are separated (mdf and ndf), does it matter where the amount of free space is required/needed?
Yes, your log files should be stable and not be growing. Your data files will grow - so you want available space there.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 4, 2009 at 5:57 pm
Jeff,
I had meant to ask if both the mdf and ndf need the extra space, or is the need just in mdf file. I would think we need the extra space in both files.
(Some databases do not have ndf, just the mdf and some DBs have both seprated).
So we need the extra space for 2 things, as I observe:
*Growth of DB/Index
*Need to Reindex.
Thanks for the ideas
Dan
October 4, 2009 at 6:00 pm
That's why I keep stating data files - I've had a few systems where they didn't have mdf/ndf files because someone decided to change it. SQL Server doesn't really care.
Yes - you want the space available in the data files.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply