Nie znalazłem jednej komendy wykonującej backup wszystkich baz danych. Dlatego wylistowałem bazy danych (poprzedni wpis) i złożyłem w całość dużą komendę:
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"><</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Batch </span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">http://schemas.microsoft.com/analysisservices/2003/engine</span></span><span style="font-size: small;">"</span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">Transaction</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">false</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> ></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Backup</span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">http://schemas.microsoft.com/analysisservices/2003/engine</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Object</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseID</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span><span style="font-size: small;">XXX</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseID</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> </</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Object</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">File</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">>E:\Default</span></span><span style="font-size: small;">\XXX.abf</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">File</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">AllowOverwrite</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span><span style="font-size: small;">true</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">AllowOverwrite</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> </</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Backup</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Backup</span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">http://schemas.microsoft.com/analysisservices/2003/engine</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Object</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseID</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">>YYY</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseID</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> </</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Object</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">File</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">>E</span></span><span style="font-size: small;">:\Default\YYY.abf</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">File</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">AllowOverwrite</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span><span style="font-size: small;">true</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">AllowOverwrite</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> </</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Backup</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
podobnie z komendą do restore:
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"><</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Batch </span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">http://schemas.microsoft.com/analysisservices/2003/engine</span></span><span style="font-size: small;">"</span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">Transaction</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">false</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> ></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Restore</span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">http://schemas.microsoft.com/analysisservices/2003/engine</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">File</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">>E</span></span><span style="font-size: small;">:\Default\XXX.abf</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">File</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseName</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span><span style="font-size: small;">XXX</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseName</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DbStorageLocation</span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"><a href="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">D:\AS\Default\</DbStorageLocation">http://schemas.microsoft.com/analysisservices/2008/engine/100/100</a></span></span><a href="file://\\Default\</"><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">>D</span></span><span style="font-size: small;">:\Default\</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span></a><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;"><a>DbStorageLocation</a></span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> </</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Restore</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Restore</span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">http://schemas.microsoft.com/analysisservices/2003/engine</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">File</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">>E</span></span><span style="font-size: small;">:\Default\YYY.abf</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">File</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseName</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span><span style="font-size: small;">YYY</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseName</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DbStorageLocation</span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"><a href="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">D:\Default\</DbStorageLocation">http://schemas.microsoft.com/analysisservices/2008/engine/100/100</a></span></span><a><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">>D:</span></span><span style="font-size: small;">\Default\</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span></a><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;"><a>DbStorageLocation</a></span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
</Restore> </Batch>
A jeśli się okaże, że wszystkie (lub po prostu większa ilość baz) mają być usunięte, to skorzystaj z:
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"><</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Batch</span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">http://schemas.microsoft.com/analysisservices/2003/engine</span></span><span style="font-size: small;">"</span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">Transaction</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">false</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> ></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Delete</span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">http://schemas.microsoft.com/analysisservices/2003/engine</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Object</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseID</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span><span style="font-size: small;">XXX</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseID</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> </</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Object</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> </</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Delete</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Delete</span></span><span style="color: #ff0000; font-size: small;"><span style="color: #ff0000; font-size: small;">xmlns</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">=</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">http://schemas.microsoft.com/analysisservices/2003/engine</span></span><span style="font-size: small;">"</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Object</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> <</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseID</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span><span style="font-size: small;">YYY</span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"></</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">DatabaseID</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> </</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Object</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
1 |
1 |
<span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;"> </</span></span><span style="color: #a31515; font-size: small;"><span style="color: #a31515; font-size: small;">Delete</span></span><span style="color: #0000ff; font-size: small;"><span style="color: #0000ff; font-size: small;">></span></span> |
</Batch>