Need to create dynamic SQL script for database restore. Grab the latest backup file out of several files.
Backup Location:
\\fileshare\Backup\FULL
In this location I have 3 full backup file
Name Data Modified Type
[login to view URL] 10/7/2018 BAK File
[login to view URL] 10/8/2018 BAK File
[login to view URL] 10/9/2018 BAK File
Now from the latest file want a script to restore the database in DEV instance. Want to create the job in dev instance.
No need to create the job, only need the dynamic SQL for grabing the backup file and then restore the database.
13+ years experience in software development, database programming and administration, and project management. My proficiency are given in the following-
Specialist:
------------
SQL
PL/SQL
T-SQL
PL/pgSQL
ETL
Database Migration
SQL Optimization
Stored Procedure
C#
ASP.NET
AWS
Database Expertise:
------------------------
MySQL
MariaDB
Oracle
MS SQL Server
PostgreSQL
EnterpriseDB
MS Access
Database Administration and Programming:
------------------------------------------------------
Install, configure and troubleshoot database
Database backup and recovery
Database Performance Tuning
Database Replication and Clustering
Database Migration
Data Migration
SQL Optimization
Creating procedure, functions, triggers and packages
Web Application Development:
--------------------------------------
ASP.net web form and MVC
C#.net
VB.net
HTML
CSS
Java script
Ajax
Jquery
Entity Framework
Crystal Report
Microsoft Reporting
Desktop Application Development:
-----------------------------------------
VBA
VB6
C#
Crystal Report
Microsoft Reporting
ERP and CRM:
-----------------
Microsoft Dynamic Great Plan (GP)
Microsoft Dynamic CRM
Business Intelligence (BI):
-------------------------------
Microsoft SQL Server Integration Service (SSIS)
Microsoft SQL Server Reporting Service (SSRS)
Microsoft SQL Server Analysis Service (SSAS)
Pentaho
$30 USD en 3 días
5,0 (12 comentarios)
4,7
4,7
14 freelancers están ofertando un promedio de $162 USD por este trabajo
Dear Hiring Manager,
We can help you in the project.
I am good in: php, codeigniter, laravel, jquery, google map api, MySQL.
Let me know when we can discuss in more details and start working on it asap.
Looking forward for your response.
Thanks
Hi.
I have read your description and have interests in your project.
I would like to have a discussion with chat to get more about your project.
Thanks.
I am a professional web and database developer. I have very strong skills in SQL queries. I can do your job. If you are interested we can discuss.
Thanks
Contact me for working on Dynamic TSQL for database restore.I will give you effordable price and fast deadline.I will keep you updated from time to time with progress of the task.
Hi Dear !
I am seeing your project and i thought i am the most specific and suitable person for it.
Your Project is simply related to my interest.
I have the best reviews in this skill.
I will create the datsbase on urgent basis.
I will complete your project on given time surely.
Your satisfaction will be my first priority.
I will also discuss about the progress of my work on your project at daily basis.
If you want my services then message me and share more details about your project.
Thank you!
I’m a Data Engineer at a consulting firm and have SQL knowledge because I have worked as Database Admin and have done something like that before
Relevant Skills and Experience
First you need a kill script to kill any running paid of greater than 50, then create a variable for Date (latest) then place that variable as backup name in the script