How to restore a sybase database with only intact data files

-What should I do if a database server cannot be started and cannot log on to the database even though the service is enabled. There is a method as a last resort:

⊙ Uninstall and reinstall the database. before reinstalling the database, you need to back up the user database data file and stop the service!

⊙ Start the database server as a single user. Change the run _ (Service name). BAT file under install under the Sybase installation directory, and add the-M parameter after it:

E: \ Sybase \ bin \ sqlsrvr.exe-de: \ Sybase \ data \ master. dat-sxxj-ee: \ Sybase \ install \ errorlog-ie: \ Sybase \ ini-Me: \ Sybase-m

Then execute the batch processing file and start the server

⊙ Run iSQL-USA-p-dmaster: execute the following command:

Recovery Device:

Disk reinit name = 'original device name', physname = 'physical path (can be different from the original ', vdevno = Virtual Device number (as long as it is unique ), size = (in 2 K)

Go

Automatically bind the device to the database:

Disk refit

Go

After completing the preceding steps, you may report some errors and terminate the database server process.

You can still start the database server as a single user. At this time, the user database is recovered.

⊙ Restart the database normally. Remove the startup parameter-M.