SQL express back up with date

CCWeedcontrol

I would like to back up a SQL express database but with the date of when the backup was created added to the end (Owls06222017.bak). Is this possible if so how?

I tried the following but did not work.

db, backup_path + db + time.strftime("%m%d%y")+ r'.bak'

import pyodbc, datetime, fnmatch 

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=GIS7\SQLEXPRESS;Trusted_Connection=yes', autocommit=True)  
backup_path = 'C:\\temp\\'  
db = "Owls"  
  
def backup_db(conn, db, backup_path):  
  cur = conn.cursor()  
  try:  
    cur.execute('BACKUP DATABASE ? TO DISK=?', [db, backup_path + db + time.strftime("%m%d%y")+ r'.bak'])  
    while cur.nextset():   
      pass  
    cur.close()  
  except:  
    print 'Unable to backup: ' + db  
  
backup_db(conn, db, backup_path)  
  
conn.close()  
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoshuaBixby

For debugging purposes, how about you remove the try:except block so you can see the actual error message.  Or, have your except clause print the error message and stack trace as well.