备份sql server数据库 [英] backup sql server database
本文介绍了备份sql server数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想备份一个SQL Server数据库,我的问题是,如果我想用查看并使用恢复连接到数据库时使用vb net和SQL Server机制进行备份我是否必须在SQL中再次注册数据库(附加)服务器?或者我可以从文件中拉数据(例如xml)。
I want to backup an SQL Server database, my question is if I backup with vb net and SQL Server mechanish when I want to "view" and connect to the database with restore do I have to register the database again in SQL (attach) Server? or can I just "pull" the data from file (like an xml eg.)
推荐答案
看看这个:用C#填充SQL数据库 [ ^ ] - 代码在C#中,但它显而易见, VB几乎完全相同(有在线转换器可以帮助你: http://converter.telerik.com/ [ ^ ]例如)
它提供了我用于备份和恢复SQL数据库的代码,并解释了潜在的问题。
Have a look at this: Backing up an SQL Database in C#[^] - the code is in C#, but it's preety obvious, and the VB is almost identical (there are online converters which may help you: http://converter.telerik.com/[^] for example)
It gives the code I use for backup and restore of SQL databases, and explains the potential problems.
这篇关于备份sql server数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文