SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 no logs - howto ?
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

fabianus76
Posting Yak Master

191 Posts

Posted - 11/27/2006 :  09:11:31  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
5509 Posts

Posted - 11/27/2006 :  09:30:22  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
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 - 11/27/2006 :  09:37:42  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
5509 Posts

Posted - 11/27/2006 :  09:42:55  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

Ireland
2916 Posts

Posted - 11/27/2006 :  09:45:37  Show Profile  Reply with Quote
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 - 11/27/2006 :  09:57:22  Show Profile  Reply with Quote
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 - 11/27/2006 :  11:24:46  Show Profile  Reply with Quote
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

Slovenia
11750 Posts

Posted - 11/27/2006 :  11:54:36  Show Profile  Visit spirit1's Homepage  Reply with Quote
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 - 11/27/2006 :  12:05:25  Show Profile  Reply with Quote
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

Slovenia
11750 Posts

Posted - 11/27/2006 :  12:11:57  Show Profile  Visit spirit1's Homepage  Reply with Quote
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)

USA
7020 Posts

Posted - 11/27/2006 :  12:14:47  Show Profile  Reply with Quote
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

Slovenia
11750 Posts

Posted - 11/27/2006 :  12:15:57  Show Profile  Visit spirit1's Homepage  Reply with Quote
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

Sweden
30217 Posts

Posted - 11/27/2006 :  12:21:47  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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 - 11/27/2006 :  13:32:45  Show Profile  Reply with Quote
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 !

Edited by - fabianus76 on 11/27/2006 13:36:02
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30217 Posts

Posted - 11/27/2006 :  13:43:10  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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 - 11/27/2006 :  13:47:56  Show Profile  Reply with Quote
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 - 11/27/2006 :  14:01:53  Show Profile  Reply with Quote
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 - 11/27/2006 :  14:27:48  Show Profile  Reply with Quote
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 - 11/27/2006 :  14:38:07  Show Profile  Reply with Quote
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 - 11/27/2006 :  15:13:05  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
6062 Posts

Posted - 11/27/2006 :  15:16:32  Show Profile  Reply with Quote
>>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
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000