restore .dat

  • Thread starter Thread starter nik
  • Start date Start date
N

nik

Hi,

I have a .dat file, which I have been told to restore to sql server.

Using the SQL server Management Studio Express:
I right click and choose Restore Files and Filegroups
Put in a database name
Select the .dat file as a device
hit OK

I get an error:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.Express.ConnectionInfo)
The media set has 2 media families but only 1 are provided. All
members must be provided. RESTORE DATABASE is terminating abnormally.
Microsoft SQL Server, Error: 3132


I've read that the problem may be that I have 2 destinations
specified. But I don't know what that means or how to fix it and only
specify 1.

Thank you for your help,
Nik
 
Hi,

I have a .datfile, which I have been told to restore to sql server.

Using the SQL server Management Studio Express:
I right click and choose Restore Files and Filegroups
Put in a database name
Select the .datfile as a device
hit OK

I get an error:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.Express.ConnectionInfo)
The media set has 2 media families but only 1 are provided. All
members must be provided. RESTORE DATABASE is terminating abnormally.
Microsoft SQL Server, Error: 3132

I've read that the problem may be that I have 2 destinations
specified. But I don't know what that means or how to fix it and only
specify 1.

Thank you for your help,Nik
Click to expand...

PS. The .dat file is supposed to be the backend for Access, that's why
I've posted here.
 
Back
Top