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

[issforum-admin]

Dear All,   I have stopped the following services (IDS Server, RealSecure SiteProtector Sensor Controller Service, RealSecure SiteProtector Application Server, issDaemon).  However, when I try to detach the RealSecureDB by command line, then it still find out two users keep access to the DB.  Can somebody tell me how to get rid of that 2 users which connected to the RealSecureDB.   Thanks.   Best Regards,   Tony Wu   ----- Original Message ----- From: [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' Sent: Wednesday, July 16, 2003 10:21 PM Subject: RE: [ISSForum] How to move the realsecuredb to other partition - Stop all RSSP components (Appserver, SensorController, EventCollector). - Using Enterprise manager, go to Management | SQL Server Agent | Jobs. Disable all jobs in the "ISS_GO" category. - Check in Management | Current Activity | Process Info for any other active sessions on the SP database. Kill them if necessary. - Move the database.   If you run into trouble because the paths changed between attach/detach, you can always run a backup followed by a restore "WITH move", specifying new data/log locations. This can be done in the GUI or using SQL like this:   RESTORE DATABASE [database] FROM DISK = 'D:\Backup\XXXXXX.bak' WITH MOVE '[dataname]' TO 'XXXXX_Data.mdf', MOVE '[logname]' TO 'XXXXX_Log.ldf'     Regards, Robert -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 03:55 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