How to unzip in Powershell

Question: I have a zip file , which I normally win-zip or unzip . I'd like to unzip an archive file as part of a Powershell script Answer: You can use the Powershell cmdlet - Expand-Archive . I've also included some added bits around the ps cmdlet Expand-Archive , which will assist in managing access & file clean up . # Unblock if there's a block – common problem Unblock-File test.zip -ErrorAction SilentlyContinue #the actual expand process Expand-Archive -Path test.zip -DestinationPath e:\exsample\sql_server\modules -Force #to remove your zip file Remove-Item -Path test.zip Read more on Powershell scripts Powershell Script Library for... Read more →

How to unzip in Powershell

Question: I have a zip file , which I normally win-zip or unzip . I'd like to unzip an archive file as part of a Powershell script Answer: You can use the Powershell cmdlet - Expand-Archive . I've also included some added bits around the ps cmdlet Expand-Archive , which will assist in managing access & file clean up . # Unblock if there's a block – common problem Unblock-File test.zip -ErrorAction SilentlyContinue #the actual expand process Expand-Archive -Path test.zip -DestinationPath e:\exsample\sql_server\modules -Force #to remove your zip file Remove-Item -Path test.zip Read more on Powershell scripts Powershell Script Library for... Read more →

How to capture errors from SQLCMD

Question: I'm executing code using SQLCMD from a batch file . The code points to a sql file and there is also an output file. SQLCMD -E -S MYSERVER\INST1 -i "setup_job_entry.sql" -o "setup_job_entry.log" But I noticed that if the actual SQLCMD returns an error , for example , if I'm connecting to an server which doesn't exist this error message will appear in the output file - but there will not be an ERROR number , which would allow me to trap and return an appropriate message Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : SQL Server Network... Read more →

How to enable MSDTC XA transactions with Powershell

Question: I've read your post on Enable XA transactions for SQL Server , which outlines how to enable XA transactions via the Computer Services module. I'd like to integrate the enabling of XA transactions as part of a scripted SQL Server installation, whoch includes enabling XA transactions for some applications. I'm using Powershell to develop the script . How can I see the current value and also change the value to enable XA ? Answer: It is possible to access and set the MSDTC XA Transactions values using Powershell . You need to make sure your current login has the... Read more →

Powershell Script - Backup SQL databases to a remote drive

Question: Do you have a powershell script to backup SQL databases on a single SQL Server Instance , and direct them to a network share or a local drive? Also , I'd like an email notification with a screen output sent to my email box. The purpose of the script is not to replace the current backup scripting but is for ad-hoc uses Answer: There are plenty of different ways to manage the process of backing up SQL Server databases with Powershell. In this script , the powershell cmdlet Invoke-sqlcmd is used to connect to a sql server , and... Read more →