Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-07-04 : 11:39:53
|
| I have about 10-15 tables to transfer on a weekly basic to a new database. Approx 7GIG per table.Any suggestions as to best method. BCP .Is it possible to put them on their own FILEGROUP then restore just one FILEGROUP.Cheers. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-04 : 12:54:41
|
| You can use Export/Import wizard. Yes you can put them in own FG. |
 |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-04 : 17:14:08
|
| yes a OWN FileGroup Just sounds good. But you can even use IMPORT/Export or the best way is BCP. [Load the Data in Chunks.]Other way will be use a SSIS package, scheduled in a JOB.ManinderDatabase Painter.. Leaving strokes, that amaze! and inreturn, put value to your Work. I am a Database [Architect / Administrator] |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-07-04 : 18:33:51
|
| I have actually restored just a FILEGROUP - just read it somewhere can you just restore the FILEGROUP for backup and nothing else.Import/Export - that loses all indexes so i have to rebuild after is that correct.BCP - that use log space? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 19:57:21
|
| If you use copy object task in ssis, you can copy indexes and others. But 7g is too big to copy. Bcp doesn't use as much log as insert does.If you put all related tables in that file group, you are fine to just restore that file group. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-07-05 : 07:50:52
|
| Great i will go experiment with the FILEGROUP. Is it easy to just move the table from it existing filegroup to the new one...and any pointers on the restore just one FILEGROUP that be terrific .Interesting. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-05 : 22:51:45
|
| Just rebuild clustered index on new file group, that will move whole table over. Check books online for filegroup restoring. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-07-06 : 08:35:43
|
| I will look into cheers. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-07-06 : 09:20:32
|
| Got it working - Thanks. |
|
|
|
|
|
|
Transfer large tables to new Database