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 |
|
rlaubert
Yak Posting Veteran
96 Posts |
 Posted - 2008-09-26 : 13:30:21
|
| I have an application database that has a table for attachments that is approxmately 106GB in size. I want to move this table to another DB on the same server. This table is use mainly to insert copies of documents that are seldom read once archived.Once the data has been moved and verified, the old table will be removed from the database. I am looking for the fastest way to move the data or table. Any suggestions?Raymond LaubertMCSE, MCDBA, MCITP:Administration, MCT |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-26 : 13:36:27
|
| Any important Reason to move Huge table? How many indexes does table have?Well you can use Export/Import Wizardor BCP with limited batchsize so you don't fill up Trasaction log. |
 |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2008-09-26 : 15:01:55
|
| Indexes will be dropped and new ones created once the move is completed. We are moving the table out of the database to reduce the access time for information. Since the system reads the attachments which are 1MB plus but doesnt display them we can reduce the disk reads. Also reduces the backup time since the actual database is only 35 GB without the attachments.Raymond LaubertMCSE, MCDBA, MCITP:Administration, MCT |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-26 : 17:56:29
|
| Well, It will still reside on same server.Well you can transfer that table and its indexes to different disk with read intensive to reduce I/O contention.If you transfer table,you have shrink database for original DB .Your backup time will increase on NewDB because of that Huge table. |
|
|
|
|
|
|
Need to move table from one DB to another