dbTalk Databases Forums  

rebuilding database

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss rebuilding database in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dev2
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.