SQL Backup logs

Dje · February 28, 2008 7:46AM

Hi Everyone,

Is there an option to set up in order to have the logs called something like :
DBNAME_YYYYMMDD_HHMMSS instead of "ie : 20071128 183856 01.log" which is not really a speaking name ?

Thanks in advance for your replies,
Jerome

petey · February 28, 2008 8:07AM

You can't do that to the default logs that are created. The reason being we need a definitive way to look for those logs. If users start naming them in other ways, we may never get the logs we want.

Having said that, you can create a secondary set of logs using the LOGTO option e.g.

EXEC master..sqlbackup '-sql "BACKUP DATABASE ... WITH LOGTO = &#91;e:\dblogs\&lt;database&gt;_&lt;datetime yyyymmdd_hhnnss&gt;.log&#93;"'

Note that minutes are represented by the symbol nn, not mm.

Dje · March 3, 2008 6:37AM

Thanks petey.
It works fine.
Let's implement this

SQL Backup logs

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk