What is a database snapshot ? Database snapshots are an Enterprise only feature which was introduced  in SQL Server 2005.A database snapshot is a view of what the source database looked like at the time when the snapshot was created. How does a snapshot work:- a. When you create a snapshot a sparse file is […]

Step 1:- Change SQL SA password from a command prompt Go to the command prompt of the server and type in command prompt osql –L C:\Users\Administrator>osql -L Servers: localhost Step 2:- Copy full name of SQL Server and type: OSQL -S <insert_servername_here> -E C:\Users\Administrator>osql -S localhost -E Step 3:- Execute the following query: sp_password NULL, […]

On my installation of SQL Server 2012 Developer Edition, installed with default settings, I just had to load the SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER and change TCP/IP from Disabled to Enabled.   down voteaccepted Well, glad I asked. The solution I finally discovered was here: How do […]

TCP IP Port in SQL Server 2012 As an SQL Server Administrator you might need to find SQL Server TCP IP port configured for your SQL Server Instance. There are many reason to find it but most famous reasons is to give access to developer and set firewall exception if there is any. Generally 1433 […]