Restoring DB using a .dat file

[Nelson Winters]

I have a .dat file from a SQL Server 6.5 database and am trying to restore it on my server. Any help would be greatly appreciated. If you need more information, please let me know. If it`s not obvious, I`m new to SQL Server so try not to gloss too much over the details.

Thanks,

Nelson

[Alex]

Hi

1. Be sure that your destination SQL server has the same sort order and codepage as source SQL server (and the same platform, for example Intel).
You can determine sort order and codepage by command:
load headeronly from disk=`D:MSSQLDATAcmtest_data.DAT`

2. Create new database with size not less than dumped database.

3. Load dump file:
load database MyDB from disk=`D:MSSQLDATAcmtest_data.DAT`

Bye
Alex

On 8/25/98 8:53:02 PM, Nelson Winters wrote:
> I have a .dat file from a SQL Server 6.5 database and am trying to restore
> it on my server. Any help would be greatly appreciated. If you need more
> information, please let me know. If it`s not obvious, I`m new to SQL
> Server so try not to gloss too much over the details.

Thanks,

Nelson

[Nelson Winters]

Thank you!!!

I have another question. Apparently my .dat file "is not in valid dump database format", to quote the error message that I received. I`m not the person creating the dump file, but would like to be prepared to offer assistance. So, how does one properly perform a database dump with the intent of loading it on a totally separate SQL Server?