fine... arul

infodynamic as .net developer

I am also chennai only...

Hi, Try following links Using SMO for Backup, Restore and Security Purposes[^] SQL Server 2005 Database Backup and Restore using C# and .NET 2.0[^]

Hi, Try sync Framework Reference : http://msdn.microsoft.com/en-us/library/bb902853.aspx[^]

Hi, Try below If you want page index 1 (between 10-9 and 10) page index 2 (between 20-9 and 20) . . page index 25 (between 250-9 and 250) SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY OBJECT_ID) AS [PageIndex],* FROM sys.objects ) AS TB1 WHERE PageIndex BETWEEN 10-9 AND 10