To do backups on SQL Server, highly recommend: http://sqlbackupandftp.com/
Tag Archives: SQL Server
How to set up access from SQL Server Management Studio to SQL Server 2008 on Winows 2008 with a software firewall? Make sure to create a rule in the firewall that enables access to sqlservr.exe that is located in the Binn directory of your database. See this MSFT article, look to “To access a program through the Windows firewall”. No need to punch through holes for TCP or UDP.