Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to truncate logs in BM SQL Server

Status
Not open for further replies.

RobinPiepjohn

IS-IT--Management
May 13, 2002
19
DE
Hello

I think Ihave problem with networker 6.1.1 and the BM for SQL Server
Every night I do Full Backup, and it seems runnning well.
But I see that the Db have a size of some 500 MB and them logs 4 GB.
It is growing and my disk becomes full.
Every night I Backup the DB with a saveset MSSQL: and with the command nsrsqlsv

Have I to include some parameters to truncate the log files after backup? Or shall I do some maintenace jobs of SQL Enterprise Manager?


Someone can help me ?

Thanks robin
 
I have this same problem and Legato told me that you need to once in awhile do an incremental backup to truncate the logs, but if you are using networker module 3.0.1, it does not allow an incremental backup of the master database. The saveset MSSQL: backs up the master database, so you have to upgrade to networker module 3.1.0.43 if you want to try to do the incremental backup. I won't be of much help from there because I haven't been able to get 3.1.0.43 to work. It always fails with the error: ! No Output
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top