Shrink transaction log - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Shrink transaction log

Message

From

22/04/2002 11:29:24

Daniel Gramunt
Nokia
Lausanne, Switzerland

18/04/2002 13:29:54

Dave Sonier
Technologies Nter inc.
Gatineau, Quebec, Canada

General information

Forum:

Microsoft SQL Server

Category:

Backups

Title:

Re: Shrink transaction log

Miscellaneous

Thread ID:

00646470

Message ID:

00647568

Views:

Dave,
The following link contains useful info about this subject: http://www.bstconsultants.com/tsug/Dec99/REDUCING_THE_SIZE_OF_THE_LOG_FILE.htm

HTH
>Hi,
>
>I have a little problem. I have a transaction log with 3 000 mb...
>
>But I just have 50mb used...How can I shrink the log to 100mb...
>
>Does exist a command to do that ?
>
>Thank in advance.
>
>Dave Sonier
>Technologies Nter

Daniel

Map

View

Click here to load this message in the networking platform