Data Divas,
In Enterprise Manager the database properties dialogue has tabs for Data Files and Transaction Log. Both of these show the same File Properties options and allow 'Automatically Grow File'. Assume this is ticked and on the right the 'Unrestricted file growth' button is selected in 'Maximum file size' so the 'Restrict file growth' figure is greyed out. On the left does the figure (in MB or %) for 'File growth', which is not greyed out, still have any effect? If so, what?
Thanks
Mark J. Fleming
_COMPANY CONFIDENTIAL UNLESS STATED OTHERWISE.
Any opinions expressed in this message are those of the sender only and do not necessarily represent the views or opinions of THE PROMISE SOLUTIONS GROUP or any associated companies.
Registered Office: Promise Solutions Ltd Promise House, Stafford Road, Wolverhampton, West Midlands WV10 6AD.
Company Registration Number: 04822774
The information contained in this message and any attachments is intended solely for the use of the individual or entity to whom it is addressed. It may contain privileged and confidential information and exempt from disclosure under applicable law.
If you are not the intended recipient you must not disclose, copy, distribute, retain or take action reliant on any part of it. If you have received the e-mail in error please notify immediately to [Email address protected]
Whilst we have checked this e-mail and any attachments for viruses, we do not warrant that they are virus-free. You therefore take full responsibility for virus checking.
Promise Finance Limited is authorised and regulated by the Financial Services Authority in respect of mortgage and general insurance activities only.
This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs.
______________________________________________________________________
________________________________________________________________________
MS Sql Server LazyDBA home page