RE: MSDE

  • From: "Jim Harrison" <Jim@xxxxxxxxxxxx>
  • To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
  • Date: Wed, 22 Dec 2004 22:32:46 -0800

BTW, is anyone interested in a script to disconnect the databases that
are 30 days old?
If you're like me, you try to keep every log you ever generated.
The bad news is that this behavior will eventually choke your ISA.
Needless to say, I have a script that, run daily (scheduled task), will
prevent this behavior (although it limits your log queries to 30 days in
the past).

  Jim Harrison
  MCP(NT4, W2K), A+, Network+, PCG
  http://isaserver.org/Jim_Harrison/
  http://isatools.org
  Read the help / books / articles!
 
 

-----Original Message-----
From: Jim Harrison [mailto:Jim@xxxxxxxxxxxx] 
Sent: Wednesday, December 22, 2004 10:24 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: MSDE

http://www.ISAserver.org

Your ISA-local-only osql connection is thus (typed exactly):
osql -E -S%ComputerName%\msfw

It only accepts secure login (SSPI) and you have to specify the
server\instance as above.
After that, you should be jes' fine, jes' fine.

  Jim Harrison
  MCP(NT4, W2K), A+, Network+, PCG
  http://isaserver.org/Jim_Harrison/
  http://isatools.org
  Read the help / books / articles!
 
 
-----Original Message-----
From: josephk [mailto:josephk@xxxxxxxxx] 
Sent: Wednesday, December 22, 2004 1:05 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] MSDE

http://www.ISAserver.org


Hi Jim,

 

How come the T-SQL command sp_attach_db with appropriate stuff won't
allow attachment to the db?

I've been working on some utilities to extract the information I need
and I'm unable to attach.

What I can do is shut down the services on my ISA box and then copy the
Db's and look 

At them one at a time.  And what is the default SQLDB name(instance)
MSSQL$MSFW? 

 

Thank you,

 

Joseph

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx 

All mail to and from this domain is GFI-scanned.


------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

All mail to and from this domain is GFI-scanned.



Other related posts: