SQLCMD Archives - SQLServerGeeks

SQL Server / SQL Server Accidental DBA Series

Script to find all SQL Servers on network

December 5, 2014December 20, 2019 - by SQL Geek - Leave a Comment

Many a times we are required to find SQL Server installations across local network. This blog provides a script to find all SQL Servers on network using SQLCMD. It’s a very …

SQL Server / SQL Server Accidental DBA Series

Restore SQL Server database from bak file command line

October 10, 2014December 23, 2019 - by SQL Geek - 1 Comment

Here is a script to restore SQL Server database from bak file command line. This is done via SQLCMD through command line. The first thing is to open up the command …