Six way to find how many instance are running on your Server.
- SQL Server Configuration Manager
- Services. Msc
- SQL CMD
- Detailed file
- Summary.txt
- Discovery Report
1) SQL Server
Configuration Manager
2) Services. MSc
Type services. Msc in
run and enter
3 ) SQL CMD
4) Detailed file
C:\Program Files\Microsoft SQL Server\100\Setup
Bootstrap\Log\20150317_225942
5) Summary.txt
C:\Program Files\Microsoft SQL Server\100\Setup
Bootstrap\Log
6) Discovery Report
This most interesting way to find instance
and edition just go your SQL Server Setup media and click on setup.exe and click on the tool and select Installed "SQL Server feature discovery" option
Please let me know if any other way as well if i miss anyone here :)
No comments:
Post a Comment