SQL表复制与备份还原

--如果目的表已经存在:
insert into DATAHR.DBO.GBITEM
select * from DEMO.DBO.GBITEM
--如果目的表不存在:
select * into DATAHR.DBO.GBITEM
from DEMO.DBO.GBITEM
--跨库导入
select * into [zk_news].[dbo].[News1] from [zk_media].[dbo].[News]


--备份数据库OFSys
BACKUP DATABASE OFSys to disk = 'e:/OFSys'
还原
restore database test from disk = 'c:\test'