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
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