• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

SQL Server Database Storage Migration Issue

Greetings,

We have a issue that involves a very import standalone SQL Server 2008 database server that resides on USP storage that we wish to migrate to USP(Hitachi) storage on a cluster. Well our Sys ADmins says we cannot migrate to the cluster because the cluster will not recognize dynamic disk. The data on these disks total 11TB in size.  If we manually attempt to copy this data it would take us days. Do you have any solution for this issue?
0
Omega002
Asked:
Omega002
  • 3
  • 2
3 Solutions
 
EvilPostItCommented:
You could backup and restore, also bear in mind that with SQL 2008 you can use backup compression which would minimise the volume of data.

Another option would be to attach the SAN disks which will be used on the cluster to the current standalone system, then copy the data files across to the disks and then re-attach them to the new cluster and attach the db.
0
 
Omega002Author Commented:
It's 11tb and we only have a 7 hour maintenance window so we need a quicker method
0
 
EvilPostItCommented:
Unfortunately there is no other option as you are changing the location of the data.
0
 
Omega002Author Commented:
Can we restore the databases to cluster and replicate from standalone server as a solution?
0
 
EvilPostItCommented:
You could take a full backup, then while you are restoring carry on taking transaction log backups and restore those as they are done.

This would minimize the downtime.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now