Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-28 : 07:51:06
|
| Brittanie writes "Hi, I obtained your information from the Microsoft SQL MVP site and was wondering if you could assist me with the following question? I have a question about the SQL Analysis Services installed on a separate server from SQL. Do the OLAP databases created with this service still reside on the SQL server or are they stored locally on the SQL Analysis Services server? The issue is for backup reasons. If the databases resides locally on the Analysis server I would think you would need a separate Veritas SQL agent for backup software? I examined this article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agarchive_2p4j.asp But it did not state conclusively if the OLAP databases can or are stored locally on the Analysis server. Thanks for any insight you can provide." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-28 : 14:42:53
|
| I believe Analysis Services works the same way as Reporting Services, so the databases would be on the SQL Server. Why are you using Veritas SQL agent to backup your databases? It is best to use SQL Server to backup the databases to disk then use Veritas to backup these files to tape.Tara |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-28 : 16:25:18
|
| The OLAP database files are stored on the Analysis Server itself.Right click and choose properties on the Analysis Server in Analysis Manager.There is a datapath, usually: "C:\Program Files\Microsoft Analysis Services\Data"What you should do is to "Archive" the OLAP databases (equiv to backup in SQL, but coarser)then You should backup these archive files.Hey, I glanced at the msdn article, it says it all doesn't it?rockmoose |
|
|
|
|
|
|
SQL Analysis Services on a Separate Physical Server from SQL