RE: [ISSForum] How to move the realsecuredb to other partition

[issforum-admin]

Hey Tony,   Stop everything:   IDS server Issdaemon Realsecure sensor controller Realsecure application service   Sql server Sql server agent   Now restart only sql server and its agent and then detach, move it, and reattach.   Stopping Sql clears its use of the db.  Stopping RS services is just my personal paranoia from experience.   Peace, sakaba       -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 11:55 AM To: [EMAIL PROTECTED] Subject: [ISSForum] How to move the realsecuredb to other partition Importance: High   Dear All,   I am using Site Protector 2.0 with MS SQL 2000 SP3, and I want to move the RealSecureDB.MDF and RealSecureDB_log.LDF to the other partition, and I have try the following command by Query Anayiz:   Stop the issDaemon, and then   1) use RealSecureDB 2) go 3) exec sp_detach_db RealSecureDB 4) go 5) Error: Server: Msg 3701, Level 16, State 3, Line 1     Cannot detach the database 'RealSecureDB' because it is currently in use.   Second Mehtod:   I try is by Enterprise Manager, and then right click the DB 'RealSecureDB' > choose 'All Task' >  choose 'Detach Database' > and then I will see a prompt up screen with the following information:   Connections using this database: 5   Therefore I can not click OK.   Please tell me how to stop all connection from the service which will use this database.   Thanks   Best Regards,   Tony Wu