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