Using MSDE logging, and my log drive is full now. I do have it set to drop old files as space is needed, but I think it would be better to archive old files in case they're needed sometime.
How can I export the MSDE files? Is it just a matter of moving the files? Since they (apparently) can only be read in ISA's MSDE, I would think that would be a problem?
And, as a side note, do most of you compress you log folder? Does compressing the entire log folder cause performance problems?
where it talks about detaching files only if they are not in use........so by using:
OSQL -S computer_name\MSFW -E sp_who2 go
That will tell me which ones I can safely archive without having to detach them, right?
Next question, lets say I archive the old files ok, but 6 months from now an issue comes up where I have to pull info from the old files, whats the most common means of handling this?
you can't (read: shouldn't) compress MSDE databases. if you simply use SQL enterprise manager on the ISA2004 MSDE, you can detach databases at will, the detached databases behave just like normal SQL databases, meaning if you want to open one, simply use SQL enterprise manager to attach them to a SQL server then you can open them (eg with access, or with SQL EM).
Thanks, I'm not sure how to do that. In looking at log names, they have different dates, but are are modifyed recently. Apparently MSDE 'works with' all the files. Am I to assume then, that it is all the files are ONE database?
I'll have to find some reading material and see if I can figure it out.
Not at all sure MSDE was a good idea, for me.
What I wanted, was to basically have all the data dumped into a Access database, and then use that to archive, query.
There's a post on the forums explaining how to do that, but I was never able to get it to go.
Posts: 5
Joined: 31.Aug.2005
From: United Kingdom
Status: offline
Did anyone ever answer this? I too would like to know how to "archive" the firewall and proxy MSDE logs. There appears to be nothing in the ISA Server 2004 book to say how to do this? There must be a way.
Yeah, I'm in the dark here. There is this: http://www.microsoft.com/sql/msde/ default.mspx but I thought ISA MSDE was a stripped down or otherwise modified version of MSDE, so I'm not sure that site even applies.
There is this: (watch wrap) [URL=http://groups.google.com/group/microsoft.public.isa/browse_thread/thread/4c3f1022acbfa192/ 70a21bb4596b9f2f?lnk=st&q=isaserver+msde+archive&rnum=2&hl=en#70a21bb4596b9f2f]http://groups. google.com/group/microsoft.public.isa/browse_thread/thread/4c3f1022acbfa192/70a21bb4596b9f2f? lnk=st&q=isaserver+msde+archive&rnum=2&hl=en#70a21bb4596b9f2f[/URL]
But, it appears to me that ALL the MSDE files are one DB. Therefore, detaching the DB and archiving it would work, but then I'm starting with a fresh DB, and wouldn't have the last few days, weeks, available for searching within ISA.
What I'm looking for, is a way of archiving ONLY the oldest data, up to a certain date.
thing is, I tried this many times over the past week or two, it finally worked, don't know why. Before, I was always getting an error something along the lines of "error on line 1, close to the -S" (something like that). All of a sudden, it worked!
Exported (detached) several, then had that same error again. Tried again, and worked again. I don't know why I was having the problem before. I know I looked and looked to double check my typing. Shrug
Now, I've got about 6 months worth of .mdf files to detach/export. Sigh