Skip to main content
2 of 2
added 113 characters in body
Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619

Well, did you try:

create database test1 on primary 
  ( filename='C:\test.mdf'), 
  ( filename='C:\FG1_lt_4000.ndf'),
  ( filename='C:\FG2_4000_8000.ndf'),
  ( filename='C:\FG3_8000_inf.ndf'),
  ( filename='C:\test_log.ldf')
for attach;

And yes, you do need to copy the ndf files as well. These are critical parts of your database, not garbage.

Otherwise, go back to your original server, take a backup, and then do a restore with move on the new server.

Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619