Post reply

Rebuilding Databases.

  • May 11, 2005 at 12:41 am

    #86533

    Hi All,

    I need to know how to rebuild the database.

    Very often i have to backup databases which come from our clients.

    Most of the times, the collation order of the backup files and my server wont match, but they restore successfully.

    The problem comes with the application, when we browse the data from the Application (Front end).

    We tried rebuilding the databases for the required collations, but have got various problems like:

                  1) Status will keep showing rebuilding but wont rebuild.

                   2) Data will be corrupt or gets deleted.

                   3) Sometimes the whole instance will get corrupt, i mean it stops working 🙁

    If any better ways or precautions to be taken for rebuilding please let me know.

    Thanks in Advance,

    Subhash

  • May 11, 2005 at 12:59 am

    #557943

    What did you had on your mind: "We tried rebuilding the databases for the required collations.."? If you want to change db collation you don't need to restore it. You can simply run

    alter database [db name] collate [collation_name]

    statement. If I missed something let me know

     

    Hope this helps

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply