csstome 发表于 2013-1-26 13:51:53

TSQL备份还原数据库

USE GOALTER DATABASE SET RECOVERY SIMPLE;GODBCC SHRINKFILE (2,2);GOALTER DATABASE SET RECOVERY FULL;GODBCC SHRINKDATABASE('cm');GOBACKUP DATABASE    TO DISK = 'C:\Share\CM.bak'
RESTORE DATABASE cmFROM DISK='C:\CM.bak'
页: [1]
查看完整版本: TSQL备份还原数据库