Thanks all,

I will do the same and get back for further suggestion.

Rajnish

I can understand that partition table is advance topic.

I have two tables, each table size is around more than 2 GB. Tables normally used for reporting purpose and noncluster indexes...

FINDING 4TH HIGHEST SALARY:-

CREATE TABLE SALARY (ID BIGINT,SALARY BIGINT)

GO

INSERT INTO SALARY (ID,SALARY) VALUES (1,200)

INSERT INTO SALARY (ID,SALARY) VALUES (2,300)

INSERT INTO SALARY (ID,SALARY) VALUES (3,400)

INSERT INTO SALARY (ID,SALARY) VALUES (4,500)

INSERT INTO...

But I think Logbackup can break LSN no. used in logshipping.