Planning transaction log backup on MSSQL 2008

[Former Member]

Hi all,

I am not an expert of MSSQL and I am getting some troubles to plan the database transaction log backup in the DB13. The problem is that the transac backup is not overwriting old sessions on the media.

Actually , I have plan full backup every week on saturday night and then 4 transaction log backups every day.

We are using 2 medias to perform the backups, one for the full backup and one for the transaction log.

I have configured the transac backup with the options "Tape Unload" "INIT TAPE" "checksum" and "verify backup", but it's not working, the media is getting filled more and more and the old sessions are not overwriten and I dont understand why.

Can someone can help me to schedule the MSSQL transaclog backup and to configure it in the way that the old sessions are getting overwritten?

Thanks.

Denis

[Former Member · Accepted solution]

Hi Marius,

thanks for your answer. The problem is not about shrinking the Transac log but overwriting the expired session on the transac log media.

the media is configured to use local filesystem, and is growing untill filesystem get full.

I am using the INIT option with 13 days of rentention, but I still can see the old session in the media content.

Could it be that the old transaclog sessions are not overwriten because the old sessions ran without INIT options ?

should I format tapes an replan the backup with the INIT option in order to overwrite expired sessions ?

Thanks for your help.

Denis

[ORU · Accepted solution]

Hi Denis

I have the same problem and it is solved with note 1867938.

and more can be found in my conversation http://scn.sap.com/message/14239710#14239710

regards Oliver

[Former Member]

Hi all,

@Oliver this is exactly what I needed, the backup I schedule yesterday failed with the error mentioned in note 1867938.

@S Sriram, thanks I will use this link to schedule my backup thru the SQL Server managment studio

Thanks all and regards,

Denis

[Sriram2009]

Hi Denis

You take the MS Sql backup thru "SQL Server Management Studio" for this some of the reference links

http://msdn.microsoft.com/en-us/library/ms179478(v=sql.90).aspx

http://blogs.technet.com/b/beatrice/archive/2008/07/24/full-backups-transaction-logs-backup.aspx

Thanks

Ram

[former_member206552]

Hi Denis,

i have to admit i have never run the backups of SQL Server from DB13, i have always used the SQL Server from this like in this thread http://scn.sap.com/message/5007154.

Maybe it helps you

Best Regards

Marius