如何在C＃中恢复备份sql server数据库 [英] How to Restore backup sql server database in C#

问题描述

大家好，

有人可以帮我解决如何在Asp.Net C＃（Web应用程序）中恢复和备份Sql server数据库。



谢谢，

Naveen sharma

Hi All,
Can some one please help me how to do Restore and backup of Sql server database in Asp.Net C# (Web application).

Thanks,
Naveen sharma

推荐答案

询问Google [ ^ ]

您好，



您可以使用以下链接。



http：// cavedweller92 .wordpress.com / 2012/12/13 / create-backup-restoring-database-in-mssql-asp-net-c-2 / [ ^ ]



< br $> b $ b

http://www.c-sharpcorner.com/Blogs/8679/backup-and-restore-the-database-in-Asp-Net-web-application.aspx [ ^ ]

Hi,

you can use below links.

http://cavedweller92.wordpress.com/2012/12/13/create-backup-restoring-database-in-mssql-asp-net-c-2/[^]



http://www.c-sharpcorner.com/Blogs/8679/backup-and-restore-the-database-in-Asp-Net-web-application.aspx[^]

尝试这可能会帮助您在Sql Server 2012中为我工作

try this may it will help you this Work for me in Sql Server 2012

USE Database_Name
BACKUP DATABASE DataBase_Name TO DISK = File_Path WITH FORMAT,MEDIANAME = 'Z_SQLServerBackups',NAME = 'Full Backup of DataBase_Name';

和用于恢复它使用以下查询



使用Master

RESTORE DATABASE Database_Name FROM DISK ='file_Path'

and for resoring it use below query

Use Master
RESTORE DATABASE Database_Name FROM DISK = 'file_Path'

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