备份还原数据库sql express [英] backup restor database sql express

问题描述

我使用此代码还原数据库，但无法还原操作?

I used this code to restor database but it cannot do restor opration?

OpenFileDialog1.FileName = database
                        OpenFileDialog1.ShowDialog()
                        Filename = OpenFileDialog1.FileName
                        strQuery = "ALTER DATABASE [c:\Didar\didar.mdf] SET SINGLE_USER WITH ROLLBACK IMMEDIATE"
                        strQuery = "RESTORE DATABASE [c:\Didar\didar.mdf] FROM DISK=N'" & Filename & "' WITH NOFORMAT, NOINIT, NAME = 'x', SKIP, NOREWIND, NOUNLOAD, STATS = 10"

                        strQuery = "ALTER DATABASE [c:\Didar\didar.mdf] SET MULTI_USER"
                        Dim cmd As SqlCommand
                        cmd = New SqlCommand(strQuery, con)
                        cmd.ExecuteNonQuery()

推荐答案

请参考以下链接:
备份和使用VB.NET还原SQL Server数据库 [还原类 [通过VB.net进行SQL Server数据库备份和还原 [ ^ ]
还原数据库 [ SQL Server数据库任务，分离，备份和还原 [ ^ ]

Please refer following links:
Backup & Restore of SQL Server database using VB.NET[^]
Restore Class[^]
Sql Server Database Backup and Restore through VB.net[^]
Restore Database[^]

SQL Server DB tasks, Detach, Backup and Restore[^]

这篇关于备份还原数据库sql express的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！