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 |
|
cpyne
Starting Member
13 Posts |
 Posted - 2006-12-20 : 13:35:04
|
| Hi,I need to setup a job that will backup all Analysis Services 2005 databases on a server. I want this job to be dynamic so it will still work as AS databases are added/removed. Can anyone think of a way to do this? Is there a SQL query that will return all AS database names? If so, I think I could dynamically recreate this job each night, but I have no idea how to return a db list. Any ideas?Here's an article that shows how to backup 1 database via a job...http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1146883_tax301326,00.html?adg=301324&bucket=ETAThanksCHarlieCharlie Pyne |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cpyne
Starting Member
13 Posts |
Posted - 2006-12-20 : 13:51:24
|
| It looks like this just backs up SQL databases. I need to backup all Analysis Services databases in 2005.Charlie Pyne |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-20 : 13:55:46
|
| Aren't they stored in the database engine? I'm not familiar with Analysis Services, but I assumed it would be like any other product of SQL Server such as Reporting Services as far as where the database goes.Tara Kizer |
|
|
|
cpyne
Starting Member
13 Posts |
Posted - 2006-12-20 : 14:39:58
|
| In 2000, they were stored in either SQL or Access depending on how you set Analysis Services up. In 2005, it looks like the repository has gone away in favor of XML files on the OS level. Charlie Pyne |
|
|
|
|
|
|
Backup All Analysis Services 2005 Databases