Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 no logs - howto ?

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,
Fabian

my 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 Athalye
India.
"Nothing is Impossible"
Go to Top of Page

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,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page

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 Athalye
India.
"Nothing is Impossible"
Go to Top of Page

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.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-27 : 09:57:22
what the hell is this? For security reasons?

Are you talking about money laundering or something?

The answer is no, it don't work that way



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

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,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page

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
Go to Top of Page

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,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page

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
Go to Top of Page

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,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !



Just store the transaction logs in the same secure place you store the backups.



CODO ERGO SUM
Go to Top of Page

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
Go to Top of Page

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 Larsson
Helsingborg, Sweden
Go to Top of Page

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,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page

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 Larsson
Helsingborg, Sweden
Go to Top of Page

fabianus76
Posting Yak Master

191 Posts

Posted - 2006-11-27 : 13:47:56
Hi Peso,
thanks for that information !
Hmm, what to do.

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page

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 !
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-27 : 14:27:48
You haven't stated why this is even an issue. who are you trying to hide data chnages from?

And I can only say what you are trying to do is a bad idea



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

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,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page

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,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !



Your last name wouldn't happen to be Pascal would it?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

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 Optimizer
TG
Go to Top of Page
  Previous Page&nsp;  Next Page

- Advertisement -