Solved

Restoring Database giving error message and restore without the log file

Posted on 2004-08-25
4
290 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 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

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
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…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

630 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