Snapshot database in SQL Server

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 […]

Read more
Reset SA Password in Sql Server 2012

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, […]

Read more
Enable remote connections for SQL Server Express 2012

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 […]

Read more
TCP IP Port in SQL Server 2012 and Firewall

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 […]

Read more

Hit Counter provided by dental implants orange county