W3vina.COM Free Wordpress Themes Joomla Templates Best Wordpress Themes Premium Wordpress Themes Top Best Wordpress Themes 2012

Uscimpsys Restore at client place

  1. Create one batch file
  2. copy the following code. replace correct value in necessary place.

 

 

set SqlServer=192.168.0.2
set InstanceName=MSSQLSERVER
set Username=sa
set Password=**********
set LocalFolder=D:\EFL
set DatabaseName=EFL

SqlCmd -S %SqlServer% -U %Username% -P %Password% -Q “RESTORE DATABASE [%DatabaseName%] FROM DISK=’%LocalFolder%\%DatabaseName%.bak’ WITH REPLACE”

 

3. Save it as batch file. That is all

 

Revisions

Translate »