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: Thursday, September 18, 2014 12:35 AM
Points: 29, Visits: 463
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: Thursday, September 18, 2014 11:37 AM
Points: 1, Visits: 234
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
Posted Friday, September 12, 2014 8:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 2:24 AM
Points: 4, Visits: 20
If you need something with more options, like compress, upload to the cloud (amazon s3, glacier, dropbox, azure). You can try www.sqlserverbooster.com and it's free
Post #1613039
Posted Friday, September 12, 2014 8:36 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 18, 2014 12:35 AM
Points: 29, Visits: 463
Hi Erik,

I knew of this tool, but this one requires running a seprate service on the SQL server, which is fine if you are allowed do that.

If not... you could use my script :)
Post #1613059
Posted Friday, September 19, 2014 7:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 2:24 AM
Points: 4, Visits: 20
It's true. But remember that you can disable the service and just run the GUI that also makes the backups. And also exists another options. You can install it in a different machine and makes remotely the backups. All this effort worth it if you want to upload to the cloud, move it through the network, encrypt or something else more complex.

You script it's clean and elegant.
Post #1615481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse