I have taken a backup from my production MS SQL Server 2000 database and the file name is salesOrders.bak.
In SQL Server 2008 Management Studio, I created a database, SalesOrders using the wizard. On database right clicked and Tasks and Restore from File group and selected the above mentioned .dat file.
After selecting the SalesOrders.back file, I did select the option to replace the database.
It is not allowing me to restore and I am getting the error that the backup contains more than one database error 3154.
I would really appreciate if you can help in this regard.
I did search in the internet and I am not able to find a good solution for this.
I would really appreciate your help..