User Tools

Site Tools


software:microsoft:sqlserver

This is an old revision of the document!


Hiding and Showing a SQL Instance on the Network

From: http://www.jameswiseman.com/blog/2012/02/22/hiding-and-showing-a-sql-instance-network/

SQL Server Properties
In Management Studio, click on the server root, and select properties.
From the resulting dialog, select the ‘Connections’ page.
Ensure the checkbox “Allow remote connections to this server” is checked.
SQL Server Configuration
Run SQL Server Configuration Manager (located in within the SQL shortcuts under the windows start menu)
Navigate to “SQL Server Network Configuration” and then “Protocols for SQL2008R2”
Ensure TCP/IP is “Enabled”
Right-click on “Protocols for SQL2008R2” and select “Properties”
Ensure “Hide Instance” is set to “no”
 SQL Browser Service
Navigate to the Service Control Manager through control panel (or run “Services.msc”)
Ensure the “SQL Server Browser” service is started. (It may be best to have the Startup Type as “Automatic”

Backup Overview (SQL Server)

From: https://msdn.microsoft.com/en-us/library/ms175477.aspx

This topic introduces the SQL Server backup component. Backing up your SQL Server database is 
essential for protecting your data. This discussion covers backup types, and backup restrictions. 
The topic also introduces SQL Server backup devices and backup media.
software/microsoft/sqlserver.1488348094.txt.gz · Last modified: 2017/03/01 06:01 by superwizard