• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Restoring Database giving error message and restore without the log file

Hi,

I am trying to restore a database from a weekly backup using the following commands

use master
go
restore database EWareConfig
from EWareConfigWeeklyFull
with recovery,
replace

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.

Also,

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

Tabrez
0
tabrezgm
Asked:
tabrezgm
  • 2
1 Solution
 
kawhitmore73Commented:
Hi Tabrez,

It is possible to restore the data file without  the log, but point in time recovery won't be available.  Your data will only be as current as the most current full or differential backup.  Remember to restore the most current full backup first, then the most current differential backup.

Not sure about the error message you are getting.  Sorry.

kawhitmore73
0
 
kawhitmore73Commented:
Tabrez,

Just a followup.  My answers were based on my assumption that this is a MSSQL Server.

When doing a restore, only the last restore should be done with the recovery option.  So if you are going to restore the last full backup, followed by the most current differential backup, the differential backup should be the one with the recovery option specified.  If you are going to include the log backups as well, the most current log will be the one with the recovery option specified.

HTH.

kawhitmore73
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now