?
Solved

Restoring Database giving error message and restore without the log file

Posted on 2004-08-25
4
Medium Priority
?
293 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
kawhitmore73 earned 2000 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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…

719 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