读书人

大家看这条sql数据库还原语句哪儿错了

发布时间: 2012-11-09 10:18:48 作者: rapoo

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

读书人网 >SQL Server

热点推荐