dump database and dump transaction
The maximum file path/name size for a physical device is 127 characters. This limitation is not explicitly stated in the "Restrictions" subsection of the "Usage" section of the reference pages for dump database and dump transaction.
The “Data Cache Memory” subsection in the “Usage” section
of the reference page for
sp_cacheconfig includes
a bullet point that states, in part:
- A data
cache requires a small percentage of overhead for structures that manage
the cache. All cache overhead is taken from the default data cache.
Since you can configure the default data cache size separately
from total memory, the cache overhead is taken from free memory,
not the default data cache. For this reason, the bullet should read:
- A data cache requires a small percentage of overhead
for structures that manage the cache.
All cache overhead
is taken from free memory.