Find Jobs
Hire Freelancers

Maintenance of SQL Server

$10-20 SGD / hour

Terminado
Publicado hace alrededor de 10 años

$10-20 SGD / hour

For some time now our daily backups have been failing and as a result our transaction log has hit 90+ GB and filled the hard drive. We've not been able to get this resolved and need someone to identify the problem and resolve it. take the backup and clear the transaction log. Please let us know if you have any questions.
ID del proyecto: 5487138

Información sobre el proyecto

30 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, I'm very interested helping you resolving your database problem, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$21 SGD en 3 días
4,6 (33 comentarios)
5,4
5,4
30 freelancers están ofertando un promedio de $17 SGD /hora por este trabajo
Avatar del usuario
Hello, I am very much interested to do this work, as i do same thing means backing up all the DBs by a sql job and i thing i can do it similarly to your server. I think you need to shrink your db's log files. Looking forward to have a positive response from you. Thanks
$12 SGD en 5 días
5,0 (176 comentarios)
7,2
7,2
Avatar del usuario
Hi Greetings !! Thank you very much for giving me opportunity to bid on your project. We are having team of MS Certified Developers and they have good sound SQL, Asp.net, MVC etc. We are excited to take effective steps further, to make this assignment as first footprint for our long-term healthy business relationship in coming days. Assuring you a Best service all the time. Look forward for working with you. Thanks and regards Sandeep Ghodasara Prakash Software Solutions Pvt Ltd (Microsoft Silver Certified Company)
$26 SGD en 3 días
5,0 (13 comentarios)
6,7
6,7
Avatar del usuario
Hi Most probably your backups are failing as you do not have enough free disk space. Transaction logs are kept to restore from the log. Since you are taking normal backups regularly, and if you do not intend to restore from the transaction log, then it is better to configure the SQL server not to write the transaction logs. this way database will be a bit faster and there is no worry of log file size getting incresed. For now what you can do is to detach the database, simply delete the log file and then reattach the database, and then take the backup. Please do let me know if you want me to do this on your server. Which version of MS SQL are you using? Thanks Roni
$17 SGD en 5 días
5,0 (68 comentarios)
6,3
6,3
Avatar del usuario
Dear Sir, I'm expert with SQL, and i'm interested on helping you, could you please give me access to your server. Kind Regards, NourElDeen
$15 SGD en 3 días
5,0 (44 comentarios)
5,5
5,5
Avatar del usuario
A proposal has not yet been provided
$22 SGD en 20 días
5,0 (3 comentarios)
4,9
4,9
Avatar del usuario
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 7 years in IT projects with 5 years working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 3 years .I worked for several projects relating with SQL ServeR on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I'm used to working iwth SQL Server on both administration and development to develop all types of requirements related ,and given my experience, I think I have all the skills to give High quality of work delivery withing budget and time Best regards,
$24 SGD en 3 días
4,8 (14 comentarios)
4,7
4,7
Avatar del usuario
I am able to correct this issue. Im assuming this is MSSQL DB server however, kindly verify along with the version. You also mentioned that the DB is 90+GB is this on a partition? Does the physical server have and additional physical HDD? Also it would be nice is you could provide the total HDD size on the server. Thank You. Regards Chris
$15 SGD en 5 días
5,0 (5 comentarios)
3,8
3,8
Avatar del usuario
hi i have asound knowledge of the SQL database Administration and have 7 years of experience even you can see the feedback for the SQL. tell me when we can discuss about the same and get the problem resolved. Waiting for your response
$16 SGD en 3 días
4,8 (7 comentarios)
4,2
4,2
Avatar del usuario
Hi, I am an expert web developer. I have developed many websites for US, UK, France, Turkey, India and Australia. You can check my portfolio. I have also developed customized web based ERP for Indian Paper Trading Company. I will complete this project within time limit and with accuracy. I will be available on skype. Thanks and regards
$14 SGD en 5 días
5,0 (3 comentarios)
3,5
3,5
Avatar del usuario
Hi, I'm a certified SQL Server Database architect[MCP, MCDBA, MCTS, MCITP] with 11 Years of experience in SQL Server database administration and development, and I'm very interested in your job post involving these skills. Thanks, Ranjith
$16 SGD en 5 días
5,0 (1 comentario)
2,6
2,6
Avatar del usuario
Hi, I'm experienced with MS SQL Database Administration. I've been involved in many project using MS SQL and also conduct a successfully MS SQL server clustering for major automotive industry in Indonesia. Could work remotely thru teamviewer or RDP. If u interested, please contact me and I'd love to help u solve the problem. Regards, Tedi
$13 SGD en 10 días
3,5 (2 comentarios)
3,2
3,2
Avatar del usuario
Experienced software professional with over 20 years in development and maintenance of applications. Good knowledge in SQL server. What is the error you are getting when the backup fails? This will help in resolving the error.
$16 SGD en 3 días
5,0 (1 comentario)
1,5
1,5
Avatar del usuario
Hi, I am working as a remote support server engineer for a US based company, Maintenance and configuring MS SQL are falls in my key responsibility. These types of issues are normal, i can fix and provide on this.
$13 SGD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Will do it as your problem once the awarded. Having good knowledge on this area. Regards, xxxxxxxxx
$22 SGD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have an experience with a problem like yours. Solved it a couple of times with my SQL Server........
$16 SGD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I am a Database administrator and work in SQL Server,. would like to work for you on this project. One question for you, kindly can you tell what is the recovery mode of your database. Regards Abdul Muiz Meer
$17 SGD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I will check all the databases on your server, resize the transaction logs to an appropriate size and create a SQL Agent job to backup the transaction logs on an hourly basis keeping only x amount of days on disk. I can also provide a script that will create a job to resize the transaction logs on a weekly basis. I'm also happy to review your backup maintenance plans and provide you with any improvement suggestions.
$22 SGD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi I am Nithin and my total SQL DBA exp is more than 6 years and I am working for IBM I have deal with such kind of issues previously. Data I need to resolve this issue is 1) What is the Database size and in which mode it is been designed for. 2) When was the last backup happened and what is the total size of Database. 3) Is that DB placed in Production server or testing server. If everything is answered I can complete this task in 4 working days.
$16 SGD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Over the last 10+ years, I have developed a wide range of websites/Software using Asp.net, C#, Ajax, Jquery, MVC,and Sql-server including sites for companies and businesses. My core competency lies in complete end-end management of a new website/software development project, and I am seeking opportunities to build websites/software from the ground up for you or your business. Also I have good experience in the following areas: WCF , WPF ,SILVERLIGHT, CRYSTAL REPORT,CLASSIC ASP,ORACLE and software design and testing.
$16 SGD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Sir, How are you ? Greetings of the day. We understand your situation. We have more than 8 + years experience in SQL Server Database management, Fine tuning of large database. Just wanted to know your SQL Server version. to analyze and provide you cause we require to access your server. and run some script. We assure you we will provide you solution ASAP. We are waiting for positive response from your side. Thanks & Regards, AgiletechIn
$14 SGD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SINGAPORE
Balmain, Singapore
5,0
22
Forma de pago verificada
Miembro desde may 21, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.