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.
::TIME For /f "tokens=1-2 delims=/:" %%a in ("%TIME%") do (set mytime=%%a%%b) For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c-%%a-%%b) ::Darom diff backup echo .....Runing DIFF Backup.....Do not close this window.... echo ....... SQLCMD -E -S %SERVERNAME% -Q "BACKUP DATABASE [%DATABASENAME%] TO DISK='%BACKUPDIR%%DATABASENAME%_DIFF_MANUAL_%mytime%-%mydate%.bak' WITH DIFFERENTIAL,INIT, COMPRESSION, STATS = 10"
Join the community of 500,000 technology professionals and ask your questions.