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). …

Advertisement

PowerShell: Backup All SSAS Databases To A Network Share

I am working on downgrading SQL Server Enterprise Edition (EE) s/w to Standard Edition (SE) where EE features are not used (to save money on licensing). We have a big list of these to go through. That required all SSAS databases to be backed-up to the network and restored after the edition downgrade. I will …