How do I move the 'Onepoint' and 'smauditdb' database to a different drive? (NETIQKB11349)

  • Document ID:7711349
  • Creation Date:02-Feb-2007
  • Modified Date:27-Aug-2007
    • Micro Focus Products:
      Security Manager

Resolution

goal
How do I move the 'Onepoint' and 'smauditdb' database to a different drive?

fact
Security Manager 3.x

fact
Security Manager 4.x

fix

To move the 'Onepoint' and 'smauditdb' database to a different drive, please refer to the following steps:

  1. Stop the 'Onepoint' service and 'MSDTC' service on all consolidators.
  2. Stop the 'Onepoint' service on the database.
  3. Create target a folder.
  4. Set the following databases to single user mode:  'Onepoint' and the 'smauditdb'.
  5. Detach both databases.
  6. Move the data files to the new location.
  7. Attach 'Onepoint' and 'smauditdb':
    1. To attach onepoint:
      • EXEC sp_attach_db @dbname = N'onepoint', @filename1 = N'pathtofile\EeaData.mdf', @filename2 = N'pathtofile\Eealog.ldf'
    2. To attach smauditdb:
      • EXEC sp_attach_db @dbname = N'smauditdb', @filename1 = N'pathtofile\SMAuditData.mdf', @filename2 = N'pathtofile\SMAuditlog.ldf'


Additional Information

Formerly known as NETIQKB11349