|
|
Posted by Erland Sommarskog on 09/20/06 21:53
(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@sommarskog.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
Navigation:
[Reply to this message]
|