SQL Server Performance Forum – Threads Archive
Migrate db and creating new file groupHi,
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.