数据库还原 下载的源码中有一个Sql Server数据库的备份文件,当然它不是MDF的,而是无后缀名的备份文件,哪位好人帮帮忙怎么还原啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 直接调用sql server的命令。查一下哪一个命令 --To restore a complete database from a full database backup (a Complete Restore):RESTORE DATABASE { database_name | @database_name_var } [ FROM <backup_device> [ ,...n ] ][ WITH [ { CHECKSUM | NO_CHECKSUM } ] [ [ , ] { STOP_ON_ERROR | CONTINUE_AFTER_ERROR } ] [ [ , ] FILE = { backup_set_file_number | @backup_set_file_number } ] [ [ , ] KEEP_REPLICATION ] [ [ , ] MEDIANAME = { media_name | @media_name_variable } ] [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ] [ [ , ] MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name' ] [ ,...n ] [ [ , ] PASSWORD = { password | @password_variable } ] [ [ , ] BLOCKSIZE = { blocksize | @blocksize_variable } ] [ [ , ] BUFFERCOUNT = { buffercount | @buffercount_variable } ] [ [ , ] MAXTRANSFERSIZE = { maxtransfersize | @maxtransfersize_variable } ] [ [ , ] ENABLE_BROKER ] [ [ , ] ERROR_BROKER_CONVERSATIONS ] [ [ , ] NEW_BROKER ] [ [ , ] { RECOVERY | NORECOVERY | STANDBY = {standby_file_name | @standby_file_name_var } } ] [ [ , ] REPLACE ] [ [ , ] RESTART ] [ [ , ] RESTRICTED_USER ] [ [ , ] { REWIND | NOREWIND } ] [ [ , ] { UNLOAD | NOUNLOAD } ] [ [ , ] STATS [ = percentage ] ] [ [ , ] { STOPAT = { 'date_time' | @date_time_var } | STOPATMARK = { 'lsn:lsn_number' } [ AFTER 'datetime' ] | STOPBEFOREMARK = { 'lsn:lsn_number' } [ AFTER 'datetime' ] } ] ][;] 2楼 的大哥,这些命令怎么没办法执行啊 ! 错误提示:[Microsoft][ODBC SQL Server Driver]语法错误或违反访问规则 选2005中的设备那项,然后再选中BAT这个文件就可以了。 数据库右键-->还原数据库-->选中备分数据库这样不行吗? C# consoleappliction里面调用matlab转过来的dll遇到点问题 C# 文字绘制成图片时,文本对齐 程序安装问题!!! sharpdevelop怎样编译单个C#文件 listview的显示数据的问题 在数据库中增加一条记录有没办法可以发送个消息给cache? -=代表什么意思(是下划线) C#中线程问题 点button2不能暂时停止线程 要一直执行完毕后,才自动停止? 我要提问 散分,兄弟自己建立了一个增值业务的BBS,欢迎大家去捧捧场 如何下Microsoft Visual Studio Express Editions 窗体不能响应keydown事件
RESTORE DATABASE { database_name | @database_name_var }
[ FROM <backup_device> [ ,...n ] ]
[ WITH
[ { CHECKSUM | NO_CHECKSUM } ]
[ [ , ] { STOP_ON_ERROR | CONTINUE_AFTER_ERROR } ]
[ [ , ] FILE = { backup_set_file_number | @backup_set_file_number } ]
[ [ , ] KEEP_REPLICATION ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword |
@mediapassword_variable } ]
[ [ , ] MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name' ]
[ ,...n ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] BLOCKSIZE = { blocksize | @blocksize_variable } ]
[ [ , ] BUFFERCOUNT = { buffercount | @buffercount_variable } ]
[ [ , ] MAXTRANSFERSIZE = { maxtransfersize | @maxtransfersize_variable } ]
[ [ , ] ENABLE_BROKER ]
[ [ , ] ERROR_BROKER_CONVERSATIONS ]
[ [ , ] NEW_BROKER ]
[ [ , ] { RECOVERY | NORECOVERY | STANDBY =
{standby_file_name | @standby_file_name_var }
} ]
[ [ , ] REPLACE ]
[ [ , ] RESTART ]
[ [ , ] RESTRICTED_USER ]
[ [ , ] { REWIND | NOREWIND } ]
[ [ , ] { UNLOAD | NOUNLOAD } ]
[ [ , ] STATS [ = percentage ] ]
[ [ , ] { STOPAT = { 'date_time' | @date_time_var }
| STOPATMARK = { 'lsn:lsn_number' }
[ AFTER 'datetime' ]
| STOPBEFOREMARK = { 'lsn:lsn_number' }
[ AFTER 'datetime' ]
} ]
]
[;]
错误提示:[Microsoft][ODBC SQL Server Driver]语法错误或违反访问规则
这样不行吗?