on 08-17-2009 1:24 PM
Hi!
We use SAP with SAP SQL Server
From tcode DB02_MSS we get several red alerts "no free space in file", meanwhile all the .mdf files have "Size limit (MB)" set on no limit.
Question:
Do we need to set for all the .mdf files the option "autogrow is on ..."?
If yes where can we find the appropriate documentation?
Any helpful information will be very appreciated!
Hi,
download this [document|http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SAP_SQL2008_Best%20Practices_Part_I.docx] and search for autogrow.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> Unfortunately this document has extension .docx and cannot be open with MS Word.
...it can if you install the Office 2007 plugin for older versions
> The question still is:
> Why I get alerts "no free space in file", meanwhile the "Enable autogrowth" in SQL Studio for the several .mdf files is activated?
Check
Note 602816 - RZ20 for SQL Server Space Management incorrect alert
Markus
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.