|
Tony,
Well,
find out what these two connections are, decide whether you are comfortable
forcing them out by killing them there and then, or if you want to go to the
source (a user machine, a RSSP component or whatever it is) and try to terminate
it there instead. I can't be any more specific that than unless you provide some
information on what these two connections are, and if there's some particular
concern to address.
Good
luck,
Robert
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 -----
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
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
|
