Web Development

Ask something
Discussion Locked

MSSQL 7.0 Restore

0 helpful
1 reply

by rbotzer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Try to restore Sql and get the error "3242" "is not a valid Microsoft Tape Format Backup Set". We check SQL versions, builds, srv pcks, and still get the same error. We have made several dumps. Create the a system from scratch, same error. We evenget error trying to restore master from the command line in single user mode. Microsoft identifes the problem, but does not give a good answer on how to resolve the problem. Sure could use some help.

1 reply

by karpi

Hello,

is the tape formatted wit SQL-Server 6.5?

Have you considered restoring with "With Move" option? (Options in Restore-Database Dialog)
Did you use the MS-SQL-Server Backup or did you use a Backup-programm with a SQL-Server-Agent?

HTH
Karpi

This discussion is closed to new replies.