Restoring DB

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
-JayKev (nospam@.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, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Yes, It might be 6.5.
'***' was name of my file.

Thank you.

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns944872A36966Yazorman@.127.0.0.1...
> Kev (nospam@.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, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp