如何使用ASP.NET恢复数据库备份 [英] how to restore database backup in with ASP.NET

问题描述

如何使用C＃，ASP.NET恢复数据库备份。当我用以下查询恢复数据库时



从磁盘恢复数据库SISDB =''C：\\SQLServerBackups \\TEST.bak''WITH移动''测试''到'C：\\Program Files \\ Microsoft Microsoft SQL Server \\ MSSQL10_50.MSSQLSERVER \\ MSSQL \\DATA \\TEST.mdf'' ，移动''TEST_log''到''C：\\Program Files \\ Microsoft Microsoft SQL Server \\ MSSQL10_50.MSSQLSERVER \\ MSSQL \\DATA \\TEST_log.ldf' '





然后我收到了这个错误： - 因为数据库正在使用中无法获得独占访问权限.RESTORE DATABASE是终止异常。



请帮我解决这个问题....

how to restore database backup in with C#,ASP.NET. when i restore the database with below query

"RESTORE DATABASE SISDB FROM DISK = ''C:\\SQLServerBackups\\TEST.bak'' WITH MOVE ''TEST'' TO ''C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\TEST.mdf'', MOVE ''TEST_log'' TO ''C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\TEST_log.ldf''"


then i got this error :- "Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally."

Please help me to resolve this....

推荐答案

你好朋友，

请查看此链接，它可能会帮助您..



http://stackoverflow.com/questions/4046708/exclusive-access-could-not-be-obtained-because-the -database-is-use [ ^ ]





http://blog.sqlauthority.com/2007 / 02/25 / sql-server-restore-database-backup-using-sql-script-t-sql / [ ^ ]

Hello friend,
please review this links, it might helps you out..

http://stackoverflow.com/questions/4046708/exclusive-access-could-not-be-obtained-because-the-database-is-in-use[^]


http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/[^]

这篇关于如何使用ASP.NET恢复数据库备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！