Scheduling Backups

[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

[bruce]

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


[b]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">

[Aristotle]

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

[theswally]

On my local server.

[b]quote:Originally posted by bruce

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


[b]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">

[theswally]

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

[b]quote:Originally posted by Lukas

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