table databackup with data

Question

Hello All,

I am using Microsift SQL Server Management Studio 2005.

I want to take table backup with data.

How to do this ?

Is it possible with SQL Server Management Studio 2005 ?

Is there any data back up software ?

Thanks in advance.

Answer 1

SQL Server Database Enginge has a backup feature that you can use to save a copy of the database .mdf file to another disk.  You can also replicate a database to another instance for failover protection.  See SQL Server Books Online for details.

Answer 2

Hello,

It's not possible to backup a single table, you cab only backup the complete database.

You could only export the data to a file together the the create script for the table+related objects,

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing