I would appreciate if anyone let me know why the log file size is increasing
too much. My database size is 15 GB and my log file size is 10 GB.

Anyway I can reduce my file size?

Thanks

To truncate the passive virtual logs in your tlog file use the following
line:

BACKUP LOG your_db WITH NO_LOG

To shrink the file physically, use the following one:
DBCC SHRINKFILE (your_log_file's_logical_name, <size of the tlog file you
want it to be>)

Result of this operation depends on the active virtual logs in the t-log
file.

However, you also better take a look at the following article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Ekrem Önsoy



"Test" <test (AT) hotmail (DOT) com> wrote

To truncate the passive virtual logs in your tlog file use the following
line:

BACKUP LOG your_db WITH NO_LOG

To shrink the file physically, use the following one:
DBCC SHRINKFILE (your_log_file's_logical_name, <size of the tlog file you
want it to be>)

Result of this operation depends on the active virtual logs in the t-log
file.

However, you also better take a look at the following article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Ekrem Önsoy



"Test" <test (AT) hotmail (DOT) com> wrote

To truncate the passive virtual logs in your tlog file use the following
line:

BACKUP LOG your_db WITH NO_LOG

To shrink the file physically, use the following one:
DBCC SHRINKFILE (your_log_file's_logical_name, <size of the tlog file you
want it to be>)

Result of this operation depends on the active virtual logs in the t-log
file.

However, you also better take a look at the following article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Ekrem Önsoy



"Test" <test (AT) hotmail (DOT) com> wrote

To truncate the passive virtual logs in your tlog file use the following
line:

BACKUP LOG your_db WITH NO_LOG

To shrink the file physically, use the following one:
DBCC SHRINKFILE (your_log_file's_logical_name, <size of the tlog file you
want it to be>)

Result of this operation depends on the active virtual logs in the t-log
file.

However, you also better take a look at the following article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Ekrem Önsoy



"Test" <test (AT) hotmail (DOT) com> wrote

To truncate the passive virtual logs in your tlog file use the following
line:

BACKUP LOG your_db WITH NO_LOG

To shrink the file physically, use the following one:
DBCC SHRINKFILE (your_log_file's_logical_name, <size of the tlog file you
want it to be>)

Result of this operation depends on the active virtual logs in the t-log
file.

However, you also better take a look at the following article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Ekrem Önsoy



"Test" <test (AT) hotmail (DOT) com> wrote

To truncate the passive virtual logs in your tlog file use the following
line:

BACKUP LOG your_db WITH NO_LOG

To shrink the file physically, use the following one:
DBCC SHRINKFILE (your_log_file's_logical_name, <size of the tlog file you
want it to be>)

Result of this operation depends on the active virtual logs in the t-log
file.

However, you also better take a look at the following article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Ekrem Önsoy



"Test" <test (AT) hotmail (DOT) com> wrote

To truncate the passive virtual logs in your tlog file use the following
line:

BACKUP LOG your_db WITH NO_LOG

To shrink the file physically, use the following one:
DBCC SHRINKFILE (your_log_file's_logical_name, <size of the tlog file you
want it to be>)

Result of this operation depends on the active virtual logs in the t-log
file.

However, you also better take a look at the following article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Ekrem Önsoy



"Test" <test (AT) hotmail (DOT) com> wrote

To truncate the passive virtual logs in your tlog file use the following
line:

BACKUP LOG your_db WITH NO_LOG

To shrink the file physically, use the following one:
DBCC SHRINKFILE (your_log_file's_logical_name, <size of the tlog file you
want it to be>)

Result of this operation depends on the active virtual logs in the t-log
file.

However, you also better take a look at the following article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Ekrem Önsoy



"Test" <test (AT) hotmail (DOT) com> wrote

To truncate the passive virtual logs in your tlog file use the following
line:

BACKUP LOG your_db WITH NO_LOG

To shrink the file physically, use the following one:
DBCC SHRINKFILE (your_log_file's_logical_name, <size of the tlog file you
want it to be>)

Result of this operation depends on the active virtual logs in the t-log
file.

However, you also better take a look at the following article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Ekrem Önsoy



"Test" <test (AT) hotmail (DOT) com> wrote