Search This Blog

Sunday, October 11, 2009

upgrade a hard drive with sql server db on it

stop all sql services (SQL 2005) in services.msc. use shadow protect do a incremental, use an e-sata bracket to extend x226 servers internal sata connectors. attach Lacie 2BIGTB external drive to the e-sata connection. e-sata cable is different from internal sata cable. restore to drive using shadow protect. it awful slow restoring abour 40GB data to 500 GB hard drive (abour 3.5 hours). no re-sizing is manually needed.
change drive letters as the data drive is not the C: drive. its funny coz its first time a system is running on external hard drive.

No comments:

Post a Comment