May 10, 2010 at 10:51 pm
Hi All,
can anyone tell me how can i take the backup of only on e object in a database, like just one table
May 11, 2010 at 1:42 am
You can't with the native tools. Best you can do with the native tools is a file backup (backup of a single database file). Check the requirements and limitations on Books Online if you go that route.
Otherwise you could bcp the file out to a csv.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 11, 2010 at 2:13 am
Also if you just wanted to make a copy of it you could always "select * into table2 from table1"
to the same database or another, wont help if you actually want a file on the file system though
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply