注意一下恢复时的源文件路径和恢复到的路径是否正确
RESTORE FILELISTONLY 命令可以帮助查看源文件路径
如
RESTORE FILELISTONLY
from disk='f:\tdmis.bak' 结果为
tdmis_Data e:\database\tdmis.mdf D PRIMARY 497221632 35184372080640
tdmis_Log e:\database\tdmis_log.ldf L NULL 1048576 35184372080640
然后用restore databae tdmis
from disk='f:\tdmis.bak'
with NORECOVERY,
move 'tdmis_Data' to 'd:\database\tdmis.mdf',
move 'tdmis_Log to 'd:\database\tdmis_log.ldf'
就可以了
DBCC results for 'sysobjects'.
There are 146 rows in 3 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 100 rows in 4 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 774 rows in 14 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 24 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 199 rows in 28 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 37 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 15 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysdepends'.
There are 414 rows in 2 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysallocations'.
There are 1 rows in 1 pages for object 'sysallocations'.
DBCC results for 'invite_cn'.
There are 58 rows in 20 pages for object 'invite_cn'.
DBCC results for 'leavemess'.
There are 2 rows in 1 pages for object 'leavemess'.
DBCC results for 'user_inner'.
There are 15 rows in 2 pages for object 'user_inner'.
DBCC results for 'dtproperties'.
There are 0 rows in 1 pages for object 'dtproperties'.
DBCC results for 'pic'.
There are 0 rows in 1 pages for object 'pic'.
DBCC results for 'class_en'.
There are 31 rows in 1 pages for object 'class_en'.
DBCC results for 'invite_en'.
There are 58 rows in 20 pages for object 'invite_en'.
DBCC results for 'news_en'.
There are 77 rows in 7 pages for object 'news_en'.
DBCC results for 'produce_class1_en'.
There are 5 rows in 1 pages for object 'produce_class1_en'.
DBCC results for 'produce_class2_cn'.
There are 8 rows in 2 pages for object 'produce_class2_cn'.
DBCC results for 'produce_class2_en'.
There are 8 rows in 1 pages for object 'produce_class2_en'.
DBCC results for 'up_file'.
There are 20 rows in 2 pages for object 'up_file'.
DBCC results for 'produce_en'.
There are 7 rows in 7 pages for object 'produce_en'.
DBCC results for 'lanmuclass'.
There are 12 rows in 1 pages for object 'lanmuclass'.
DBCC results for 'class_cn'.
There are 31 rows in 1 pages for object 'class_cn'.
DBCC results for 'contract'.
There are 11 rows in 3 pages for object 'contract'.
DBCC results for 'news_cn'.
There are 77 rows in 9 pages for object 'news_cn'.
DBCC results for 'guocheng'.
There are 70 rows in 7 pages for object 'guocheng'.
DBCC results for 'produce_cn'.
There are 5 rows in 5 pages for object 'produce_cn'.
DBCC results for 'produce_class1_cn'.
There are 5 rows in 1 pages for object 'produce_class1_cn'.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'secri_sh'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.