Category Archives: SQL Server

Script to export SQL Server Blob data with ADO.Net via PowerShell

Below is a shamelessly copied script from Olaf Helper over at TechNet. If you have a fully configured FileStream SQL Server, Database and Table Column with the FileStream attribute then the following script is much better and avoids possible bugs with … Continue reading

Posted in .Net, Microsoft, PowerShell, SQL Server | Leave a comment

Log shipping across domains with FTP

If you have decided to use SQL Server Log Shipping as a Disaster Recovery (DR) solution, but for whatever reason your offsite data centre or external host isn’t on the same domain as you is Log Shipping still viable? Yes, … Continue reading

Posted in Backups, Microsoft, Networking, SQL Server | Leave a comment