日期:2014-05-17  浏览次数:20596 次

大家看这条sql数据库还原语句哪儿错了??应该怎么改?
BACKUP LOG [d:\我的文档\Visual Studio 2008\Projects\biyesheji_lzp\biyesheji_lzp\db_kehu.mdf] TO 'C:\khzy.bak' WITH NORECOVERY use master restore database [d:\我的文档\Visual Studio 2008\Projects\biyesheji_lzp\biyesheji_lzp\db_kehu.mdf] from disk='C:\khzy.bak'


------解决方案--------------------
你查下with的用法!
------解决方案--------------------
BACKUP LOG [d:\我的文档\Visual Studio 2008\Projects\biyesheji_lzp\biyesheji_lzp\db_kehu.mdf] 
TO 'C:\khzy.bak' WITH NORECOVERY
go
 use master 
restore database [d:\我的文档\Visual Studio 2008\Projects\biyesheji_lzp\biyesheji_lzp\db_kehu.mdf] 
 from disk='C:\khzy.bak'
go

------解决方案--------------------
restore database 这里加上dbname [d:\我的文档\Visual Studio 2008\Projects\biyesheji_lzp\biyesheji_lzp\db_kehu.mdf]
 from disk='C:\khzy.bak'
——————————————————————————
restore database 这里加上dbname [d:\我的文档\Visual Studio 2008\Projects\biyesheji_lzp\biyesheji_lzp\db_kehu.mdf]
 from disk='C:\khzy.bak' WITH NORECOVERY放在这里
------解决方案--------------------
我也是刚学,不知道是不是 BACKUP LOG [d:\我的文档\Visual Studio 2008\Projects\biyesheji_lzp\biyesheji_lzp\db_kehu.mdf] 
TO disk= 'C:\khzy.bak' WITH NORECOVERY