I would like to hire a Coder
£20-250 GBP
Plačilo ob prevzemu
I have a relatively simple Sqlcmd script that takes and restores a SQL snapshot to a database. It occasionally fails, but there is no error handling. I need someone to add some error handling code so it produces a log file with any errors encountered. It's a pretty quick job for someone who has done error handling before.
The script is:
==========================================
rem detach the databases
rem ==========================================
SQLCMD -E -Q "ALTER DATABASE [OptimaMI_OLAP] SET SINGLE_USER WITH ROLLBACK IMMEDIATE"
rem ==========================================
rem detach the database
rem ==========================================
SQLCMD -E -Q "EXEC master.dbo.sp_detach_db @dbname = N'OptimaMI_OLAP'"
rem ==========================================
rem Dismount flex clones
rem ==========================================
"D:\Program Files\NetApp\SnapDrive\sdcli" snap unmount -d D:\SQLMP\GMSSQL26M -f
"D:\Program Files\NetApp\SnapDrive\sdcli" snap unmount -d D:\SQLMP\GMSSQL26N -f
rem ==========================================
rem Delete snapshots
rem ==========================================
"D:\Program Files\NetApp\SnapDrive\sdcli" snap delete -m GMSSQL26 -d m -s [login to view URL]
"D:\Program Files\NetApp\SnapDrive\sdcli" snap delete -m GMSSQL26 -d n -s [login to view URL]
rem ==========================================
rem create snapshots
rem ==========================================
"D:\Program Files\NetApp\SnapDrive\sdcli" snap create -m GMSSQL26 -s [login to view URL] -D m n -x -u no
rem ==========================================
rem mount flex clones
rem ==========================================
"D:\Program Files\NetApp\SnapDrive\sdcli" snap mount -r GMSSQL26 -k m -s [login to view URL] -d D:\SQLMP\GMSSQL26M
"D:\Program Files\NetApp\SnapDrive\sdcli" snap mount -r GMSSQL26 -k n -s [login to view URL] -d D:\SQLMP\GMSSQL26N
rem ==========================================
rem Attach the databases
rem ==========================================
SQLCMD -E -Q "CREATE DATABASE [OptimaMI_OLAP] ON ( FILENAME = N'D:\SQLMP\GMSSQL26M\Data\[login to view URL]' ),( FILENAME = N'D:\SQLMP\GMSSQL26M\Data\[login to view URL]' ),( FILENAME = N'D:\SQLMP\GMSSQL26N\Logs\[login to view URL]' ) FOR ATTACH"
ID projekta: #13719385
Več o projektu
6 freelancerjev ponuja v povprečju za £175 na tem delu
I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Več
I am an expert of system engineer. I know a lot about debian, freeBSD, and much more. can figure apache, nginx, or other web service. I know lot about database like MySQL. and I am an expert of IT security. Know a lo Več