SQL Server: Backup/Restore to/from NAS Shares with Username/Password

Traditional Permanent NAS Share We setup NAS shares all the time for SQL Server backups and the procedure is quite simple. Find the SQL Server Engine Service account Grant full-control privileges to the share for the account Restart the SQL Server Engine Service for permissions to take effect (if needed) #Get the service account name(s). …

Using PowerShell to clone production SQL Server databases in non-production

We all know how to restore SQL Server databases from a backup but being the automation fanatic that I am, I wanted a method in PowerShell to quickly build a "clone" instance with all the databases as backed up from production. I wanted to do this with minimal number of parameters possible. The criteria that …