backup a table and restore
Dear experts,
Can a single table be restored in Sql Server.
What is the best way to take a backup of a single table?
can the above be done without using Enterprise Manager, say using Querry Analyzer.
many thanks
Can a single table be restored in Sql Server.
What is the best way to take a backup of a single table?
can the above be done without using Enterprise Manager, say using Querry Analyzer.
many thanks
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you cannot restore a single table.
you CAN restore a single filegroup.
so IF and ONLY if your table is the ONLY one in a filegroup you can restore that filegroup and hence restore that table...
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#E3GAG
you CAN restore a single filegroup.
so IF and ONLY if your table is the ONLY one in a filegroup you can restore that filegroup and hence restore that table...
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#E3GAG
ASKER
How do i restore a single table from the file group, command please.