Need some help backup up my sqlexpress 2005 database. I am trying to automate it with taskscheduler
This works however the size just keeps growing everytime it backs up I want to overwrite it
SQLCMD -E -S WEBSERVER\PROPHETSQL -Q "BACKUP DATABASE Avidian TO DISK='C:\BTSync Backup\Avidian.bak'"
I tired adding with INIT to it and I get an Unexpected Arguement Error when I try to add it.
Go to the complete details ...