Scheduling Backups

Hi gang. I'm new to the forum. I've got a question, actually 2, about scheduled database backups in SQL Server.

1) When you schedule a backup to happen in EM, I haven't found a way to go back to the backup scheduler and see what I scheduled last. Is this information accessible somewhere?

2) Is there a way to schedule a backup without using EM? Say via command line in Query Analyzer?

Thanks,
Bret

 

The scheduled jobs should show up in the SQL Server Agent section.

 

On my local server.

quote:Originally posted by bruce

do you do this on your local sql server or our server?


quote:Originally posted by theswally

Hi gang. I'm new to the forum. I've got a question, actually 2, about scheduled database backups in SQL Server.

1) When you schedule a backup to happen in EM, I haven't found a way to go back to the backup scheduler and see what I scheduled last. Is this information accessible somewhere?

2) Is there a way to schedule a backup without using EM? Say via command line in Query Analyzer?

Thanks,
Bret
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

 

Thanks, Lukas. That's exactly what I needed.

quote:Originally posted by Lukas

The scheduled jobs should show up in the SQL Server Agent section.
</blockquote id="quote"></font id="quote">