UNSOLVED

fbf1

updated

18 years ago

F

fbf1

2 Posts

0

1085

March 18th, 2009 06:00

Cutting SQL log by Legato Networker

Good Day!
I have problems with clearnig SQL transaction logs.
We use only full every day backups. Now size of log more than DB.
Accoding Administration Guide NW usually cutting logs:

After the backup completes, the SQL Server truncates the transaction log if the
following applies:
¿ The NetWorker Module for Microsoft SQL Server determines that the
database does not support transaction log backups.
¿ No -T or -G option is specified.

NW 7.4.4.
Module for Microsoft SQL Server Release 5.2
How I can cut logs?
  • dgreggs1

    86 Posts

    317

    0

    Posted March 18th, 2009 07:00

    On the "App and Modules" tab for backup command add the -T to the "nsrsqlsv" command. This will truncate the log after a successfull backup completes.
  • fbf1

    2 Posts

    317

    0

    Posted March 18th, 2009 07:00

    Thanks for your help! I try add different key during first configuration...

    But size of logs not changes after successfull backup ...
    What can I do next?

    Message was edited by:
    fbf
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    317

    0

    Posted March 18th, 2009 12:00

    We had this question several times already - try to lookup in archives and see if that gets you anywhere.