|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > Shrink transacton log
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 |
Shrink transacton log
|
|
|
| I do shrink of transaction log and after that truncate.
Log get his initial size. After that I enlarge the log but
after truncating log file again get his initial size. What
is problem? How I can solve it?
| |
| Wayne Snyder 2002-06-22, 8:30 pm |
| How are you enlarging the log?... You should be increasing the SIZE setting
for the log. Make sure maxsize is large enough for the log to grow and you
should be fine.
--
Wayne Snyder, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
I support the Professional Association for SQL Server and its community.
www.sqlpass.org
I support the Professional Association for SQL Server (PASS) and its user
community of SQL Server Professionals.
www.sqlpass.org
| |
| Vikrant V Dalwale [MS] 2002-06-22, 8:31 pm |
|
Hello ,
I am sure Wayne has pointed you in the right direction..I am mentioning
the following KB article just
FYI..
INF: How to Shrink the SQL Server 7.0 Transaction Log [sqlserver]
ID: Q256650
Thanks,
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.© 2002 Microsoft Corporation. All rights
reserved.
Additional support can be obtained at http://support.microsoft.com
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
>Content-Class: urn:content-classes:message
>From: "sas" <kotsas@mt.net.mk>
>Sender: "sas" <kotsas@mt.net.mk>
>Subject: Shrink transacton log
>Date: Mon, 10 Jun 2002 02:45:54 -0700
>Lines: 4
>Message-ID: < c9d901c21063$9cf0aae0$9ae62ecf
@tkmsftngxa02>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcIQY5zwx6Ev2P14QsW2b0fBlXCAfg
==
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TKMSFTNGXA02 10.201.232.161
>Path: cpmsftngxa08!cpmsftngxa07
>Xref: cpmsftngxa08 microsoft.public.sqlserver.server:213855
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>I do shrink of transaction log and after that truncate.
>Log get his initial size. After that I enlarge the log but
>after truncating log file again get his initial size. What
>is problem? How I can solve it?
>
|
|
|
|
|