I would like to hire a Coder

Zaprto Objavljeno pred 6 letoma/leti Plačilo ob prevzemu
Zaprto 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"

Coding SQL

ID projekta: #13719385

Več o projektu

6 predlogov Oddaljen projekt Aktiven pred 6 letoma/leti

6 freelancerjev ponuja v povprečju za £175 na tem delu

Shopify

Hi, I (Myself a senior PHP Developer) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the ve Več

£257 GBP v 10 dneh
(1 Ocena)
5.0
jagdishbhatt38

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č

£200 GBP v 3 dneh
(27 ocen)
4.8
gunslinger

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č

£250 GBP v 3 dneh
(0 ocen)
0.0
Eng1

Bid Summary I'm a Computer Science Engineer. I am creative, accurate, flexible and committed ( if you looking for this characters, I'm pleased to put my efforts and my time in your serve. Project Requirements I can co Več

£90 GBP v 3 dneh
(0 ocen)
0.0