Alter failed for Database 'DBNAME'. (Microsoft.SqlServer.Smo), The server network address "TCP:/win.abc.com:5023" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

Solution :-
========

1. Change the SQL Server Service Accounts and Agent Accounts to domain accounts.



2. Once this is done, start Mirroring.

3. To check the endpoints.

SELECT name, protocol_desc, port, state_desc FROM sys.tcp_endpoints

WHERE type_desc = 'DATABASE_MIRRORING'

Remove Mirroring

Alter Database DBNAME Set PARTNER OFF
==================================

Memory available to SQL Server instance _PER_ machine

SQL Server 2000 Script:
====================

-- To get the total physical memory installed on SQL Server
CREATE TABLE #OS_Available_Memory (
     ID [int]
    ,NAME [sysname]
    ,Physical_Memory_In_MB [int]
    ,Physical_Memory_In_Bytes [nvarchar](512))

INSERT #OS_Available_Memory
EXEC [master]..[xp_msver]

SELECT [Name], [Physical_Memory_In_MB], [Physical_Memory_In_Bytes]
FROM #OS_Available_Memory
WHERE NAME = 'PhysicalMemory'
GO

DROP TABLE #OS_Available_Memory

--To get the minimum and maximum size of memory configured for SQL Server
SELECT * FROM [master]..[sysconfigures]
WHERE [comment] IN ('Minimum size of server memory (MB)'
                   ,'Maximum size of server memory (MB)')



SQL Server 2005 Script:
====================

-- To get the total physical memory installed on SQL Server
SELECT physical_memory_in_bytes / 1024 / 1024 AS [Physical_Memory_In_MB]
      ,virtual_memory_in_bytes / 1024 / 1024 AS [Virtual_Memory_In_MB]
FROM [master].[sys].[dm_os_sys_info]

--To get the minimum and maximum size of memory configured for SQL Server
SELECT [name] AS [Name]
      ,[configuration_id] AS [Number]
      ,[minimum] AS [Minimum]
      ,[maximum] AS [Maximum]
      ,[is_dynamic] AS [Dynamic]
      ,[is_advanced] AS [Advanced]
      ,[value] AS [ConfigValue]
      ,[value_in_use] AS [RunValue]
      ,[description] AS [Description]
FROM [master].[sys].[configurations]
WHERE NAME IN ('Min server memory (MB)'
              ,'Max server memory (MB)')




SQL Server 2008/200R2 and SQL Server 2012 Script:
======================================

-- To get the total physical memory installed on SQL Server
SELECT [total_physical_memory_kb] / 1024 AS [Total_Physical_Memory_In_MB]
      ,[available_page_file_kb] / 1024 AS [Available_Physical_Memory_In_MB]
      ,[total_page_file_kb] / 1024 AS [Total_Page_File_In_MB]
      ,[available_page_file_kb] / 1024 AS [Available_Page_File_MB]
      ,[kernel_paged_pool_kb] / 1024 AS [Kernel_Paged_Pool_MB]
      ,[kernel_nonpaged_pool_kb] / 1024 AS [Kernel_Nonpaged_Pool_MB]
      ,[system_memory_state_desc] AS [System_Memory_State_Desc]
FROM [master].[sys].[dm_os_sys_memory]

--To get the minimum and maximum size of memory configured for SQL Server.
SELECT [name] AS [Name]
      ,[configuration_id] AS [Number]
      ,[minimum] AS [Minimum]
      ,[maximum] AS [Maximum]
      ,[is_dynamic] AS [Dynamic]
      ,[is_advanced] AS [Advanced]
      ,[value] AS [ConfigValue]
      ,[value_in_use] AS [RunValue]
      ,[description] AS [Description]
FROM [master].[sys].[configurations]
WHERE NAME IN ('Min server memory (MB)'
              ,'Max server memory (MB)')


- Thanks to author, saved mytime and others too.

LogShipping Changing Roles PRIMARY TO SECONDARY

- > Connect to the instances-PRI Server and Secondary Server

-> Disable the log shipping backup job on the primary server.

-> On the standby server, run the log shipping copy and restore jobs to restore any remaining transaction log backups.

-> Disable the log shipping copy and restore jobs on the secondary server.

-> On the primary server, create on last transaction log backup using the NORECOVERY option.

-> On the standby server, restore this transaction log backup using the RECOVERY option.

-> On the standby server (which will now be the primary server), right click on the database and select Properties 

-> Transaction Log Shipping.  Enable the database to become the primary database and configure the backup and secondary server settings.