Author |
Topic |
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-11-27 : 09:11:31
|
Hello, I would like to avoid any logs. Meaning that logs are cleared ones transactions are executed successfully. Is there any way to achieve this?Thanks for any feedback!Regards,Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-27 : 09:30:22
|
You can set your database recovery model to Simple recovery which will reclaim log space but not recommended on Production database.If your database recovery model is Full Recovery, you need to regularly backup transaction logs to truncate it.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-11-27 : 09:37:42
|
Hello Harsh Athalye, thanks for your reply. In fact I do not want any logs at all. This is because in the logs someone might trace back changes that were made to the data, but for security reasons I do not want this. So what I am looking for is the avoid any storage of logs which concern transactions that are terminated. See what I mean?Thanks for any further advice. Regards,Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-27 : 09:42:55
|
I am afraid that is not possible. Transaction log is the back-bone of the RDBMS without which you are not safe at all in case of DB failure.That's the weirdest thing I have ever heard...Why you want to do this?Harsh AthalyeIndia."Nothing is Impossible" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-11-27 : 09:45:37
|
TLogs are not there for security....other than your own job security when the database goes belly up.1. Put in a proper security model 1st, locking down the server, database, drives and backup media.2. Backup the DB + truncate the TLogs as often as you can afford. Skip this step if you have "excellent" job security.3. TLogs are NOT easily readable....unless you purchase (or develop) a specialist product...not buying same, will minimise the options for people to read the TLog contents. |
|
|
X002548
Not Just a Number
15586 Posts |
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-11-27 : 11:24:46
|
Hi Brett, what I want is to have no trace about changes that were done on the data. In the logs these traces exist, that's why I want to avoid them - if possible - once transactions are acomplished with success. Regards,Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-27 : 11:54:36
|
so what happens if your db gets corrupted or something similar?and you don't have any logs to get your data from?then what?Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-11-27 : 12:05:25
|
Hi Spirit1, I'll do backups, that I store at a secure place. But I do not want the logs to exist on the production server. See?Regards,Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-27 : 12:11:57
|
so what happens if you take a backup once every week and you db craches 4 hours before scheduled backup?you're screwed.Transaction logs aren't your problem here.your SQL Server shouldn't be open to the world anyway. put it behind a firewall and ighten security on it.Why are you so stubborn on these transaction logs?Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-11-27 : 12:14:47
|
quote: Originally posted by fabianus76 Hi Spirit1, I'll do backups, that I store at a secure place. But I do not want the logs to exist on the production server. See?Regards,Fabianmy favorit hoster is ASPnix : www.aspnix.com !
Just store the transaction logs in the same secure place you store the backups.CODO ERGO SUM |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-27 : 12:15:57
|
now, why didn't i think of that?? Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-27 : 12:21:47
|
And that approach must be really, really, fast too!Peter LarssonHelsingborg, Sweden |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-11-27 : 13:32:45
|
Hi Spirit1, see, I have an application where a (very rare) crash is less problematic than having any information about the changes done on the data left in the logs. That's how things are in my case, and that's why I am looking for a solution on how to get rid of them as fast as possible without the necessity to do a backup. If this is not possible, I'll use Access for this specific case :-(Thanks, Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-27 : 13:43:10
|
Access is even worse since old records are not deleted, just marked/flagged as deleted.With a simple text editor, it is very easy to see the old records.Peter LarssonHelsingborg, Sweden |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-11-27 : 13:47:56
|
Hi Peso, thanks for that information ! Hmm, what to do.Regards,Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-11-27 : 14:01:53
|
one way would be to do backups every x minutes in my prog, and then erase the backup file :-)my favorit hoster is ASPnix : www.aspnix.com ! |
|
|
X002548
Not Just a Number
15586 Posts |
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-11-27 : 14:38:07
|
Hi X002548, "who are you trying to hide data chnages from?"Anyone who could have access to db. Once the changes done I do not want them to be traceable. It's not more complicate than that. Regards,Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2006-11-27 : 15:13:05
|
quote: Originally posted by fabianus76 Hi X002548, "who are you trying to hide data chnages from?"Anyone who could have access to db. Once the changes done I do not want them to be traceable. It's not more complicate than that. Regards,Fabianmy favorit hoster is ASPnix : www.aspnix.com !
Your last name wouldn't happen to be Pascal would it?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-11-27 : 15:16:32
|
>>I would like to avoid any logs. Meaning that logs are cleared ones transactions are executed successfully. Can we just confirm you are talking about the internal sql server transaction logs and not your own audit tables? Either way it sounds like you're planning something mischevious at best. What specific problem are you trying to solve?Be One with the OptimizerTG |
|
|
Next Page
|