issforum-adminiss.net
Date: Wed Jul 16 2003 - 21:12:41 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

-----Original Message-----
From: issforum-adminiss.net [mailto:issforum-adminiss.net]
Sent: 17 July 2003 01:40
To: issforumiss.net
Subject: Re: [ISSForum] How to move the realsecuredb to other partition
Importance: High

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: issforum-adminiss.net <mailto:issforum-adminiss.net>
To: 'issforumiss.net' <mailto:'issforumiss.net'>
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: issforum-adminiss.net [mailto:issforum-adminiss.net]
Sent: 16 July 2003 03:55
To: issforumiss.net
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
 
 

_______________________________________________
ISSForum mailing list
ISSForumiss.net

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]