Use the following code below to connect to SQL Server 2008 R2.  This will text connectivity over SSPI/Integrated Authentication.  You can also define the port number and display the results in the powershell window.  Remember to press “Enter” once the count of records is returned. This is very helpful when troubleshooting connection issues, it can

Read more…

Source Article: http://www.dbafarm.com/ PowerShell Copy Backup to network share Seems simple, but it’s not. I tried the following scenarios: 1. Local copy 2. Copy to share 3. Copy to share on different domain 4. Copy to admin share *Note : this script can also Mirror the source and destination– just like the /Mir robocopy switch,

Read more…