What is the code to restore SQL Server databases in VB?
Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert.
I am unable to restore a SQL Server database using Visual Basic.Net (VB.Net) code. Could you please provide a code for restoring databases in VB.Net?
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
It's hard to tell exactly what the problem is without seeing your code. Executing RESTORE from VB.Net is not much different than executing from SQL Server. You need to construct a SQL Server statement and execute it with ADO.NET. Here is a sample for restoring the Northwind database:
Dim sql As String = "RESTORE DATABASE [Northwind] " & _
"FROM DISK = N'C:SQL Server DatabasesNorthwind.bak' " & _
"WITH FILE = 1," & _
"Move N'Northwind' TO N'C:SQLNorthwind.mdf'," & _
"Move N'Northwind_log' TO N'C:SQLNorthwind_1.ldf'," & _
"NOUNLOAD, STATS = 10"
Dim cn As SqlConnection = New SqlConnection("Data Source=rrehak;Initial
Catalog=master;Integrated Security=SSPI;")
cn.Open()
Dim cmd As SqlCommand = New SqlCommand(sql, cn)
cmd.ExecuteNonQuery()
Make sure the account you use in the connection string has sufficient privileges for the RESTORE command. If the database does not exist, the user needs CREATE DATABASE privileges. If the database already exists, the user has to be a member of the sysadmin or dbcreator server roles, or be the owner (dbo) of the database.
Dig Deeper on .NET Development for SQL Server
PRO+
Content
Find more PRO+ content and other member only offers, here.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
1 comment
Oldest Newest