Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup all SSAS databases using TSQL Expand / Collapse
Author
Message
Posted Wednesday, March 27, 2013 8:07 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 5:26 AM
Points: 28, Visits: 449
Comments posted to this topic are about the item Backup all SSAS databases using TSQL
Post #1436242
Posted Thursday, May 16, 2013 11:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 31, 2013 3:04 PM
Points: 10, Visits: 26
Hello Theo - can I use your script at work? hopefully you dont mind. I need to backup some SSAS databases automatically :)

Also what does this do? http://schemas.microsoft.com/analysisservices/2003/engine"

I tested in my local computer with no access to the internet and the scrip still worked fine.


Thanks' -
Oswaldo
Post #1453692
Posted Friday, May 31, 2013 8:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 2:21 PM
Points: 1, Visits: 210
This passes the DatabaseName where the DatabaseId should go. This can cause problems for databases that do not have the same value for DatabaseName and DatabaseId.
Post #1458743
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse