do know why have got error , how fix it.
sqlserveragent not started (reason: installation of sql server agent disabled. edition of sql server installed service not support sql server agent.).
my server parameters:
10.0.5500.0 sp3 express edition advanced services (64-bit)
sql agent not available express editions : (http://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx). that's why, example, can't schedule report production on reporting services.
you may want batch sqlcmd.
===== edit =====
simple sample:
save.sql ----- backup database dbname disk = 'somepath' init, format save.bat ----- "c:\program files\microsoft sql server\100\tools\binn\sqlcmd.exe" -s instancename -e -i save.sql -o save.log
you may schedule save.bat (with windows task scheduler) make full backup of dbname
Comments
Post a Comment