询问Google [ ^ ]

您好，



您可以使用以下链接。



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



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'