Delete a .DAT file

[MissTipps]

I've just been handed a server which is in a very bad way, with little or no information on how it got that way. It has SQL Server 7.0 installed and it also appears to have a 6.5 Server registered (???) under Enterprise Manager (although this could well just be a name).

There is very little space on the hard drive and it has a 600MB .DAT file which has the same name as the main DB on the server. I am presuming that the DB was originally in SQL Server 6.5 and the .DAT is leftover from the upgrade.

Basically, I know absolutely zilch about 6.5 and my question is - can I delete the .DAT file?

Many thanks in advance of your assistance

Clare

 

[tlbroadbent]

SQL Server 7 can be installed without uninstalling SQL 6.5. Both cannot run at the same time but you can switch between the two. Look in the SQL Server Program group for a switch link. This will change which version starts when the SQL Server service is started.

If SQL Server 7 was installed in this way then the database may not have been upgraded. Howerver, it will only be useable when SQL 6.5 is running instead of SQL 7. If you have a backup of the DAT file and are sure only SQL 7 is running then delete the file. It can always be resored from backup if needed. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[MissTipps]

Thanks Terry. That helps a lot.

Cheers

Clare