tbruer1138
Programmer
First - can this be done? Secondly - if so, how? I'm not a SQL Server expert and I'm assuming the .DAT file was produced by a backup operation on the 6.5 server.
Thanks in advance!
Thanks in advance!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing a SQL Server 6.5 .DAT file into SQL Server 2000
- Thread starter tbruer1138
- Start date
- Status
mrdenny
Programmer
- May 27, 2002
- 11,595
You can not restore a SQL 6.5 backup directly to SQL 2000. You will need to find SQL 7, and restore it to SQL 7 first. Then backup the SQL 7 database and restore that the SQL 2000.
Sorry for the bad news.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(My very old site)
Sorry for the bad news.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
(My very old site)
- Thread starter
- #3
tbruer1138
Programmer
Looks like I'll be taking the long road home - thanks for the help!
mrdenny
Programmer
- May 27, 2002
- 11,595
no problem.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
(My very old site)
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
(My very old site)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question