Sunday, February 19, 2012

File Groups: moving a large table

We have recently added a new file group and file on a new drive. We have tested it by moving a small table to the new file group. We would like to relocate a new table to this file group but the table is about (we estimate) 75GB. My question is this: How long can we expect the transfer of data from the current file group to the new one for this table? I understand that depending on our hardware the answer may vary but does anyone have a rough estimate?

The current current (primary) file is located on a DELL SAN and the new secondary group is on a EMC 4700 both are connected via fiber channel.

Also a bonus question would be: Does a "normal" database backup created as a maintenance plan backup the seconary data as well into the BAK file?

Like I said a rough estimate is fine.

Many thanks,

Scott

Well, 75 GB of data to move, 1 GB dedicated NIC/SAN. Unknowns include: amount and complexity of indexing, other demands on the server and SAN...

With little other activity, my WAG* is that you will be involved for at least 2-3 hours -and it could go up quite a bit if there are a lot of indexes and other demands on the SAN pipe.

Best widow of opportunity -NOT 9-5, Mon-Fri!

Yes, a 'normal' FULL backup will backup all files for the database.

(With my two points, I would like to buy a vowel please...)

* Wild A$$ed Guess

|||Thanks Arnie!
|||Should be noted that the process will halt if the log file grows larger that the disk it lives on can handle.

pingcarlo@.gmail.com
pingchuck@.hotmail.com
pingccat@.yahoo.com

No comments:

Post a Comment