Scheduling a backup on SQL Server Express

Hi,
is there a way to schedule a backup ?
Using the Management Studio Express I've seen only the way to Backup a
database but not to "schedule" a backup.
Any help or suggestion is appreciated
Adriano
hi Adriano,
Adry wrote:
> Hi,
> is there a way to schedule a backup ?
> Using the Management Studio Express I've seen only the way to Backup a
> database but not to "schedule" a backup.
>
unfortunately, SQLExpress does not provide the SQL Server Agent, so you have
to rely on os scheduled (AT, SCHTASKS) scripts to be run via osql.exe or
sqlcmd.exe...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

scheduled backup question

I currently have the default 'simple' backup mode. I right clicked a
database, chose all tasks, then backup database. Then I chose to do a full
backup to a file device I created. I chose to 'schedule' the backup to occur
once a day. My question: Where do I see this scheduled backup? is there a
place I can see whats currently scheduled? What if I need to edit it?
any info is greatly appreciated.. Thanks.
You can see all the jobs in Enterprise Manager. Under the server, go to
Management > SQL Server Agent > Jobs.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"djc" <noone@.nowhere.com> wrote in message
news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
> I currently have the default 'simple' backup mode. I right clicked a
> database, chose all tasks, then backup database. Then I chose to do a full
> backup to a file device I created. I chose to 'schedule' the backup to
occur
> once a day. My question: Where do I see this scheduled backup? is there a
> place I can see whats currently scheduled? What if I need to edit it?
> any info is greatly appreciated.. Thanks.
>
|||thank you.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:Ow1YP7RaEHA.2296@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> You can see all the jobs in Enterprise Manager. Under the server, go to
> Management > SQL Server Agent > Jobs.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "djc" <noone@.nowhere.com> wrote in message
> news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
full[vbcol=seagreen]
> occur
a
>

scheduled backup question

I currently have the default 'simple' backup mode. I right clicked a
database, chose all tasks, then backup database. Then I chose to do a full
backup to a file device I created. I chose to 'schedule' the backup to occur
once a day. My question: Where do I see this scheduled backup? is there a
place I can see whats currently scheduled? What if I need to edit it?
any info is greatly appreciated.. Thanks.You can see all the jobs in Enterprise Manager. Under the server, go to
Management > SQL Server Agent > Jobs.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"djc" <noone@.nowhere.com> wrote in message
news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
> I currently have the default 'simple' backup mode. I right clicked a
> database, chose all tasks, then backup database. Then I chose to do a full
> backup to a file device I created. I chose to 'schedule' the backup to
occur
> once a day. My question: Where do I see this scheduled backup? is there a
> place I can see whats currently scheduled? What if I need to edit it?
> any info is greatly appreciated.. Thanks.
>|||thank you.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:Ow1YP7RaEHA.2296@.TK2MSFTNGP10.phx.gbl...
> You can see all the jobs in Enterprise Manager. Under the server, go to
> Management > SQL Server Agent > Jobs.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "djc" <noone@.nowhere.com> wrote in message
> news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
full[vbcol=seagreen]
> occur
a[vbcol=seagreen]
>