May 11, 2005 at 12:41 am
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
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