| Author |
 Topic  |
|
johan08
Starting Member
3 Posts |
 Posted - 09/13/2012 : 12:53:42
|
Hi all,
When I try to restore a SQL 6.5 Backup .dat file to either SQL server 7 or SQl server 2000 I get the following error message:
Error 3242: The File on device 'C:\MyBU.DAT' is not a valid Microsoft Tape Format backup set.
Just FYI:
- I know that the regular sql backups (v7. 2000, etc) in .BAK files use MTF.
- My .DAT file is really a v 6.5 backup; it is not a "Database Device" file. I know that, because I made the backup myself under 6.5
Any help is welcome,
Thanks,
Johan |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
johan08
Starting Member
3 Posts |
Posted - 09/13/2012 : 17:06:28
|
Hi Tara,
Thank you for your prompt reply.
But, could you take a look at the beginning of this thread where the consensus is that this (restore .dat to V7 or v2000) is THE way to go?
Was everyone (including yourself) mistaken in 2011? I, know, even goddesses can make mistakes ...
Johan |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
chadmat
The Chadinator
USA
1947 Posts |
Posted - 09/13/2012 : 18:39:03
|
I didn't think you could either, I was surprised when I read the first part of this thread, and it appeared as if the OP got his data, so I thought I had learned something new today (That you could restore a 6.5 backup to 7.0 or 2000). Turns out I didn't learn somethng new, and my original thought was right. I am still wondering how the OP got his data though.
-Chad |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 09/13/2012 : 18:47:40
|
quote:
Originally posted by chadmat
I didn't think you could either, I was surprised when I read the first part of this thread, and it appeared as if the OP got his data, so I thought I had learned something new today (That you could restore a 6.5 backup to 7.0 or 2000). Turns out I didn't learn somethng new, and my original thought was right. I am still wondering how the OP got his data though.
I think I was using the "restore" word loosely in my post from last year. I think I was saying you need to get it into one of those versions so that you can then export the data. I think I'll go back and fix that post up to avoid any further confusion.
I assume the OP restored the file into 6.5 to get the data out into the format he needed.
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Subscribe to my blog |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 09/15/2012 : 05:06:51
|
Yes, I created a VM with NT 4 and installed SQL Server 6.5 into it.
N 56°04'39.26"
E 12°55'05.63" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 09/15/2012 : 05:06:59
|
Yes, I created a VM with NT 4 and installed SQL Server 6.5 into it.
N 56°04'39.26"
E 12°55'05.63" |
|
|
|
johan08
Starting Member
3 Posts |
Posted - 09/17/2012 : 16:11:41
|
Hi all,
Thank you for looking into this once more. I've decided to take the lazy route which is to export the information in a few key 6.5 tables that we're interested in to tab delimited files with bcp and BULK IMPORT into a new SQL 2005 database.
Johan |
|
|
|
Topic |
|
Read an exported 6.5 database
