Solved

Restoring Database giving error message and restore without the log file

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql views 3 57
Database (Access Table) Security Access 8 60
mysql workbecn having problems to export tables to cvs 4 28
Batch convert csv to xlsx 10 61
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
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…

752 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