Configure Backup

Is there a way to automate backup? Like it has a schedule. Is this in standard edition.?

Please help a newbie.

Sure...Look in Books Online for "scheduling jobs".
|||

When I check the properties of the SQL Server, it does not have schedule tab. So, I can't schedule a job. I'm using Microsoft SQL Server 8.0 Developer Edition, if I remember correctly.

|||The Schedule tab is on the job properties, not the SQL Serverproperties. You can get to the Jobs in Enterprise Manager bydrilling into the tree node for your SQL Server, then the "Management"node, then the "SQL Server Agent" node under the Management node, andfinally you'll see the "Jobs" node. If you add a new job, on the jobproperties dialog you'll see the Schedule tab.
|||

Found it. I will give it a try.

|||If you are using Enterprise Manager to manage SQL server than it is under Management/Database Maintenance Plans.sqlsql

Conditional Scheduling of MS Analysis Jobs

Hi All,

I'm trying to understand, if there SSAS 2005 supports conditional sequencing of jobs.

I wanted to know if there is a way to schedule few critical cube refresh jobs first and then sequence other jobs.

Example: Cubes with Customer XYZ should be refreshed first and then Cubes for PQR and so on.

Appreciate, if you can throw some light on this.

Regards,

Dash

If you wanted to have particular order for processing of your partitions and dimensions (processing of cubes always results in processing of partitions and dimensions) you should simply build a processing batch consisting of commands in particular order.

For that run Processing dialog in SQL Management studio. Select the objects you like to process and then click on the Scrip button on the top of the dialog. You will see processing command generated for you. You can tweak the command any way you like.

Some additional info for you:

http://msdn2.microsoft.com/en-us/library/ms345142.aspx

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1238273&SiteID=1