sql server management studio express

[James Landon]

Hello,

Does anyone know if it is possible to schedule an automatic backup of sql
database through SQL Server Management Studio Express? I have heard there is
no job scheduler included with this management tool however i'm not sure if
it's possible. If it's not possible could you make a suggestion of an
alternative method. Thanks in advance for any info you can provide.

Thankyou

[William Vaughn [MVP]]

Nope, that's a feature that first appears in the Workgroup edition.
BUT it's possible to simply execute the right TSQL BACKUP DATABASE command
from an OSQL/SQLCMD script that's fired off with the Windows scheduler or
your own application. And there are a number of excellent third-party tools
that will do this as well.
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
[phone] (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

Post by James Landon
Hello,
Does anyone know if it is possible to schedule an automatic backup of sql
database through SQL Server Management Studio Express? I have heard there
is no job scheduler included with this management tool however i'm not
sure if it's possible. If it's not possible could you make a suggestion of
an alternative method. Thanks in advance for any info you can provide.
Thankyou