Replacing a disk array

[Harrison Midkiff]

Hello:

I have a server running SQL 2000. The disk array where the data resides has
been filling up. I need to upgrade the array to give it more space. I am
pretty sure the procedure should be:

1. Set SQL services to manual and reboot the server.
2. Backup the disk array (databases)
3. Upgrade the disks and re-create the array with the disk using the same
drive letter.
4. Restore the disk array backup (databases)
5. Set SQL services to auto and reboot the server.

I am pretty sure this is the procedure. Does anyone have any input or know
of a white paper which might cover this?

Harrison

 

[Vincent Xu [MSFT]]

Hi Harrison,

Thanks for using Microsoft Technet Newsgroup.

I have seen the same posts posted by you in Sql Newsgroup for three times
to which I have already replied. I hope you have seen that. I do understand
you are pretty sure of the process of replace disk array and I also think
the steps are good.

From SQL side, regarding how to backup& restore database, I'd like to
provide following article for reference:
How to: Create a Full Database Backup (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms191304.aspx

How to restore a database backup (Transact-SQL)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht
_7_backpc_4zzt.asp

Hope it helps. Let me know if you still have concerns.

Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------