SQL Server Backup File Format

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

.

Relevant Pages

  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: Protel 2004 answer to Brad Velander.
    ... Sorry, you misunderstand me, I mean to say that jump from 99SE to 2004 XP ... you don't have the same format with one database will all the documents. ... Well you said that you can export file format more recent than AUTOCAD 14 ... key/mouse click you press because I don't know how to do that with Protel ...
    (sci.electronics.cad)
  • Re: PARTIAL SQL Server RESTOREs
    ... DROP DATABASE mywind_part ... ALTER DATABASE mywind ADD FILEGROUP new_customers ... -- A full database backup is performed. ... RESTORE FILELISTONLY lists the database ...
    (microsoft.public.sqlserver.server)
  • RE: Restore public folders and companyweb
    ... > where the backup of the database. ... Before you can start to restore the SharePoint Services databases, ... > Microsoft CSS Online Newsgroup Support ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)