SQL Backup logs

• 
  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 = [e:\dblogs\<database>_<datetime yyyymmdd_hhnnss>.log]"'
  

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

  petey February 28, 2008 08:07

  - 0 +
• 
  Thanks petey.
  It works fine.
  Let's implement this

  Dje March 03, 2008 06:37

  - 0 +

Add comment

Please sign in to leave a comment.