October 21, 2008 at 12:08 pm
We have a server with 4 internal drives, about 750 G total of SQL databases spread over E (200 G) and F (600 G) drives. We want to remove the E drive and replace it with a 400 G drive (keeping it as E of course).
Here's my rough draft of a plan .... any glaring errors, ommisions etc ... ?
1) Terminate active SQL Connections
2) Put SQL Server in Restricted User Mode
3) Run FULL Backups of ALL DBs incl ones on F
4) Run DIFF Backup of 650 G database - I will not have time to run a FULL
5) Detach SQL Databases on E:\ drive
6) Copy all data files on E to another storage device N:\ (All System DBs are on F)
7) After copying data files, Stop SQL Services and set to Manual
8) Power down SQL server - (Network Admin)
9) Remove old hard drive - (Network Admin)
10) Insert new hard drive - (Network Admin)
11) Restart SQL server - (Network Admin)
12) Format new drive as E - (Network Admin)
13) Copy all data files back to E
14) Start SQL Services, set to Automatic
15) Reattach databases
16) Verify that databases are accessible & readable
17) Reboot application servers connecting to DB2
18) Verify applications can connect to databases
We are not replicating, clustered or log shipping.
Thoughts ?
October 21, 2008 at 2:36 pm
nice that you backup all database in case the hardware breaks (we had one by a defect harddisk shortcircuiting the san-backplane)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply