Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Files in MDF

Author  Topic 

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2014-02-17 : 19:07:07
I have to create a database where it has got main.mdf and associated with other MDF's such as M1,M2, M3 and M4 and is by default pointing to Main.MDF file + LDF file.

when I try to restore I have created a database where I was not sure as to should I create the above multiple M1 - M4 Mdf files on the new database

What shall I have to do with multiple MDF's associated to restore where it comes with M1 - M4 MDF files for the restoration as it got error WITH MOVE to be suggested to relocate.

Can anyone help, thanks
   

- Advertisement -