Solved

How to restore the .dat file in SQL server 6.5?

Posted on 2004-04-14
4
700 Views
Last Modified: 2012-05-04
Hi.

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:

disk reinit
name = "Master",
physname = "C:\t\TX20021101.dat",
vdevno = 2, size = 5120
DISK REFIT

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.
0
Comment
Question by:Applek
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 10823179
Try posting in a more appropriate Topic Area, such as http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/
0
 
LVL 39

Expert Comment

by:appari
ID: 10823375
go through this link

http://docs.rinet.ru/MSSSSSSQL/ch19/ch19.htm

search for this topic "Using and Understanding Information Restoration from Backups" in the page.

you can always install a sample test  database and test it before doing it on production DB.
0
 

Author Comment

by:Applek
ID: 10829221
Thanks for the reply.

I know how to backup and restore in SQL server 2K. We have another outdated server which is going to retrieve the history data from SQL server 6.5. Now we have a lot of .dat files and how to retrieve it? I understand that the SQL server 2k restoration cannot restore those data files (.dat) unless we upgrade the server 6.5 to 2k, or restore it in the server 6.5 since some of the command only can be executed in the server 6.5.

Do you have any idea as i'm saying SQL server 6.5?

pls comment
0
 
LVL 39

Accepted Solution

by:
appari earned 250 total points
ID: 10829345
the link in my previous post is a book on SQLServer 6.5, "Special Edition Using Microsoft SQL Server 6.5 Second Edition
". you can see how to restore data in sql 6.5


0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question