Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Changing Data and Log device storage locations for HDS DB

Hello,

I need to move an already existing/operating HDS databases from C:\ drive to D:\ drive that has more space. I mean by this changing the Data and Log device storage locations to the new drive D:\.

The procedure from Microsoft (http://support.microsoft.com/kb/965095) says:

  • Make a backup of all DBs including master
  • Take the DB offline
  • Stop SQL server Agent
  • Detach the DB
  • Move the files to the new location
  • Reattach the DB

While a procedure posted on this forum (https://supportforums.cisco.com/docs/DOC-15284) says:

In order to change the Data and Log device storage location, you have to recreate the database using ICMDBA tool!  You can then select the desired Data and Log storage drive.

1.    Backup the Database (right click on database > All Task > Backup Database)

2.    Backup the .mdf and .ldf files for the database, stored in the current device location (<drive>\mssql\data).  In order to copy/paste the .mdf and .ldf files, you have to do the following:

a.    Stop Distributor or Logger service (depending on which database you’re working on).

b.    Using Enterprise Manager or SQL Server Management Studio, take the database offline (right click on the database > All Tasks > Take offline)

c.     Copy the .mdf and .ldf file, stored in the current device location (<drive>\mssql\data), to the newly specified location (<new drive>\mssql\data).

d.    Using Enterprise Manager or SQL Server Management Studio, bring the database online (right click on the database > All Tasks > Bring online)

3.    Once you have backed up the database and the .mdf and .ldf files, you can delete the database (right click on database > All Task > Delete)

4.    Create new database using ICMDBA tool.  Here, you can specify the new storage location of the Data and Log devices!

5.    Using Enterprise Manager or SQL Server Management Studio, take the database offline (right click on the database > All Tasks > Take offline)

6.    Replace the newly created .mdf and .ldf files, in the newly defined drive, with the ones that were recently backed up.

7.    Using Enterprise Manager or SQL Server Management Studio, bring the database online (right click on the database > All Tasks > Bring online)

8.    Start Distributor or Logger service (depending on which database you’re working on).

Is it necessary to delete and recreate the DB? As per the customer's SQL expert, the Data and Log file location should be transparent to the application and should be changed from SQL Management Studio without any issue.

Is the first procedure recommended?

Thanks,

Justine.

337
Views
0
Helpful
0
Replies
CreatePlease login to create content