Is this message saying anything useful about fragmentation, sparse pages and the like, or is just saying that 33G is "too big" on general principles?

SQL Anywhere Network Server Version
Note: The size of 'D:\xxx.db' is larger than expected

asked 12 Sep '14, 13:18

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

The message means that the database/log file header says it is "X" bytes in size but the OS says it is "Y" bytes in size and X < Y.

Generally, that's not a problem. It might be an indication that the database file was growing at the time of the last crash. If the server was shut down cleanly, I wouldn't expect to see that message.

If ever X > Y, you will be in trouble. That means the OS lopped of a useful part of the file.

permanent link

answered 12 Sep '14, 13:33

John%20Smirnios's gravatar image

John Smirnios
accept rate: 38%

Thanks... so yes, it is being profound, it's telling me that I killed dbsrv11.exe for being unresponsive :)

(12 Sep '14, 15:34) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 12 Sep '14, 13:18

question was seen: 2,982 times

last updated: 13 Sep '14, 09:08