Import-Module 'sqlps' -DisableNameChecking


$SV = 'TSTSQL001\MSSQLSERVER1'
$UserID = 'sa'
$Password = 'p@ssw0rd'
$DBName = 'TEST1'
$Query = 'DBCC SHRINKFILE(TEST1_Log, 250) ;select @@error as ret'


$DB = Backup-SqlDatabase -ServerInstance $SV -Database $DBName -BackupFile ('C:\BACKUP.MSSQLSERVER1\' + $DBName + '.bak') -BackupAction Database
$DBLOG = Backup-SqlDatabase -ServerInstance $SV -Database $DBName -BackupFile ('C:\BACKUP.MSSQLSERVER1\' + $DBName + '_log.bak') -BackupAction Log