大家看这条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