Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

EV 10 SQL Database volume restructure

Created: 05 Oct 2012 • Updated: 05 Oct 2012 | 1 comment
This issue has been solved. See solution.

Hi,

We have EV SQL databases including SQL system databases in H:\ drive which is currently a spanned Volume in windows 2008 R2.

We would like to restructure that H:\ drive by removing spans, can we do the following

Stop all EV services

Stop SQL service

Copy H:\* into a temp location

Delete H:\ spanned volume

Recreate H:\ using another physical disk

Copy back H:\* from temp location

Start SQL

Start EV

That should work fine?

Many Thanks

Comments 1 CommentJump to latest comment

ZeRoC00L's picture

Sure,

You can also add the new disk and copy the databases to the new volume. This will have a better fall-back senario as this will keep the 'old' location intact.

See this technote how to copy/move databases:

http://www.symantec.com/business/support/index?page=content&id=TECH35744

If this response answers your concern, please mark it as a "solution"

SOLUTION