Restoring DB - Microsoft SQL Server

Kev

Hi all,

I have a very old MSSQL data backup file.
I do not even remember that it was created in SQL7 or 2000.
Anyway, I'm trying to recreate DB from this backup.
Is it possible to create DB from backup file?

I tried restore from that file and SQL server complaining.
"The file on device '***' is not valid Microsoft tape format backup set."
Thanks
-Jay

Jul 20 '05 #1

Subscribe Reply

3286

Erland Sommarskog

Kev (no****@msu.edu ) writes:

I have a very old MSSQL data backup file.
I do not even remember that it was created in SQL7 or 2000.
Anyway, I'm trying to recreate DB from this backup.
Is it possible to create DB from backup file?

I tried restore from that file and SQL server complaining.
"The file on device '***' is not valid Microsoft tape format backup set."

Maybe it is so old that it is from SQL 6.5? In that case, you need SQL 6.5
to read it.

If you are using SQL 2000, you should be able to restore the database,
no matter if the backup was taken on SQL7 or SQL2000.

Does the error message actually say ***, or is that something you put
in?

The actual command, and the actual error message could give a clue if
you are happening to do something wrong.
--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #2

Jay

Yes, It might be 6.5.
'***' was name of my file.

Thank you.

"Erland Sommarskog" <so****@algonet .se> wrote in message
news:Xn******** *************@1 27.0.0.1...

Kev (no****@msu.edu ) writes:
I have a very old MSSQL data backup file.
I do not even remember that it was created in SQL7 or 2000.
Anyway, I'm trying to recreate DB from this backup.
Is it possible to create DB from backup file?

I tried restore from that file and SQL server complaining.
"The file on device '***' is not valid Microsoft tape format backup
set."
Maybe it is so old that it is from SQL 6.5? In that case, you need SQL 6.5
to read it.

If you are using SQL 2000, you should be able to restore the database,
no matter if the backup was taken on SQL7 or SQL2000.

Does the error message actually say ***, or is that something you put
in?

The actual command, and the actual error message could give a clue if
you are happening to do something wrong.
--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #3

Similar topics

5440

Help with saving and restoring program state

by: Jacob H | last post by:

Hello list... I'm developing an adventure game in Python (which of course is lots of fun). One of the features is the ability to save games and restore the saves later. I'm using the pickle module to implement this. Capturing current program state and neatly replacing it later is proving to be trickier than I first imagined, so I'm here to...

Python

2356

Restoring php nuke db after crash

by: Yair Sageev | last post by:

Greetings. I was running PHP Nuke on a Win2k box using Apache2Triad. Fortunately I backed up the drive using windows backup prior to the hard drive failure. Now I have installed Apache2Triad on another machine and wish to reimport the mySQL database that PHP Nuke relies upon. If anyone can tell me how to do this I would be very...

MySQL Database

9599

Restoring logs to a database

by: Edwinah63 | last post by:

Hi Gurus, i am having problems with restoring a ms sql database. i have restored the database using veritas to a different location ('g:\datafiles') in no recover mode. when i view the database through the Enterprise Manager, it shows the database as silver icon (loading).

Microsoft SQL Server

5184

Restoring DMS DB from multipe backup files

by: Luc Le Blanc | last post by:

I'm trying to restore a backup from a DMS DB2/2 database. The original DB has 3x 1Gb containers in the user tablespace. So the backup has 3 files, bearing the time of the backup as file name, with extensions ..001, .002 and .003. The files are placed into a d:\dbname.0\db2.0\yyyymmdd directory tree, as does DB2/2 when performing the backup. I...

DB2 Database

4471

Error restoring bytea from dump

by: Együd Csaba | last post by:

Hi, the restoration of a dump stops at the line above. The dump was created with pgsql 7.3.2 and I need to pump it into a 7.4.3 one. Should anybody tell me what the problem can be and how I can solve it. (There are double apostophes many times in the string - is it normal??? Besides of the field separator of course...) Many thanks,...

PostgreSQL Database

2737

Method for restoring front end from a backup

by: rdemyan via AccessMonster.com | last post by:

I'm thinking about providing a relatively easy method for users to restore the front end from a backup. The purpose is to allow for restoring if the front end becomes corrupt. Here are some particulars about my app 1) The front end is distributed as a .mde file. 2) Front end uses workgroup security 3) A separate logon form is used to...

Microsoft Access / VBA

2352

Problem restoring Exchange 2000

by: Robbert van Geldrop | last post by:

Hello, I have a problem restoring Exchange 2000 files. Our software has an interface to ESEBCLI2.dll for online backup and restore features. Everything works fine with Exchange 2003 and also when backing up Exchange 2000, yet restoring Exchange 2000 gives some problems: A Store is restored: * the restore is started.

.NET Framework

4428

Restoring dump files completely

by: chenert | last post by:

Hi all, im beginner to restoring dump files and postgresql as well so hope u could bear with me.! :D i have these dump files and i've been working on restoring everything in it. i've tried this command : psql -U postgres dbname < data.dump : the tables were restored wihout any data inside it. does anyone know how I could fix this? :D

PostgreSQL Database

6547

Restoring selected tables / table data

by: Troels Arvin | last post by:

Hello, Every so often, I'm asked to help people recover data from tables that were either dropped or where to much data was DELETEed. The complications related to restoring data are a problem. The SAS users are laughing because they can (to a certain extend) easily go back to an earlier SAS table by simply starting dsm. Of course, a flat...

DB2 Database

3691

Restoring database hangs SQL Server 2005

by: DMT012 | last post by:

Hello. Occasionally on my production server when I run an automated script to restore a database from a backup it hangs and the database is put in restoring mode and just stays there, requiring me to delete the database and restore the backup manually and causing everything else to timeout (it's part of an update process that includes database...

Microsoft SQL Server

7693

What is ONU?

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...

General

7916

Problem With Comparison Operator <=> in G++

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. ...

C / C++

8117

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

6275

AI Job Threat for Devs

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...

Career Advice

5217

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

3651

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

3631

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2101

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1207

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP