Post reply

Backup Analaysis Database

  • March 27, 2006 at 8:58 pm

    #112533

    Hi,

    Do anyone know how to backup Analysis database in SQL Server2005.

    Pls help me

    from

    Killer

  • March 29, 2006 at 1:37 am

    #629385

    Try the Analysis Services forum

    -Jamie

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • March 29, 2006 at 1:41 am

    #629386

    1. Via SQL Management Studio, connect to the analysis service.

    2. right click database and select backup

    Derek

  • March 29, 2006 at 2:05 am

    #629391

    Hi,

    Thanx for ur reply , i already did that.I want to know how to backup from command prompt.

    from

    killer

  • March 29, 2006 at 2:31 am

    #629399

    Uh You might have been a little more specific in your question.

    anyway, do the same thing via the GUI and then in the backup dialog screen ensure you select what path you want the backup to go to and then use the scriptout icon to capture the backup sql created.  You can then save this SQL and execute via batch, sqlcmd etc.

  • March 30, 2006 at 10:06 pm

    #630012

    Thanx Derek.

    from

    Killer

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply