SQL Server Backup File Format - Microsoft SQL Server

wolphie

The IT shop I work in installed MS-SQL Server last week for the sole
purpose of converting a large MS-SQL Server database to a format that
Informix (our main database engine) can read. MSSQL Server installed
perfectly, I can view/manipulate the little "Northwind" sample
database, back it up to a file, restore it (Microsoft Tape Format) just
fine. But... The MSSQL Server "backup" file they sent me that I need
to restore is in a format that I'm unfamiliar with. It is a large
*.sqb file and when I try to restore (using Enterprise Manager - Right
click on "empty" database, choose All Tasks, Restore Database - From
Device, Point to File - I get the message: File is not a valid
Microsoft Tape Format backup set.

Looking at my little Northwind backup file in a hex editor I see the
characters "TAPE" as the first 4 characters of the file. Looking at
the file that I'm unsuccessfully trying to restore in a hex editor I
see "SSBE". It's not in the standard "Microsoft Tape Format"
apparently, but does anyone have any clue what might have created this
backup file? I hope it's not some weird proprietary program! Any
help appreciated, thanks...

Joe

Apr 18 '06 #1

Subscribe Reply

9328

Tom Moreau

If it has an .SQB extension, it was likely backup up with SQL Back, a
product from Red Gate - www.red-gate.com. They have a 14-day free eval you
can use to read it.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
<wo*****@hotmai l.com> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.com.. .
The IT shop I work in installed MS-SQL Server last week for the sole
purpose of converting a large MS-SQL Server database to a format that
Informix (our main database engine) can read. MSSQL Server installed
perfectly, I can view/manipulate the little "Northwind" sample
database, back it up to a file, restore it (Microsoft Tape Format) just
fine. But... The MSSQL Server "backup" file they sent me that I need
to restore is in a format that I'm unfamiliar with. It is a large
*.sqb file and when I try to restore (using Enterprise Manager - Right
click on "empty" database, choose All Tasks, Restore Database - From
Device, Point to File - I get the message: File is not a valid
Microsoft Tape Format backup set.

Looking at my little Northwind backup file in a hex editor I see the
characters "TAPE" as the first 4 characters of the file. Looking at
the file that I'm unsuccessfully trying to restore in a hex editor I
see "SSBE". It's not in the standard "Microsoft Tape Format"
apparently, but does anyone have any clue what might have created this
backup file? I hope it's not some weird proprietary program! Any
help appreciated, thanks...

Joe

Apr 18 '06 #2

Similar topics

13384

SQL Server Backup Failure

by: nt | last post by:

I am having a problem with a regular backup of an SQL Server (MSDE 2000) database to a local drive. I initiate the backup once a week, by issuing the required T-SQL, via ADO. In this case, the T-SQL is: BACKUP DATABASE GPRS_Dimensioning_Archive TO local_backup WITH RETAINDAYS=21, NAME='GDA_20040706' Note that "local_backup" is a file sitting on the same physical drive as the database itself, and has > 80 GB free. It is not a RAID...

Microsoft SQL Server

1934

Migrating large amounts of data from SQL Server 7.0 to 2000

by: Serdar Yegulalp | last post by:

I'm in the process of migrating a lot of data (millions of rows, 4GB+ of data) from an older SQL Server 7.0 database to a new SQL Server 2000 machine. Time is not of the essence; my main concern during the migration is that when I copy in the new data, the new database isn't paralyzed by the amount of bulk copying being one. For this reason, I'm splitting the data into one-month chunks (the data's all timestamped and goes back about 3...

Microsoft SQL Server

2107

SQL SERVER BACKUP problem in different DEVICES

by: John Rajendran | last post by:

Hi there, I need to take a backup with the following scanerio in mind: At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in c:\ Then at T2 I would like to take only the differential BACKUP of the Transaction log called BACK_1_TRANSLOG.BACK and at T3 I would like to take only the differential BACKUP of the Transaction log called BACK_2_TRANSLOG.BACK. At T4 my system fails and I need to bring the database

Microsoft SQL Server

3809

zip backup file to A:\ problem

by: David B | last post by:

I have this code to find a file, place it in C:\ temp, zip it up then send it to floppy in drive A:\. When I run it it comes up with error 53 - source file not found. However it gets as far as putting the file and the zipped file into C:\ temp. Any thoughts on what is causing this ? David B Hexham UK

Microsoft Access / VBA

3230

need to restore old database (database server 4.01 AIX)

by: HSP | last post by:

hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup purposes). Now, the drive is defective and can't read the tapes anymore. Server is AIX 4.3.2 and database is IBM DB2 Server (DB2 for AIX Version 2.1.2)

DB2 Database

3877

MS SQL server 7.0 restore/create

by: MikeB | last post by:

Problem : I am maintaining a legacy application which is distributed with a default database, loaded from a file called Master.dat. I wish to update the values of 10 fields in 1 table. I can restore a database from Master.dat within the (C++ and SQLDMO) app. If I try to restore from command line osql, the restore fails :

Microsoft SQL Server

21127

SQL Server 2005 full backup script

by: m19peters | last post by:

We have a script that I had to rework a little bit for 2005 that does a full backup for every database on the server... For some reason on some nights the script does not backup all databases... Its like it skips over it for some reason... Output of the script below on the night in question was: Executed as user: NT AUTHORITY\SYSTEM. master (Message 0) Status is ONLINE dbname / dbdevice = master / SQLBUmaster (Message 0) Processed...

Microsoft SQL Server

7101

SQL Server 2000 Backup and Restore, Need help!

by: smoi | last post by:

Hi all, My manager ask me to do backup for 3 database and restore them in a new server. I did the backup for the 3 database into BAK file. Then in the new server, when I did the restore in SQL Server Enterprise Manager by using their restore function and selecting device(s) for the BAK file, I encounter the different messages such as the following: 1. Microsoft SQL-DMO (ODBC SQLState: 4200) The media family on device 'C:\Backup.BAK' is...

Microsoft SQL Server

6087

Sql Server express 2005 deployment

by: =?Utf-8?B?UHVuaXQgS2F1cg==?= | last post by:

Hi, I am developing a windows application in VS.NET 2005. The application is database driven and I need to deploy it on a client's pc. How should I go about developing such an application. I remember I did something once long back .. like including .mdf files into my project in the solution explorer of VS 2005 and then used Click Once deployment tool ... to make sure that the database and tables were created when the client installed my...

C# / C Sharp

8427

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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8746

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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8627

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7356

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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6179

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

5649

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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4175

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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4335

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

1975

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