Completed

Microsoft SQL Clean-up and Optimization

Hello,

I have an ASP website using MSSQL, running on a Windows server. It's fairly old, designed more than 10 years ago.

The database, currently in use by the website, is at 17 GB in size and that's not normal. There may be hacked files and entries in the database and web files of the website. Security holes would need to be closed as well so this issue does not occur in the future.

You will need to clean/optimise the database (potentially bring it down in size) and the website (there may be hacked files) so that it could be migrated easily in the future and it would be error free.

At this point just trying to back-up, or restoring the database takes hours do to.

When working on the site, you will need to make sure you can restore to the current working version if needs be.

Skills: ASP, SQL, Microsoft SQL Server, IIS, Windows Server

See more: sql server architecture microsoft docs, wsus database cleanup script, sql server query optimizer, wsus index optimization, clean up windows internal database, wsus cleanup script server 2016, disable ghost cleanup, wsus wid cleanup, convert microsoft sql bak, configura microsoft sql per primavera, microsoft sql express csv import, administring microsoft sql server 2000, microsoft sql xml stored procedure, microsoft sql filter, software test performance microsoft sql, microsoft sql european tour operator web site, convert microsoft sql bak file, using vbnet save trigger microsoft sql, clean template power point, microsoft sql mysql dashboard creator

About the Employer:
( 16 reviews ) Montreal, Canada

Project ID: #23973778

Awarded to:

sumon355

Hello, As an expert in ms sql server, i am very much interested to do the database optimization. Protecting security holes is not included in this bid as this is much analytical & technical task which need to analyze More

$40 CAD in 2 days
(262 Reviews)
7.7

27 freelancers are bidding on average $171 for this job

sflogics

Hi, We are a .Net company with 10+ years of experience and can start this job immediately. We are dealing in Android, C#, VB, Quickbooks, MVC, ASP .Net, Razor, ASPX, Web Services, API, LINQ, MS SQL, MySQL, HTML, CSS, A More

$150 CAD in 7 days
(53 Reviews)
6.1
nurba

Hi, I am interested to optimize database and fix other files if they are hacked. I would like to have more information, we can chat By they way, I am experienced asp coder with more than 15 years experience. Regards, More

$250 CAD in 7 days
(68 Reviews)
5.7
sidhanta

Analyzing database and optimizing is the one thing. But need to look in detail for the "hacked files" as I need to know what you really want to say. It might be case, you have problem with your existing ASP website as More

$250 CAD in 30 days
(49 Reviews)
5.0
IMExpertEngineer

Hi, I'm expert in .net,c# and sql serer and I can clean up your database and make it to it's original size. Let me know when we can further discuss so I could start . Thanks

$250 CAD in 7 days
(10 Reviews)
4.8
jayantavkumar

Proposal - You need to shrink database and then defragment all your database indexes. This will drastically reduce the db size and defragmenation get back your performance of your db. Let me know if you want to discus More

$180 CAD in 1 day
(25 Reviews)
4.9
dat2na

Greetings, I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have More

$277 CAD in 2 days
(4 Reviews)
4.4
sohailhost

Hi, I can help you clean up the db files in quick time. As I have done this before as well. I am systems administrator with over 12 years of experience managing server infrastructures and data-center operations across More

$40 CAD in 1 day
(27 Reviews)
4.4
harihut

Hello Sir, Iam a core SQL Server DBA with 10+ yrs of exp. I am expert in cleanup,scrub, purge unused or old data .Good exp in all DEV and DBA roles .Give me chance I will do it 100% make it optimized. I will help you More

$100 CAD in 1 day
(9 Reviews)
3.7
mozammalidbctg

Hi, I am experts in .Net, .Net Core,C#,Vb,Windows application,Asp.net Web Forms, MVC,Boilerplate,NopCommerce,WCF Service, Web Service, Android &IOS ,Web API,AngularJS,MSSQL,MySQL,PostGreSQL,Crystal report ,Krypton To More

$200 CAD in 3 days
(5 Reviews)
3.2
SqlDevelopment

Hello. I can help with MSSQL Database. Regarding to hacked files - i can only check it with good Antimalware software. About me: Senior SQL Developer with 10+ years experience, worked during this time with several a More

$333 CAD in 3 days
(8 Reviews)
3.0
Markoradoj

Hello! I am very happy to see your project detail. I think it is just my project. :) I read your requirement carefully and understood fully. I am sure I can do your project. I have much experience with 8+years. It's More

$140 CAD in 3 days
(3 Reviews)
2.6
RushService

Feel fee to contact me for Microsoft SQL Clean-up and Optimization .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] More

$140 CAD in 3 days
(5 Reviews)
2.9
maliksh

I have 12+ years of experience in software development C#,VB.NET,ASP.NET and data integration, also specialized in database tuning and application performance, I worked bfore on 1TB+ databases, and on a certical appli More

$250 CAD in 10 days
(1 Review)
1.0
babuantony63

I have more than 10 years of experience in Ms SQL Server and 8 Years as SQL DBA. I can join immediately. My mobile no is 9249892762(India). Relevant Skills and Experience Managed several databases in Ms SQL independen More

$155 CAD in 7 days
(0 Reviews)
0.0
$155 CAD in 3 days
(0 Reviews)
0.0
tolismx3

Hello. I have read your post very carefully and I have understood job description. I am sure I can handle your project perfectly in the quick timeline. Let me know if you have some time to discuss the details furthe More

$90 CAD in 7 days
(0 Reviews)
0.0
raveshjoaheer

Hi, I have been working with SQL Server for more than 8 years. I currently administer a database cluster of 2TB+. I read your requirements and notice that these are common issues. SQL Server opimization is part of my More

$140 CAD in 1 day
(0 Reviews)
0.0
maheshm095

Hello, I am working professional with 6 years of IT experience, i have bachelors degree in Electronics and Telecommunication engineering.I Working as a DBA in SQL, MySQL, Postgres I am Handling team of 12 in MNC, I w More

$140 CAD in 7 days
(0 Reviews)
0.0
edzamo01

A review must be carried out from the server to the database, it is very important to perform cleaning tasks such as srink to the database to reduce its size, to make a backup to the database if a backup cannot be perf More

$200 CAD in 7 days
(0 Reviews)
0.0
Aryaz

I am a full stack programmer, I can handle your project as easy as pie, I need more details, please contact me to discuss in details.

$200 CAD in 2 days
(0 Reviews)
0.0