Find Jobs
Hire Freelancers

Powershell SQL Log Shrink Script

£20-250 GBP

Closed
Posted almost 5 years ago

£20-250 GBP

Paid on delivery
I need a powershell script which: - Identifies all SQL databases on the local instance which have logfiles larger than 50MB, for any that do: - Gets the current recovery type. If it is simple, leaves it as simple, if it is Full: - Sets the DB to simple - Shrinks the log - Sets the DB back to full recovery - If it is already simple, shrinks the log - Sends an email to a specified address confirming which db logs were shrunk, and their new log size.
Project ID: 20123751

About the project

26 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
26 freelancers are bidding on average £141 GBP for this job
User Avatar
Hello, As an expert in ms sql server, i am very much interested to do this project. I am not expert in PowerShell scripting, so if you don't have any problem, i would develop a simple tool using C#. Please let me know if you are interested. Thanks
£110 GBP in 3 days
5.0 (331 reviews)
7.7
7.7
User Avatar
Hi there Thanks for using freelancer com. My name is Sergio and I am a software developer dedicated 100% here in the markpetlace. I am super experienced both with PowerShell and SQL Server. Most of my PowerShell experience come from the Azure, Exchange modules, on the other hand I have done those management tasks directly on SQL Server (logs shriking, changed the recovery option). So I believe my spot is great to this this task for you. Let's discuss more details as needed on the chat. Best, Sergio
£124 GBP in 4 days
4.7 (93 reviews)
6.7
6.7
User Avatar
Hi, I am interested in your project. It is possible for a PowerShell script to connect to a SQL Server database. I will utilize the .Net SQL Client framework to perform the connection, query, and those administrative task you need. Please accept my bid so that we can start working. Regards, Daniel F.
£100 GBP in 5 days
4.9 (230 reviews)
6.1
6.1
User Avatar
Hi, We produce quality and cost-effective solution for our domestic and international clients. We have reviewed your job and find us experience in working with similar kind of job. We provide the complete solution where we provide the code that is easily maintainable, clean codes and provide seamless integration of new functionality. We give attention to details and ensure that the application to be developed is User friendly. We are the right person for your project. We believe in customer satisfaction and building long term relationship with the client. We have team with strong knowledge in { Website Design, PHP, Wordpress, MySQL, Ecommerce, Magento, Opencart, HTML5, Jquery, Ajax, Javascript, Plugin/Extension development, Graphic Design, Shell Script, Mobile App Design, Game development, Software Architecture} I can assure you most suitable and high quality work and will complete it on time. Please message me to discuss the details. Regards Harpreet Singh
£135 GBP in 7 days
4.9 (29 reviews)
6.0
6.0
User Avatar
Hey, I'm Romain, a french Microsoft certified guy I can do it for you Please contact me for more informations Best regards Romain
£180 GBP in 1 day
5.0 (26 reviews)
5.3
5.3
User Avatar
I am good in powershell, sql along with development and automation, please let me know if you are good to award this project to me
£188 GBP in 4 days
5.0 (43 reviews)
5.5
5.5
User Avatar
Hi, I have over six years experience automating tasks with powershell, I can do this job. Please see my work history for relevant feedback.
£150 GBP in 3 days
5.0 (39 reviews)
5.3
5.3
User Avatar
Hey there, I'm a System Engineer with coding skills. I had developed tons of scripts using PowerShell. I can help. Regards.
£250 GBP in 7 days
5.0 (24 reviews)
5.1
5.1
User Avatar
I have experience in deploying and maintaining of: Cloud Computing Platforms: AWS Amazon Web Services,Microsoft AZURE, Google Cloud (GCP). Server Operating Systems: Windows Server 2003-to-2012R2, Windows Server 2016 Amazon Linux, Debian, RHEL, CentOS, Ubuntu. Web servers and servlets containers: IIS, APACHE, NGINX, DOCKER Mail servers: POSTFIX, EXIM, MS Exchange 2000-to-2013, MS Exchange 2016, QMAIL Database servers: MySQL, MS SQL Virtualization: MS Hyper-V, VMware Server(ESXI), VirtualBox. Directory service: Active Directory, OpenLDAP. File servers: IIS FTP, proftpd, FileZilla FTP Server, SAMBA. Firewalls: Windows firewall,ISA/Forefront TMG, MikroTik,PFSense Zywall and other Routers; Data Storage Systems: Netapp, FAS, EMC, VNX; Hosting Panels: PLESK,cPanel,Website Panel
£100 GBP in 1 day
4.9 (33 reviews)
4.8
4.8
User Avatar
I can prepare this script for you however i have no smtp server on my machine so to finally test Send-MailMessage cmdlet part of the script i may need access to your environment. Other part of the script i could prepare and test on my computer ( i have currently only one instance of sql server, but i may install another one to have multiple instances for this task) Do you have special request referring to version of powershell it should work on ? (otherwise it will be written on windows 10 which by default has powershell 5.0 )
£175 GBP in 10 days
5.0 (3 reviews)
4.3
4.3
User Avatar
Hi. Iam expertise in maintains the sql server i could work to finish ur requirment if u are interested and can elobarate more in the specs so taht i will finish with exact requirements
£200 GBP in 5 days
4.9 (18 reviews)
4.4
4.4
User Avatar
Hello colleague! I have strong knowledge on powershell together woth my team. Please let us help you with this request. Ping me for more details about this. Thanks! Regards! Hugo
£250 GBP in 7 days
5.0 (2 reviews)
3.8
3.8
User Avatar
Myself Anil have more then 10 years of experience in SQL Server databse development and Administration. I have worked with big Databases for clients like match. Com, nationstar mortgage and with TCS. I am also good for BI part like SSIS, SSRS and SSAS. I am looking for full time /part time or hourly remote job. I am immediate available.
£166 GBP in 1 day
5.0 (5 reviews)
3.3
3.3
User Avatar
Hi Sir, I am Core SQL Server DBA with Excellent Powershell Scipting Experience Looking for ward your message ? I have 18 + years of Rich Experience in SQL Server Administration and Development . I can write Powershell Scripts with robust code and assure you guaranteed support . I will make a script ready as per your description and i will provide you long term excellent support . Please Chat with me and give me Chance . For Sure definitely you will like my support and Finally i would say pay only if you like my work!! I have clearly read your description and understand the requirement that you want to shrink the log file for all database which has log files size >50 mb to make it to shrink it to 50 MB . If the database is in Full Recovery Mode , we need to change it to SIMPLE and perform the Shrink and revert back the changes . Yes i am waiting for your message now?
£50 GBP in 2 days
4.8 (3 reviews)
2.2
2.2
User Avatar
Hello, Myself NikhilSenior SQL DBA having 8 years experience. Your approach on this solution is not 100% recommended. Instead of changing recovery model, you could go for log back up and shrink file.
£122 GBP in 1 day
5.0 (1 review)
1.7
1.7
User Avatar
Hi. I am a system administrator with 6 years of experience in Windows Servers & Data Base administration. I have great scripting skill in Powershell, Python, Vb Scripting & Kaseya VSA Procedures. I am a Certified Ethical Hacker, Cisco Certificate Network Admin & Microsoft Certified System Administrator. Kindly DM me to discuss more about the project. Thanks & Kind Regards.
£55 GBP in 2 days
3.1 (2 reviews)
1.0
1.0
User Avatar
dentifies all SQL databases on the local instance which have logfiles larger than 50MB, for any that do: - Gets the current recovery type. If it is simple, leaves it as simple, if it is Full: - Sets the DB to simple - Shrinks the log - Sets the DB back to full recovery
£135 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Have experience in powershell scripting and in depth knowledge of SQL server. I also have automated many tasks in my organization to minimize human work.
£50 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have already done this type of automation in powershell. In my project i have done getting SQL instance details from remote server and then check log file size if it is greater than threshold(which will set by user) shrink the log file. if current log file size not less than previous log file size then take DB log backup and shrink again. So, my previous project is same like your project.
£140 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a senior database Administrator in Microsoft SQL server I have read your requirements and I can complete those sql log maintenance tasks. I can deliver my work in 5 days. If you choose my bid we can chat to discuss about this project.
£111 GBP in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Belfast, United Kingdom
5.0
9
Payment method verified
Member since Jun 28, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.