Monday, March 26, 2012

Migrating AS Repository Advantages

Is there any performance gain on migrating Analysis Services Repository from
.mdb to SQL Server 2000 database ?IMHO the repository will be more manageable, more robust and more secure.
I personally create a seperate DB for the repository i.e. AS_REP
The default is to migrate to MSDB. The problem with that being your jobs
and DTS packages amongst other things are also in there.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Sws" <anonymous@.discussions.microsoft.com> wrote in message
news:50311460-D284-46A9-BE92-8A1B172C5F7A@.microsoft.com...
quote:

> Is there any performance gain on migrating Analysis Services Repository

from .mdb to SQL Server 2000 database ?|||synchonizing backups of the repository and the data folder are much easier if you use a
dedicated database. For more information, see the Analysis Services Operations Guide a
nd the Analysis Services Performance Guide at /url]
/bianalysis.asp
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community
Website: [url]http://www.sqlJunkies.com/newsgroups/" target="_blank">www.microsoft.com/sql/eveluation/bi...com/newsgroups/

No comments:

Post a Comment