Besides the maintenance plan wizard which I've put into action, how with query do I execute a backup of log?
I try:
backup log mydatabase to mydatalog with TRUNCATE_ONLY
but it doesn't like the mydatalog part.
something about sysdevices does not recognize the mydatalog.
TIA