Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
DECLARE @Path NVARCHAR(1000), @FileName NVARCHAR(255), @FullPath NVARCHAR(1255)
SET @Path = '\\db1\E$\SQLServer\2008\B
SET @FileName = 'Express_' + REPLACE(CONVERT(VARCHAR(10
SET @FullPath = @Path + @FileName
BACKUP DATABASE Express
TO DISK = @FullPath
WITH INIT
And scehedule them using SQL JOBS