Announcement

Collapse
No announcement yet.

How do you automate the SQL Server 2008 Database and OLAP backup ?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do you automate the SQL Server 2008 Database and OLAP backup ?

    Hi Everyone,

    I have SQL Server 2008 Enterprise SP2 x64 database in my Windows Server 2008 Enterprise, my question is how to perform automated backup for both database content ? eg. the MDF and the LDF as well as the OLAP database ?

    Thanks.

  • #2
    Re: How do you automate the SQL Server 2008 Database and OLAP backup ?

    Create a SQL maintenance plan that backs up the databases on a schedule.

    Comment


    • #3
      Re: How do you automate the SQL Server 2008 Database and OLAP backup ?

      Ok, does that Apply to The OLAP components as well ?

      Comment


      • #4
        Re: How do you automate the SQL Server 2008 Database and OLAP backup ?

        If you're referring to an OLAP database, then yes.

        Comment


        • #5
          Re: How do you automate the SQL Server 2008 Database and OLAP backup ?

          Originally posted by joeqwerty View Post
          If you're referring to an OLAP database, then yes.
          great, I'll have a look into it then.

          Thanks Joe.

          Comment


          • #6
            Re: How do you automate the SQL Server 2008 Database and OLAP backup ?

            Glad to help.

            Comment

            Working...
            X