Migrate db and creating new file group | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Migrate db and creating new file group

Hi,
I would plan to migrate my db to another server, current configuration with only Primary & indexes file group exits in the db
and now I want to have more filegroup and plan to relocate the table into specific file group. My questions: 1: Can I migrate the existing data in primary filegroup to new filegroup?
2: Will my table structure will copy over to new file group
3: Will I’m looosing any indexes while puting the existing data into new file group?
4: Wat else need to be under my considerations?
Yes you can do that by taking full backup from source server and restore it on target server, then follow the steps definedhttp://sqljunkies.com/How To/B9F7F302-964A-4825-9246-6143A8681900.scuk in this link. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>