473,698 Members | 2,246 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Restore Database error in SqlServer

254 Contributor
Hi
while restoring database in sql server2000/2005 I am getting this error message:

The media set for database nhrc has 2 family members but only 1 are provided. All Members must be provided.RESTOR E DATABASE is terminating abnormally.

what does this error means and how can I find out the solution.
Feb 10 '09 #1
1 2212
ck9663
2,878 Recognized Expert Specialist
I found this with google.

-- CK
Feb 13 '09 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2226
by: Spieg | last post by:
I've a program with VB6 working with SQLServer 2000. I have a Central Station with the program runnin with full prvileges and that can perform all the actions on the DB. There are also some clients that cannot be connected via LAN or internet that need to use the same DB. The way I solved this with Aces was to copy the Access file from the Central Station ot the disconnected clients. Then to update the central Staton I used to save the...
13
2138
by: EggsAckley | last post by:
Hi: I have a file that I have been told is a SQL Server backup from a server somewhere. The file is about 200MB in size I am trying to create the database on my local server using RESTORE. I created the backup device, associated it with a backup name etc., copied the file into the backup dir. When I run the RESTORE command, Query Analyzer tells me the database
9
13999
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following “SQL2059W A device full warning was encountered on device "TBS_IDX". Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) t
1
1526
by: G. Dean Blake | last post by:
How can I backup and restore a SQLServer DB from a .net VB program? Thanks, G
0
987
by: Mamatha | last post by:
Hi i want to restore SQL Server 2000 database backup file using ASP.I have some code to restore backup file but it gives an error like "Device is not correct or Device- offline.see error log files for more details".The relevent code is: <% Set srv=Server.CreateObject("SQLDMO.SQLServer")
1
2780
by: Alvin | last post by:
Can someone put me on the right track? I have a .bak file from an MSSQL 7.0 database. I want to restore the database in SQL 2000 or 2005, but the restore fails with the error: "An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)" and "I/O error (bad page ID) detected during read at offset 0x000000001be000 in file 'C:\Program Files\Microsoft SQL...
1
1347
by: truptikalani | last post by:
i want to restore SQL server databse from a file which is created by taking backup of database through coding using SQLDMO object in visual studio 2005. i wrote code for restore using SQLDMO object but it is giving error as no exclusive access to database. database is used by other application. what can i do now? i think i could try for lock but how? could u plz help me?
2
8271
by: l0b0 | last post by:
I'm working on a restore procedure for the case where all MDF files are missing, but the LDF files are all intact. A full backup is done every 24 hours, and a log backup is done every 3 hours. After restoring the last full + log backups, is it at all possible to use the LDF files to recover data from that point up to a newer point in time? I've found a post which explains how to do this on SQL Server 2000...
4
7923
by: DL | last post by:
Background Info: Instance A: SQL Server 2005 on Windows Server 2003 OS Instance B: SQL Server 2005 on XP Prof w/ SP2 Process: backup a database on Instance A like this: step 1 -- Management Studio for Instance A BACKUP DATABASE myAppNameDB TO DISK = 'c:\Temp\myAppNameDB_FullRecovery.bak' GO
0
8683
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9170
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9031
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8901
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7739
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6528
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5862
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4371
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4622
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.