Saturday, February 7, 2009

Model Database Corrupt

The server will start, but tempdb may not get created properly, you cannot create any new databases, and thus it may not be useable.

Load the model database from your dumpfile restart the server.
If you do not have backups, you can restore the original model via script in the script directory, for windows it is:


c:\sybase\ASE-XX_X\scripts\instmodl

You can alternately use the command:

sqlsrvr -d -w model

Of course you would have lost anything that you added to model, so you will have to create those objects again.

The server will start, but tempdb may not get created properly, you cannot create any new databases, and thus it may not be useable.

Load the model database from your dumpfile restart the server.
If you do not have backups, you can restore the original model via script in the script directory, for windows it is:


c:\sybase\ASE-XX_X\scripts\instmodl

You can alternately use the command:

sqlsrvr -d -w model

Of course you would have lost anything that you added to model, so you will have to create those objects again.

1 comments:

database repair tool said... February 2, 2011 at 11:48 AM

Look for professional provider.Check for services that were used by some of the top companies in the world, and consistently receive positive feedback from clients.

Post a Comment