April 16, 2015 at 8:12 am
I'm performing an upgrade of a DW Warehouse Server from SQL Server 2008 to another machine with SQL Server 2014.
I know that you can perform the restore via the SSMS GUI but I want to script it out.
Any help would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 16, 2015 at 9:17 am
i use kind of solution as below. they are scheduled in sql server agent, running every night once.
you should select "SQL Server Analysis Services Command" in the Job Properties - Step - Type
for backup:
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>OLAP</DatabaseID>
</Object>
<File>\\10.10.10.10\e\Live\DWH\OLAP_backup.abf</File>
<AllowOverwrite>true</AllowOverwrite>
</Backup>
for restore:
<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<File>\\10.10.10.10\e\Live\DWH\OLAP_backup.abf</File>
<DatabaseName>OLAP</DatabaseName>
<AllowOverwrite>true</AllowOverwrite>
<DbStorageLocation xmlns="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">F:\OLAP\</DbStorageLocation>
</Restore>
April 16, 2015 at 10:58 am
you could also use powershell: Backup-ASDatabase and Restore-ASDatabase
April 16, 2015 at 11:06 am
Thanks!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 16, 2015 at 3:33 pm
IIRC if you perform the restore via the GUI you can also script it out.
---------------------------------------------------------------------
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy