SQL Server Restore Problems - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Server Restore Problems

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-05-06 : 08:04:17

Knight writes "Hi,

I had an SQL server 7.0(Desktop Edition) running on WINXP, due to some problems on the PC, i had to take the backup of the database.

now after i formatted the pc and try to restore the backup, it gives me following message.

Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'c:\pos.bak' is not a valid Microsoft Tape Format backup set.

Please help me how i can restore this data.

Regards"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-05-09 : 03:57:27

were you trying to restore from tape instead of device?

--------------------
keeping it simple...