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.
No comments:
Post a Comment