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