rebuilding database -
03-18-2010
, 04:13 AM
Hi,
i have a problem regarding database performance.i am using sql
anywhere 8. the size of my db is 5gb and it is pretty slow.inserts,
selects, etc. would take more than a minute.
i searched everywhere and found solutions like defragmenting, unload/
reload the database. i chose the latter, which is to rebuild the
database.i understood everything except the number 9 step provided in
the manual which is
-- Rebuilding a database involved in replication --
# 9. When you run the Message Agent, provide it with the location of
the original off-line directory on its command line.
- what do you mean by that?
- does it mean i have to provide the location of the old transaction
log?
- if my second question is true, what is the purpose of providing the
location of the old transaction log when i have a new transaction log
when the db is started with a starting offset of the ending offset in
the old log
hope someone can shed a light. thank you. |