You can export a single table to a flat file, MS Excel or MS Access and use that to restore. There are also 3rd party products you can purchase to give you more control over backups and backup single tables.
The backup in SQL Server 2005 doesn't give you the ability to directly backup just a table. However, you can put a table in its own file group and then do a file group back. On Tue, Sep 30, 2008 at 4:42 AM, vanitha palanisamy <[EMAIL PROTECTED]>wrote: > Hi > Am not asking programatically.In Sql Server 2000 we have option to backup > particular tables na,like tat can i take backup in sql2005. > > ya i can export from one server to the other but i need to run tat in > local machine thats available in different location. > > > On 9/30/08, AstroDrabb <[EMAIL PROTECTED]> wrote: > >> Are you talking programmatically or from SQL Server 2005? From SQL 2005 >> just export from one server to the other. >> >> Programmatically, look up DataSet, DataRow and DataColumn. >> >> >> >> On Mon, Sep 29, 2008 at 10:00 AM, vanitha palanisamy <[EMAIL PROTECTED] >> > wrote: >> >>> hi >>> Can anyone say how to capy the structure and data of one table from one >>> DB server to another database server in sqlserver2005. >>> >> >> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx <p><a href="http://feeds.feedburner.com/DotNetDevelopment";><img src="http://feeds.feedburner.com/~fc/DotNetDevelopment?bg=99CCFF&fg=444444&anim=1"; height="26" width="88" style="border:0" alt="" /></a></p> -~----------~----~----~----~------~----~------~--~---
