HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.msde » sql server management studio express
Topic: sql server management studio express
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
Replies below ↓
Replies
sql server management studio express
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
sql server management studio express
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
sql server management studio express
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
Re: sql server management studio express
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
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"James Landon" <jlandon@pioneertool.com> wrote in message
news:GemdndtsAJ6Al6LVnZ2dnUVZ_ojinZ2d@posted.choiceonecommunications...
> 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
>