dedri
asked on
sql server express backup schedule
I have a couple of sql server express editions. I want to schedule backups for database on them. Could you tell me how to do it. Also if the backup fails I want to be notified by email.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sqlcmd -E -S servername\sqlexpress –Q "BACKUP DATABASE [dbname] TO DISK='d:\dbname.bak' "
Just change the SQL instance and the dbname and location, and this should backup as expected.
Lee