New Disk Addition to the DB tier

[Former Member]

We have 2 MSSQL DB's on a host and the corresponding SAP CI on another host. We want to replace the disks on DB host with a larger ones to accomodate for future growth. The existing DB's are on different drives(not logical volumes). I am just wondering if export/import is required or would it just be ok if we were to copy the DB and label them as they were before. Just want to know your thoughts.

Regards

Kalyan

[Former Member · Accepted solution]

If you are replacing the existing drives and cannot have the old and new drives on the server at the same time, this is a simple method:

1. Stop the SAP instance and services (disable them, so they don't try to start back up)

2. Detach the DB in SQL Management Studio

3. Perform OS-level backup or file copy of DB files and directory structure (to tape, network disk, or some other method off of the existing drives)

4. Shutdown server and replace the drives

5. Perform OS-level restore or copy back DB files and directory structure

6. Re-attach DB in SQL Management Studio

7. Start SAP services and Instance (remember to re-enable services, set automatic)

[Former Member]

Thanks very much guys for your answers. All went without a hitch to the point.

[Former Member]

I suggest stop apps and DB, shutdown your server. (drive name = volumes = drive letter (c:\ d:\ etc)

Add new disk and reboot your server in single mode (admin mode). This stage you can give new drive name (label) and copy all the content from old disk to new. make sure you compare the files, directories and size. When you are happy about all the content got copied then just rename the old disk drive name (label) to another and then rename the new drive name (label) to old drive name (which was your old drive letter).

then start your server and apps.