Basic questions (Part 2)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hassan - 26 Mar 2005 18:14 GMT

1) How can I schedule a daily full backup of the AS Database ? I know in SQL
server, therese a SQL Agent that i can run a job .. But on my AS Server, all
I have is AS.. Also what the command to use ? Can one send me an example ?

2) I looked at the data folder and I see so many different files of
different file types.. Can one point me to some reference about what each
kind of file is ?

Reply to this Message

Dave Wickert [MSFT] - 28 Mar 2005 18:49 GMT

> 1) How can I schedule a daily full backup of the AS Database ? I know in SQL
> server, therese a SQL Agent that i can run a job .. But on my AS Server, all
> I have is AS.. Also what the command to use ? Can one send me an example ?

Look in BOL in the section which describes the msmdarch utility. You can use
SQL Agent to spawn a command line instance of msmdarch to create the
archive.

> 2) I looked at the data folder and I see so many different files of
> different file types.. Can one point me to some reference about what each
> kind of file is ?

This is talked about a bit in the Analysis Services Operations Guide at:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
See appendix K.

Hope this helps.

Signature

Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

> 1) How can I schedule a daily full backup of the AS Database ? I know in SQL
> server, therese a SQL Agent that i can run a job .. But on my AS Server, all
[quoted text clipped - 3 lines]
> different file types.. Can one point me to some reference about what each
> kind of file is ?

Reply to this Message