How to restore the .dat file in SQL server 6.5?
Posted on 2004-04-14
I have old SQL server 6.5k which they need to restore the .dat file into the server 6.5K.
I found from website, and below are the snippet code of restoring the .dat file into master table and use bcp to convert it into text:
name = "Master",
physname = "C:\t\TX20021101.dat",
vdevno = 2, size = 5120
My question is: how to bcp the data and from where and how to retrieve it?
I haven't tried on the SQL server 6.5k since it's production database and not dare to try it on.
Cld anyone guide me how to do that?
Your guidance is highly appreciated. Thank you.