Cannot Open .bak File from ms sql database. either 2000 or 2007

[Rizwan.Bakhshi@gmail.com]

Can not open mssql .bak file in ms_sql. File starts with "ti" and some
weired charctor. Can some one help me on how to open this back up of
mssql database. I've tried to restore this file in mssql and it says it
does not recognize this file. I understand that .bak file for mssql
should start with "tape". But when i opened this file in ms excel it
show the file starting with "ti" not tape.

Any help on this would be appreciated and please let me know if you
need access to file.

Thanks

[Erland Sommarskog]

Re: Cannot Open .bak File from ms sql database. either 2000 or 2007

(Rizwan.Bakhshi @gmail.com) writes:

Can not open mssql .bak file in ms_sql. File starts with "ti" and some
weired charctor. Can some one help me on how to open this back up of
mssql database. I've tried to restore this file in mssql and it says it
does not recognize this file. I understand that .bak file for mssql
should start with "tape". But when i opened this file in ms excel it
show the file starting with "ti" not tape.
>
Any help on this would be appreciated and please let me know if you
need access to file.

I will have to admit that I did not know about the TAPE thing, but I
looked at some backups, and indeed they had TAPE in the beginning.
Except one from SQL 6.5, which had MSSQL.

Anyway, with the information that .bak file could be anything. Or do
you have a special reason that it is an SQL Server backup file?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx