从VB.NET 2010进行SQL备份和还原 [英] SQL BACKUP AND RESTORE FROM VB.NET 2010

问题描述

你好！

我需要vb.net的帮助！

如何使用SQLSERVER.SMO备份数据库！我没有从哪里开始，我已经在codeproject中看到了示例，但是我需要一种简单的方法，即单击i按钮意味着！我还需要以一种简单的方式进行还原！


非常感谢！

Hello!

I need help in vb.net!

How can i do a backup of database with SQLSERVER.SMO! I dont no where to start , i have seen example in codeproject but i need a siple way wich it means on click i button! also i need a restore in a simple way !


Thanks a lot!

推荐答案

hii

您可以使用sqlcommand执行这些脚本

用于备份

hii

You can execute these scripts with sqlcommand

for backup

BACKUP DATABASE [Database name] TO DISK = N'Backup file path' WITH NOFORMAT, NOINIT,  NAME = N'Database backup name', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

恢复

for restore

ALTER DATABASE [Database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

RESTORE DATABASE [Database name] FROM DISK=N'Backup file path'

ALTER DATABASE [Database name] SET MULTI_USER

确保CommandTimeout足以返回或还原

Make sure that CommandTimeout is enough for back or restore

以下是一些示例:
使用C#和.NET 2.0的SQL Server 2005数据库备份和还原 [ C#中的备份实用程序 [

Here are some examples:
SQL Server 2005 Database Backup and Restore using C# and .NET 2.0[^]
Backup Utility in C#[^]

这篇关于从VB.NET 2010进行SQL备份和还原的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！