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 - 2001-10-09 : 09:26:17
|
| Michael writes "Hi,I am able to archive the Analysis Services db's using the msmdarch on one server but not the other server. (It is working in the Test environment but not the Production environment.) Here are the details:Both servers are SQL Server 2000 sp1.I compared sp_configure and both servers have the same settings.The Production server is clustered and the Test Server is not clustered.I can archive in TEST using the following:- From Analysis Manager- Using the msmdarch command from a command prompt- From a scheduled job using the "Operating System Command" Type from a job step entering the msmdarch command in the Command box.- Using the msmdarch command with xp_cmdshell within Query Analyzer and from a Stored Procedure.I can archive in PRODUCTION only using:- From Analysis Manager- Using the msmdarch command from a command prompt** It does not work from a job or from Query AnalyzerI have checked the permissions of the SQL Server Agent account on both servers and they are identical with sa rights and a member of the OLAP Administrators group.Does anyone have any thoughts on what could be causing this? Thank YouMichael" |
|
|
|
|
|
Analysis Services archiving is not working on one server