September 10, 2010 at 3:40 pm
Hello to all,
Thank for your time also thanks for just reading and if you offer any or no help i am sure your time alone is worth me saying thanks =] Soooooo here we go
I have an environment that we will need to move approx 1.5 TB of data the network is good so the transfer is about 12- 14 hours . My situation is this..
Server A is production drives D thru G using SAN storage and netapp snapmirror backup infrastructure
Server A also has SAN drives W thru Z as temp drives to move D thru G and then rename after all data has been moved. example is below
D:\mssql\data\test.mdf --> W:\test_data\test.mdf
D:\mssql\logs\test.ldf --> W:\test_log\test.ldf
E:\mssql\data\hello.mdf --> X:\hello_data\hello.mdf
E:\mssql\data\hello.ldf --> X:\hello_log\hello.ldf
etc for approximately 25 different databases and most broken down like this so that not only the drive letter changes but the path does as well(this is the part thats killing me).
Also this same this will go on with the system databases and tempdb will have its own LUN set and the other 3 will share a new space. ok ok so now it gets really interesting :w00t:
After we make all this happen and have everything over to the W thru Z drives those drives will then be remounted as D thru G by the storage team. I would like to know if anyone has done anything similar to this and what are your thoughts on it. Also the main question is what software would you use to move your data at the BLOCK level to do this and with the idea that downtime has to stay minimal(under 6 hours) therefore we are looking at using something that will move data while the SQL Server is up and running. Just a lil more info i am hoping to find something that will copy at a one to many style data move. I think my biggest issue is moving the data while sql is running then resyncing after the fact to pull over the missed transactions while i am in the downtime period. any thoughts would be appreciated. Thanks
DHeath
September 10, 2010 at 4:04 pm
Hi Dheath,
You can use Synchronous SAN Based Replication to copy the Blocks of Data while the SQL server is up and runing.
Thank You,
Best Regards,
SQLBuddy.
September 10, 2010 at 4:20 pm
do you know of a particular software program that you could recommend or have experience with if so please share =]
Thanks
DHeath
September 10, 2010 at 4:47 pm
SAN Based replicated s/w product is from EMC.
Thank You,
Best Regards,
SQLBuddy
September 13, 2010 at 2:29 pm
Hello there,
the software today and it states is for “high-speed data mobility, migration, and protection between EMC CLARiiON networked storage and qualified storage systems” Since we don’t have clariion involved at all here, this idea is not going to work..Thanks very much any other ideas?
thanks so far all ideas appreciated and looked into =]
DHeath
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply