An experience with Sybase database

I've been doing computers for years, big and small things also encountered a lot, can level is still very "food", this is not, I encountered a few days ago, difficult me for a while, the problem solved, but do not understand so, I shook it out, please "veteran" of the guidance. NT4 under Sybasexi, I moved the two device files of the database Dec_cw.dat (100M), Dec_log.dat (30M) to the location (why?) when SQL Server did not start. Because the space of C disk is only dozens of trillion! , but after starting SQL Server disappeared database, I shut down SQL Server, had to move the two files back, and then start SQL Server, still do not see the database, this I can panic God, there are 1.5 of financial data!

I hastened to call, consulted a few people, replied: Master Library has changed, so CWDB Library can not open, become a suspect state, may want to lose data! I do not give up, dead horse as a live horse medicine, first of these important documents to save, rebuild the database.

I first built the Dec_cw.dat (100M), Dec_log.dat (30M) Two devices in D disk, built the CWDB library, shut down SQL Server, and covered the original two files with Dec_cw.dat (100M), Dec_log.dat (30M), No way!

Delete, then build, restore one months ago from backup equipment (back_cw.dat), the long-awaited database content appeared in the client to start the financial software, can run, but the lack of one months of data, originally, this month has not been backed up.

Try again. Turn off the SQL Server and start the SQL Server with the original Dec_cw.dat (100M), Dec_log.dat (30M) cover, and then the new ... The miracle has appeared, the original data is intact! I jumped with joy, backed up immediately, CWDB, and backed up Master (no).

Data is to find back, but I am still very afraid, what can be done quickly and safely, the old birds do not just look at Ah, pull brother, my mailbox is ljhdhx@263.net.

Webmaster's words:

Hard to do a long time data, lost all of a sudden, it is really a headache. A monthly review once published in SQLServer7.0 (English) to restore the "lost" Chinese data, the author Xhui also encountered such a problem. Now the use of web-based database server more and more, I think you must have encountered a lot of difficulties, this time to borrow Rogahon Netizen's one of the tips, but also please send these ideas and questions to us, hope that more users encounter the same problem when there are ways to solve this problem. We will try to collect this information (recently collected some information about Oracle) to meet everyone's needs.