on 11-04-2008 9:34 AM
Dear all,
My SAP system is ERP 6.0 with SQL Server 2005 in Wins 2k3.
I find a strange situation as below:
- In TCode AL11, every file has column "Length of file". I find that the column "Length of file" shows the real size of each file (in Wins); but for SQL data files & SQL log file, it's NOT true. Here's an example:
TSTDATA1.MDF:
* AL11: 1497366528*
* Wins: 29.3GB*
TSTDATA2.NDF:
* AL11: 301989888*
* Wins: 28.2GB*
TSTDATA3.NDF:
* AL11: 301989888*
* Wins: 28.2GB*
TSTDATA4.NDF:
* AL11: 427819008*
* Wins: 28.3GB*
TSTDATA5.NDF:
* AL11: 553648128*
* Wins: 28.5GB*
TSTDATA6.NDF:
* AL11: 742391808*
* Wins: 28.6GB*
TSTDATA7.NDF:
* AL11: 994050048*
* Wins: 28.9GB*
TSTLOG1.LDF
* AL11: 52166656*
* Wins: 7.95GB*
Column "Length of file"'s value is very different from Wins' value. Anyone can explain this situation?
Thanks,
Toan Do
Dear Toan Do,
databases are working with sparse files. The database files initially are getting created
with the value you propose in sapinst - but at the beginning they are almost empty
and will be filled the longer the users make their updates. I hope this explains.
Kind regards,
Andreas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Please check the following SAP notes:
32574 - Display the length of files in SAP directories
987732 - AL11: Length specification missing from attributes
I hope its of some help for you.
regards
Chen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.