Posts Tagged ‘MS SQL2008’

Copy open files from command line – Robocopy alternative

Tuesday, February 5th, 2013

Not too long ago we needed to keep two servers in sync (one way sync). We looked around for a command line tool that can copy files that only got modified on a set interval. However we needed that tool to copy open files as well.

Well, GSCopyPro was the tool that we found to meet all of our needs. Not only can it keep folders in sync, but it can actually copy open files as well. It took a lot of research and we evaluated a lot of good tools out there in the market. GSCopyPro was certainly the one the ranked high in our charts from performance standpoint and in terms of the features it offers.   (more…)

Must-have Certifications for IT Pros

Tuesday, September 20th, 2011

There are some certifications that are nice to have and others that are simply “must haves” in today’s competitive job market. In this article, we’ll take a look at some of the certifications that IT Pros must have to be relevant today and some that will be gaining increased importance in years to come.

1. Project Management Professional (PMP)

The role of a project manager is to serve as the intermediary between the IT project team members and the key individuals who are involved with a project. A project manager tries to ensure that a project is completed in a timely manner and within all budgetary and legal constraints. The typical scope of project managers responsibilities include overseeing the processes and methodologies used for the successful completion of the project. The successful project managers can not only help save money for their company, but can also by ensuring all timelines are met (which some would argue is also money as well). There is a growing demand for skilled and competent IT project managers. These are the PM’s who can work through a budgetary crisis and conflicting resource priorities.  (more…)

Error when installing MS SQL2008 on windows x64 : The INSTANCESHAREDWOWDIR command line value is not valid. Please ensure the specified path is valid and different than the INSTANCESHAREDDIR path.

Sunday, May 2nd, 2010

There seems to be quite a few people getting an error installing MS SQL 2008  on Windows x64 machines. The error message is
The INSTANCESHAREDWOWDIR command line value is not valid. Please ensure the specified path is valid and different than the INSTANCESHAREDDIR path.

 It is a bug with the SQL 2008 installer when installed on windows x64 bit machines. the work around is to specify the path when running the installer by doing it from a command prompt or create a shortcut to the setup.exe on the CD and add the following line next to the setup.exe from the command prompt.

e:\setup.exe /action=install /INSTALLSHAREDDIR=”C:\SQLshared\x64″ /INSTALLSHAREDWOWDIR=”C:\SQLshared\x86″ setup proceeds without issues
Assuming e: is your CD-ROM or where the setup files are located. also here we assume you will be installing it on the C:

If you run into any issues please let us know, this worked for every client we that checked in with us. If it does work for you please still let us know so we know that our tips are useful and we would post more tips as we see them work.

Thank you