visual studio 2013 - Restore database in SQL LocalDB using VB.NET -

-

i have project developed in vb.net , sql server 2012 localdb (v11) , need backup/restore facility in application. backup part complete stuck @ restore part. query want worked (and working fine in sql editor)

alter database [<.mdf file path>]  set single_user rollback immediate  restore database [<.mdf file path] disk='<.bak file path'

and here code in vb.net trying execute

sub restorequery(byval que string)     mainform.conn.close()     con = new sqlconnection("data source=(localdb)\v11.0;database=master;integrated security=true;")     if not con.state = connectionstate.open con.open()     cmd = new sqlcommand(que, con)     cmd.executenonquery() end sub

and here approaches tried far

  1. using same query above

    restorequery("alter database [<.mdf file path>] set single_user rollback immediate") restorequery("restore database [<.mdf file path>] disk='<.bak file path>'")

    and results in error

    exclusive access not obtained because database in use. restore database terminating abnormally.

  2. after finding reason above issue (which nonsense after using master database while opening connection , closing opened connections using mainform.conn.close() ), tried second approach per links , references stackoverflow. , here queries tried:

    restorequery("use [master] ") restorequery("alter database [<.mdf file name>] set single_user rollback immediate") restorequery("restore database[<.mdf file name>] disk='<.bak file name>'") restorequery("alter database [<.mdf file name>] set multi_user") restorequery("use [<.mdf file name>]")

    and here error got while executing second query :

    additional information: user not have permission alter database <.mdf file name path>, database not exist, or database not in state allows access checks. alter database statement failed.

is there other way restore sql server localdb using vb.net ?

i have used code in 1 of project. 

try       openfiledialog1             .filter = ("db backup file|*.bak;")             .filterindex = 4      end       openfiledialog1.filename = ""       if openfiledialog1.showdialog() = dialogresult.ok           cursor = cursors.waitcursor           sqlconnection.clearallpools()           con = new sqlconnection(cs)           con.open()           dim cb string = "use master alter database [" & system.windows.forms.application.startuppath & "\brh.mdf] set single_user rollback immediate restore database [" & system.windows.forms.application.startuppath & "\brh.mdf] disk='" & openfiledialog1.filename & "' replace alter database [" & system.windows.forms.application.startuppath & "\brh.mdf] set multi_user "           cmd = new sqlcommand(cb)           cmd.connection = con           cmd.executereader()           con.close()     end if catch ex exception     messagebox.show(ex.message, "error", messageboxbuttons.ok, messageboxicon.error)     end try

Comments

Post a Comment

Popular posts from this blog

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

-
Image
i've installed yii2-user module/dektrium yii2-app-basic application command composer require "dektrium/yii2-user:0.9.*@dev" config/console.php return [ . . 'modules' => [ 'gii' => 'yii\gii\module', 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] config/web.php 'components' => [ . . /* 'user' => [ 'identityclass' => 'app\models\user', 'enableautologin' => true, ], */ 'modules' => [ 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] after that, run command $ php yii migrate/up --migrationpath=@vendor/dektrium/yii2-user/migrations updating database schema . but, when run http://localhost/mylawsuit/yii/web/index.php?r=u
Read more

How to show in django cms breadcrumbs full path? -

-
need advice - how show in breadcrumbs whole path article or page? i've got code: {% ance in ancestors %} <li> {% if not forloop.last %} <a href="{{ ance.get_absolute_url }}">{{ ance.get_menu_title }}</a> {% else %} <span class="active">{{ ance.get_menu_title }}</span> {% endif %} </li> {% endfor %} but shows "home" , current page. how modify show whole path in breadcrumbs? i've found in file menu_tags.py code calls ancestors. @ least there class showbreadcrumbs: class showbreadcrumb(inclusiontag): """ shows breadcrumb node has same url current request - start level: after level should breadcrumb start? 0=home - template: template used render breadcrumb """ name = 'show_breadcrumb' template = 'menu/dummy.html' options = options( argument('start_level', default=0, require
Read more

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -

-
i have app uses rails framework , implements angularjs part of front end. i have pushed heroku , have heroku toolbelt installed, when try migrate db using "heroku run rake db:migrate" receive following error(s): installing core plugins heroku-cli-addons, heroku-apps, heroku-fork, heroku-git, heroku-local, heroku-run, heroku-status... error installing package. try running again gode_debug=info see more output. ! `run` not heroku command. ! perhaps meant `-h`, `2fa`, `auth`, `join`, `open`, `orgs`, `pg`, `ps` or `rake`. ! see `heroku help` list of available commands. i run command "gode_debug=info heroku run rake db:migrate" , receive error: npm err! darwin 14.5.0 npm err! argv "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/bin/node" "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/lib/node_modules/npm/cli.js" "install" "heroku-cli-addons" "heroku-apps" "heroku-fork
Read more