Solved

Restoring Database giving error message and restore without the log file

Posted on 2004-08-25
4
284 Views
Last Modified: 2012-08-13
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
Comment
Question by:tabrezgm
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
kawhitmore73 earned 500 total points
ID: 11891461
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
 
LVL 1

Expert Comment

by:kawhitmore73
ID: 11891513
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

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Read about achieving the basic levels of HRIS security in the workplace.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now