converting db from single data file (.mdf) to multiple files (.mdf + .ndf)

Last Post 12 Feb 2007 03:15 PM by janus007. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
janus007
New Member
New Member

--
12 Feb 2007 03:15 PM
I know exactly what you want to accomplish... It's a bit strange, but it seems impossible to do within EM or sp's

However, the way I normally do it, is detaching the database, copy the datafiles and transactionlogs to some available storage. Then I go create a new database with all the required filegroups and then import all data from the backup storage.

Not an easy operation
You are not authorized to post a reply.

Acceptable Use Policy