backup single table - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

backup single table

backup single table# Database - 数据库

m*92010-06-08 07:06

1 楼

I am new to MSSQL. Can anyone tell me how to backup a single table? It is
system table msdb. I'll need to backup few table from msdb.
Thank you

i*a2010-06-08 07:06

2 楼

easiest way is to export the data into a file.
or copy the table into another table or database by
select *
into anotherDatabase..
from msdb..

【在 m******9 的大作中提到】

: I am new to MSSQL. Can anyone tell me how to backup a single table? It is
: system table msdb. I'll need to backup few table from msdb.
: Thank you