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