Restoring Database giving error message and restore without the log file
Posted on 2004-08-25
I am trying to restore a database from a weekly backup using the following commands
restore database EWareConfig
and i get the following error message
Msg 3270 An internal consistency error occured. Contact technical support for assistance.
Does anyone know why this is happening.
I have a database (datafile size is 10 GB) which is 10 GB whereas the transaction log is 150 GB.
The database has crashed and we would like to restore it but it might take an awful lot of time.
Is it possible to restore just the datafile and bring up the database.
Thanks in Advance