Test/Test-Script-SQLDatabaseRestore.ps1
|
Clear-Host; Script-SQLDatabaseRestore -RestoreCategory LatestAvailable ` -Source_SQLInstance SqlProd1 ` -SourceDatabase Cosmo ` -Destination_SQLInstance SqlProd1 ` -DestinationPath_Data "F:\mssqldata\Data" ` -DestinationPath_Log "E:\Mssqldata\Log" ` -Verbose; <# Script-SQLDatabaseRestore -BackupPath '\\SqlProd3\g$\Backup' ` -RestoreCategory LatestAvailable ` -Destination_SQLInstance SqlProd1 ` -DestinationPath_Data "F:\mssqldata\Data" ` -DestinationPath_Log "E:\Mssqldata\Log" ` -Verbose #> |