attach/dettach - Error

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  January 26, 2009 at 9:50 am

  #199242

  I dettached a db where it has 85 ndf files, and when i tried to attach it it gave me an eror:

  mdf is not a primary database file. Microsoft SQL SErver, Error: 5171

• Mr James Howard

  Ten Centuries

  Points: 1158

  More actions

  January 26, 2009 at 10:27 am

  #932703

  Did you try sp_attach_single_file_db ? fingers crossed that it works...

  Have you any backups?

  James Howard