Microsoft Product Life cycle - Support Dates

Products Released	Lifecycle Start Date	Mainstream Support End Date	Extended Support End Date	Service Pack Support End Date
SQL Server Compact 3.5	19/02/2008	09/04/2013	10/04/2018	13/10/2009
SQL Server Compact 3.5 Service Pack 1 for Windows Mobile	11/08/2008	Not Applicable	Not Applicable	12/07/2011
SQL Server Compact 3.5 Service Pack 2	29/06/2010	Review Note	Review Note
SQL Server Compact 4.0	13/04/2011	12/07/2016	13/07/2021
SQL Server Notification Services 2.0 Enterprise Edition	26/11/2002	08/01/2008	08/01/2013
SQL Server Notification Services 2.0 Standard Edition	26/11/2002	08/01/2008	08/01/2013
SQL Server 4.2 for OS/2	Not Available	36342	Not Applicable
SQL Server 6.0 Standard Edition	Not Available	36250	Not Applicable
SQL Server 6.5 Enterprise Edition	01/03/1998	38077	Not Applicable
SQL Server 6.5 Service Pack 1	31/12/1998	Not Applicable	Not Applicable	01/01/2002
SQL Server 6.5 Service Pack 2	15/09/2000	Not Applicable	Not Applicable
SQL Server 6.5 Service Pack 3	15/01/2000	Not Applicable	Not Applicable
SQL Server 6.5 Service Pack 4	Not Available	Not Applicable	Not Applicable	24/03/1999
SQL Server 6.5 Service Pack 5a	24/12/1998	Not Applicable	Not Applicable	31/03/2004
SQL Server 6.5 Standard Edition	30/06/1996	37257	Not Applicable
SQL Server 7.0 Enterprise Edition	01/03/1999	31/12/2005	11/01/2011
SQL Server 7.0 Service Pack 1	25/05/1999	Not Applicable	Not Applicable	31/03/2004
SQL Server 7.0 Service Pack 2	20/03/2000	Not Applicable	Not Applicable
SQL Server 7.0 Service Pack 3	Not Available	Not Applicable	Not Applicable	26/07/2002
SQL Server 7.0 Service Pack 4	26/04/2002	Review Note	Review Note
SQL Server 7.0 Standard Edition	01/03/1999	31/12/2005	11/01/2011
SQL Server 2000 64-bit Edition	30/11/2000	08/04/2008	09/04/2013	11/07/2002
SQL Server 2000 Desktop Engine	30/11/2000	08/04/2008	09/04/2013
SQL Server 2000 Desktop Engine Release A	29/01/2003	08/04/2008	09/04/2013
SQL Server 2000 Developer Edition	30/11/2000	08/04/2008	09/04/2013	11/07/2002
SQL Server 2000 Enterprise Edition	30/11/2000	08/04/2008	09/04/2013	11/07/2002
SQL Server 2000 Reporting Services Service Pack 1	22/09/2004	Not Applicable	Not Applicable	11/07/2006
SQL Server 2000 Reporting Services Service Pack 2	22/04/2005	Review Note	Review Note
SQL Server 2000 Service Pack 1	12/06/2001	Not Applicable	Not Applicable	28/02/2002
SQL Server 2000 Service Pack 2	30/11/2001	Not Applicable	Not Applicable	07/04/2003
SQL Server 2000 Service Pack 3a	07/01/2003	Not Applicable	Not Applicable	10/07/2007
SQL Server 2000 Service Pack 4	06/05/2005	Review Note	Review Note
SQL Server 2000 Standard Edition	30/11/2000	08/04/2008	09/04/2013	11/07/2002
SQL Server 2000 Windows CE Edition 2.0	16/12/2002	08/01/2008	08/01/2013
SQL Server 2000 Workgroup Edition	01/06/2005	08/04/2008	09/04/2013
SQL Server 2005 Compact Edition	19/02/2007	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Developer Edition	14/01/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Enterprise Edition	14/01/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Enterprise Edition for Itanium-based Systems	14/01/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Enterprise X64 Edition	14/01/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Express Edition	01/06/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Express Edition with Advanced Services	16/07/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Service Pack 1	18/04/2006	Not Applicable	Not Applicable	08/04/2008
SQL Server 2005 Service Pack 2	19/02/2007	Not Applicable	Not Applicable	12/01/2010
SQL Server 2005 Service Pack 3	15/12/2008	Not Applicable	Not Applicable	10/01/2012
SQL Server 2005 Service Pack 4	13/12/2010	Review Note	Review Note
SQL Server 2005 Standard Edition	14/01/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Standard Edition for Itanium-based Systems	14/01/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Standard X64 Edition	14/01/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2005 Workgroup Edition	14/01/2006	12/04/2011	12/04/2016	10/07/2007
SQL Server 2008 Developer	06/11/2008	08/07/2014	09/07/2019	13/04/2010
SQL Server 2008 Enterprise	07/11/2008	08/07/2014	09/07/2019	13/04/2010
SQL Server 2008 Express	11/11/2008	08/07/2014	09/07/2019	13/04/2010
SQL Server 2008 Express with Advanced Services	22/11/2008	08/07/2014	09/07/2019	13/04/2010
SQL Server 2008 R2 Datacenter	20/07/2010	08/07/2014	09/07/2019	10/07/2012
SQL Server 2008 R2 Developer	20/07/2010	08/07/2014	09/07/2019	10/07/2012
SQL Server 2008 R2 Enterprise	20/07/2010	08/07/2014	09/07/2019	10/07/2012
SQL Server 2008 R2 Express	20/07/2010	08/07/2014	09/07/2019	10/07/2012
SQL Server 2008 R2 Express with Advanced Services	20/07/2010	08/07/2014	09/07/2019	10/07/2012
SQL Server 2008 R2 Parallel Data Warehouse	09/11/2010	08/07/2014	09/07/2019
SQL Server 2008 R2 Service Pack 1	12/07/2011	Not Applicable	Not Applicable	08/10/2013
SQL Server 2008 R2 Service Pack 2	26/07/2012	Review Note	Review Note
SQL Server 2008 R2 Standard	20/07/2010	08/07/2014	09/07/2019	10/07/2012
SQL Server 2008 R2 Standard Edition for Small Business	20/07/2010	08/07/2014	09/07/2019	10/07/2012
SQL Server 2008 R2 Web	20/07/2010	08/07/2014	09/07/2019	10/07/2012
SQL Server 2008 R2 Workgroup	20/07/2010	08/07/2014	09/07/2019	10/07/2012
SQL Server 2008 Service Pack 1	31/03/2009	Not Applicable	Not Applicable	11/10/2011
SQL Server 2008 Service Pack 2	24/09/2010	Not Applicable	Not Applicable	09/10/2012
SQL Server 2008 Service Pack 3	06/10/2011	Review Note	Review Note
SQL Server 2008 Standard	06/11/2008	08/07/2014	09/07/2019	13/04/2010
SQL Server 2008 Standard Edition for Small Business	06/11/2008	08/07/2014	09/07/2019	13/04/2010
SQL Server 2008 Web	06/11/2008	08/07/2014	09/07/2019	13/04/2010
SQL Server 2008 Workgroup	06/11/2008	08/07/2014	09/07/2019	13/04/2010
SQL Server 2012 Business Intelligence	20/05/2012	11/07/2017	12/07/2022
SQL Server 2012 Developer	20/05/2012	11/07/2017	12/07/2022
SQL Server 2012 Enterprise	20/05/2012	11/07/2017	12/07/2022
SQL Server 2012 Enterprise Core	20/05/2012	11/07/2017	12/07/2022
SQL Server 2012 Express	20/05/2012	11/07/2017	12/07/2022
SQL Server 2012 Standard	20/05/2012	11/07/2017	12/07/2022
SQL Server 2012 Web	20/05/2012	11/07/2017	12/07/2022

More information on http://support.microsoft.com/lifecycle/#ServicePackSupport

DAC - SQLCMD

sqlcmd -A -d master  -E -S A**T*66

sqlcmd -A -d master  -U sa  -P *****

One More - Script To Shrink Log Files

DBCC SQLPERF(logspace) --Optional
GO
DECLARE @logsize AS INT = 0; -- MB
DECLARE @databasename AS VARCHAR(256);
DECLARE @filename VARCHAR(256);
DECLARE @cmd VARCHAR(MAX);
DECLARE curdb CURSOR FOR
    SELECT f.name AS filename, d.name AS databasename
    FROM msdb.sys.master_files f
        INNER JOIN master.sys.sysdatabases d
        ON d.dbid = f.database_id
    WHERE type = 1 AND state = 0 AND size > @logsize AND database_id > 4  
OPEN curdb
FETCH NEXT FROM curdb INTO @filename, @databasename
WHILE @@FETCH_STATUS = 0
BEGIN
    --PRINT @filename
    SET @cmd = ('USE [' + @databasename + ']; ')
    SET @cmd = @cmd + 'DBCC SHRINKFILE ([' + @filename + '], ' + CAST(@logsize AS VARCHAR) + ');';
    EXEC (@cmd)
    FETCH NEXT FROM curdb INTO @filename, @databasename
END
DEALLOCATE curdb
GO
DBCC SQLPERF(logspace) --Optional If you require to send out put in file
GO

The row was not found at the Subscriber when applying the replicated command.

Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x000210C100000223000D00000000, Command ID: 8)


Ex:

Step 1 :-

Connect to the Distributor

select * from dbo.MSarticles

where article_id IN (SELECT Article_id from MSrepl_commands

where xact_seqno =  0x000210C100000223000D00000000 )


Step 2 :- 
 

exec sp_browsereplcmds @xact_seqno_start = '0x0013DD67000002EA007F00000000'
,@xact_seqno_end = '0x0013DD67000002EA007F00000000'
,@publisher_database_id = xxx
,@article_id = xxx
,@command_id= '8'

Step 3:- 

If data is in sync, do skip errors

For replication Errors,

select 

* 

From distributor..MSrepl_errors

Select * from MSrepl_commands Where xact_seqno>'0x0000000000000000000000000000'

Which will give the article details and issues.

SQL Server Memory Management Architecture

Memory Architecture  :-  Describes how SQL Server dynamically manages memory.

Process Address Space  :- Describes the amount of physical and virtual memory available to applications.

Dynamic Memory Management :-  Describes how SQL Server manages memory for the buffer pool.

Effects of min and max server memory :- Describes the effects of the min and max server memory options.

Memory Used by SQL Server Objects Specifications :- Describes the approximate amount of memory used by different objects in SQL Serverr.

Buffer Management :- Contains information about how the buffer manager accesses and updates data pages.

Managing Memory for Large Databases :-  Contains information about specialized memory settings, such as Address Windowing Extensions (AWE) memory, that allow you to take advantage of the latest hardware.


Understanding Non-uniform Memory Access :- Contains information about non-uniform memory access (NUMA) and how SQL Server uses it.


Find More On  http://msdn.microsoft.com/en-us/library/cc280359(v=sql.105).aspx

Cluster group

Cluster group

The cluster group command is used to create a new cluster group or administer an existing group. Used without parameters, cluster group defaults to the /status command-line option and displays the status for a group.

Syntax

cluster [[/cluster:]ClusterName] group GroupName /Option

Parameters

/node: NodeName

Specifies the node that owns the group.

/stat[us]

Displays the status of a group (online, offline, or Partially Online).

/create

Creates a new group.

/delete

Deletes a group.

/ren[ame]:NewGroupName

Renames a group.

/move[to][:NodeName] [/wait[:Timeout_in_Seconds]]

Moves a group to another node.

/on[line][:NodeName] [/wait[:Timeout_in_Seconds]]

Brings a group online.

/off[line][:NodeName] [/wait[:Timeout_in_Seconds]]

Takes a group offline.

/prop[erties] [PropertyList]

Views or sets the group common properties.

/priv[properties] [PropertyList]

Views or sets the group private properties.

/listowners

Displays a list of preferred owners.

/setowners: NodeName[,NodeName ...]

Specifies a preferred owner.

/?

Displays help at the command prompt.

Remarks

• Using the cluster group command
  
  The cluster name is optional. If the name of your cluster is also a cluster command or its abbreviation, such as "cluster" or "group," use /cluster: to explicitly specify the cluster name. For a list of all the cluster commands, see Related Topics.
  
  With /move[to], /online, and /offline, the command-line option /wait[:Timeout_in_Seconds] specifies how long Cluster.exe waits before canceling the command if it does not successfully complete. If you do not use the /wait option with the /move[to] command, Cluster.exe waits 20 seconds. If you do not use the /wait option with the /offline or /online commands, Cluster.exe waits 10 seconds. For the /move[to], /online, or /offline commands, if you use /wait without specifying a time-out period, Cluster.exe waits indefinitely or until the group state changes.
  
  If a node name is not specified, the Cluster service will automatically select a node following the move and failover logic described in Determining failover and move policies for groups.
  
• Using the /stat[us] command-line option
  
  The group name is optional. If you do not provide a group name, status for all groups is displayed.
  
• Using the /prop[erties] [PropertyList] command-line option
  
  The group name is optional. Properties for all groups are displayed if group name is not provided. For more information on property lists, see Related Topics.
  
• Using the /priv[properties] [PropertyList] command-line option
  
  The group name is optional. Private properties for all groups are displayed if you do not provide a group name. For more information on property lists, see Related Topics.
  
• Using cluster group common property names
  
  The following table describes the common cluster group property names, their uses, and valid settings:

 More on :-  http://technet.microsoft.com/en-us/library/cc783967%28v=ws.10%29

Database Logshipping - Sql 2008

Introducing Sub-Minute Log Shipping in SQL Server 2008

SQL Server 2008 enables log shipping jobs to be scheduled with frequency in seconds. In SQL Server 2008, SQL Server Management Studio and the stored procedures sp_add_jobschedule and sp_add_schedule allow frequency settings in seconds, minutes, and hours. The minimum frequency is 10 seconds.