|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > How to turn off transaction logging
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to turn off transaction logging
|
|
| Simon Lenn 2002-12-20, 5:23 am |
| In my data warehouse I have a staging database - stagingDB and I have
set the recovery model simple I do not want the transaction log to
grow at all (similar to Oracle in which we turn archiving off). How do
we turn off transaction logging what command or setting please.
Also, I see the transaction log is about 800 MB and I do not need how
do we purge the log. Is this the correct way of doing it?
backup log testdb with no_log
or
backup log testdb with truncate_only
will this purge the log and release the space occupied by the log
please clarify.
Thanks
Simon
| |
| Dejan Sarka 2002-12-20, 6:23 am |
| No way, you can't turn the transaction log off in SQL Server. You mark space
as reusable with Backup Log statement. Making backup without backup can be
done with both options you mentioned, they are synonyms. Shrinking the log
file can be done with DBCC SHRINKFILE.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Simon Lenn" <simonlenn@yahoo.com> wrote in message
news:3641e2c2.0212200309.7f4bfba7@posting.google.com...
> In my data warehouse I have a staging database - stagingDB and I have
> set the recovery model simple I do not want the transaction log to
> grow at all (similar to Oracle in which we turn archiving off). How do
> we turn off transaction logging what command or setting please.
>
> Also, I see the transaction log is about 800 MB and I do not need how
> do we purge the log. Is this the correct way of doing it?
>
> backup log testdb with no_log
>
> or
>
> backup log testdb with truncate_only
>
> will this purge the log and release the space occupied by the log
> please clarify.
>
> Thanks
> Simon
| |
| Oleg Deshin 2002-12-20, 6:23 am |
| Hi
> grow at all (similar to Oracle in which we turn archiving off). How do
> we turn off transaction logging what command or setting please.
There is no way to turn if off.
> Also, I see the transaction log is about 800 MB and I do not need how
> do we purge the log. Is this the correct way of doing it?
.....
> backup log testdb with truncate_only
This one is correct.
>
> will this purge the log and release the space occupied by the log
It depends.
Read the following for details:
http://support.microsoft.com/defaul...kb;en-us;110139
http://support.microsoft.com/defaul...kb;en-us;317375
Oleg.
|
|
|
|
|