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

[issforum-admin]

Title: Nachricht

Stop the issdaemon on the DB & the RSSP Console + AS on the AS machine - this should solve it...   -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 04:55 An: [EMAIL PROTECTED] Betreff: [ISSForum] How to move the realsecuredb to other partition Wichtigkeit: Hoch 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     Please note that: 1. This e-mail may constitute privileged information. If you are not the intended recipient, you have received this confidential email and any attachments transmitted with it in error and you must not disclose, copy, circulate or in any other way use or rely on this information. 2. E-mails to and from the company are monitored for operational reasons and in accordance with lawful business practices. 3. The contents of this email are those of the individual and do not necessarily represent the views of the company. 4. The company does not conclude contracts by email and all negotiations are subject to contract. 5. The company accepts no responsibility once an e-mail and any attachments is sent. http://www.integralis.com