-
Nov 15th, 1999, 04:06 PM
#1
Thread Starter
Fanatic Member
Dear All...
I've one problem...
I have a database at SQL Server... And as we know, that every transaction to the database will recorded into log file...
My question is..
if the log file is already too large... how can I delete it ?? I mean.. how can I make it small again...???
Thx...a lot...
Wille
Junior VB Programmer
-
Nov 15th, 1999, 09:09 PM
#2
New Member
If you have a database administrator, discuss the problem with her. If not, read up on backup strategies and log maintenance. There are a few options including various TRUNCATE LOG options for the log, but it also depends on your database backup strategy.
If the Truncate Log On Checkpoint flag is set for your database, only uncommitted transactions take up space in the log.
HTH,
Tore.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|