How do I move the MDF and LDF files for the SMCubeDepot? (NETIQKB70762)

  • Document ID:7770762
  • Creation Date:13-Nov-2007
  • Modified Date:06-Apr-2012
    • Micro Focus Products:
      Security Manager

Situation

How do I move the MDF and LDF files for the SMCubeDepot?

Resolution

1. Open Microsoft SQL Server Management Studio

a. Access the SQL 2005 Database server
b. Click Start | All Programs | Microsoft SQL Server 2005 | SQL Server Management Studio
c. The Server Type will be Database Engine, supply the appropriate credentials and click Connect
d. Expand Databases

2. Detach the SMCubeDepot

a. Select the SMCubeDepot database
b. Right-Click the SMCubeDepot database, select Tasks and click Detach
c. Check Drop Connections and check Update Statistics
d. Click OK


3. Move the MDF and LDF Files

a. Open Windows Explorer
b. Browse to the directory holding the SMCubeDepot MDF and LDF files (Default: \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)
c. Move the SMCubeDepot.mdf and the SMCubeDepot.ldf files to the destination directory

4. Attach the SMCubeDepot MDF file

a. Open Microsoft SQL Server Management Studio
b. Right-Click Databases and click Attach
c. Click Add
d. Browse to the destination directory, select the SMCubeDepot.mdf file and click OK

Additional Information

Formerly known as NETIQKB70762