通过restore database时重命名数据库rename database

backup database testdb to disk='c:\testdb_ful.bak' with compression

backup log testdb to disk='c:\testdb_ful.trn' with compression

restore filelistonly from disk='c:\testdb_ful.bak'

restore database newtestdb from disk='c:\testdb_ful.bak'
with move 'testdb' to 'c:\newtestdb.mdf'
,move 'testdb_log' to 'c:\newtestdb_log.ldf'
,replace,norecovery

restore database newtestdb from disk='c:\testdb_ful.trn'
with replace,recovery

上一篇:图像特征提取三大法宝:HOG特征,LBP特征,Haar特征


下一篇:ExtJs3带条件的分页查询的实现