February 15, 2008 at 11:53 am
After selecting the FROM Device and the file from the folder I click on the options tab and this error is reported.
ERROR 3242: The file om device 'C:\MSSQL\Backup\TDump.DAT' is not a valid Microsoft Tape Format backup set. Restore FILELIST is terminatine abnormally. I click OK, and the restore attempts stops.
:hehe:
😀
ACN is the world's largest direct seller of telecommunications and essential services.
http://helpu.acndirect.com/
ACN Digital Phone Service customers automatically enjoy unlimited calling to 60 landline
destinations around the world, including India, Mexico and the UK!
:hehe:
February 15, 2008 at 12:22 pm
I believe you need to use the conv65 utility to convert to the 7.0+ format - you can't do that from a backup, and you can't restore a 6.5 backup and have it automatically upgrade.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
February 26, 2008 at 12:21 pm
Paul is right. You have to restore your database to 7X first, backup again from there, then restore it to SQL 2000 (I am not sure if it will be OK directly to SQL 2005).
Also, the extension of your file is DAT. Is it a backup file?
February 28, 2008 at 10:25 pm
You need to upgrade 6.5 to 2000 first. Check this KB.
http://support.microsoft.com/kb/322620
.DAT file seems a device file. 6.5 Database sits on devices. Devices are logical files which map to physical files. It is for SQL 6.5 as it was originally from Sybase.
Another thought, you may try BCP to pull out the data and bcp/load into SQL2005.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply