Thursday, February 10, 2011

CLI (CMD) - Command prompts for Windows

Command prompts for Windows



Some are for XP Only, Some are for Vista, Windows 7, Windows Servers, etc. Give them a try! A more structured list with examples are coming soon.

Control Panel
  • CONTROL: opens the control panel window
  • CONTROL ADMINTOOLS: opens the administrative tools
  • CONTROL KEYBOARD: opens keyboard properties
  • CONTROL COLOUR: opens display properties.Appearance tab
  • CONTROL FOLDERS: opens folder options
  • CONTROL FONTS: opens font policy management
  • CONTROL INTERNATIONAL or INTL.CPL: opens Regional and Language option
  • CONTROL MOUSE or MAIN.CPL: opens mouse properties
  • CONTROL USERPASSWORDS: opens User Accounts editor
  • CONTROL USERPASSWORDS2 or NETPLWIZ: User account access restrictions
  • CONTROL PRINTERS: opens faxes and printers available
  • APPWIZ.CPL: opens Add or Remove programs utility tool
  • OPTIONALFEATURES: opens Add or Remove Windows component utility
  • DESK.CPL: opens display properties. Themes tab
  • HDWWIZ.CPL: opens add hardware wizard
  • IRPROPS.CPL: infrared utility tool
  • JOY.CP: opens game controllers settings
  • MMSYS.CPL: opens Sound and Audio device Properties. Volume tab
  • SYSDM.CPL: opens System properties
  • TELEPHON.CPL: Opens phone and Modem options
  • TIMEDATE.CPL: Date and Time properties
  • WSCUI.CPL: opens Windows Security Center
  • ACCESS.CPL: opens Accessibility Options
  • WUAUCPL.CPL: opens Automatic Updates
  • POWERCFG.CPL: opens Power Options Properties
  • AZMAN.MSC: opens authorisation management utility tool
  • CERTMGR.MSC: opens certificate management tool
  • COMPMGMT.MSC: opens the Computer management tool
  • COMEXP.MSC or DCOMCNFG: opens the Computer Services management tool
  • DEVMGMT.MSC: opens Device Manager
  • EVENTVWR or EVENTVWR.MSC: opens Event Viewer
  • FSMGMT.MSC: opens Shared Folders
  • NAPCLCFG.MSC: NAP Client configuration utility tool
  • SERVICES.MSC: opens Service manager
  • TASKSCHD.MSC or CONTROL SCHEDTASKS: opens Schedule Tasks manager
  • GPEDIT.MSC: opens Group Policy utility tool
  • LUSRMGR.MSC: opens Local Users and Groups
  • SECPOL.MSC: opens local security settings
  • CIADV.MSC: opens indexing service
  • NTMSMGR.MSC: removable storage manager
  • NTMSOPRQ.MSC: removable storage operator requests
  • WMIMGMT.MSC: opens (WMI) Window Management Instrumentation
  • PERFMON or PERFMON.MSC: opens the Performance monitor
  • MMC: opens empty Console
  • MDSCHED: opens memory diagnostics tools
  • DXDIAG: opens DirectX diagnostics tools
  • ODBCAD32: opens ODBC Data source Administrator
  • REGEDIT or REGEDT32: opens Registry Editor
  • DRWTSN32: opens Dr. Watson
  • VERIFIER: opens Driver Verifier Manager
  • CLICONFG: opens SQL Server Client Network Utility
  • UTILMAN: opens Utility Manager
  • COLORCPL: opens color management
  • CREDWIZ: back up and recovery tool for user passwords
  • MOBSYNC: opens Synchronization center
  • MSCONFIG: opens System Configuration Utility
  • MSTSC: Remote Desktop Automatic Login - (e.g mstsc /v:hostname) (e.g. mstsc /v:192.168.50.5)
  • SYSEDIT: opens System Configuration Editor (careful while using this command)
  • SYSKEY: Windows Account Database Security management (careful while using this command)

Windows utility and applications

  • EPLORER: Opens windows Explorer
  • IEXPLORER: Opens Internet explorer
  • WAB: opens Contacts
  • CHARMAP: opens Character Map
  • WRITE: opens WordPad
  • NOTEPAD: opens Notepad
  • CALC: opens Calculator
  • CLIPBRD: opens Clipbook Viewer
  • WINCHAT: opens Microsoft Chat Interface
  • SOUNDRECORDER: opens sound recording tool
  • DVDPLAY: run CD or DVD
  • WMPLAYER: opens Windows Media Player
  • MOVIEMK: Opens untitled Windows Movie Maker
  • OSK: opens on-screen Keyboard
  • MAGNIFY: opens Magnifier
  • WINCAL: opens Calendar
  • DIALER: opens phone Dialer
  • EUDCEDIT: opens Private Character Editor
  • NDVOL: opens the mixer volume
  • RSTRUI : opens Tool System Restore (For Vista only)
  • %WINDIR%\SYSTEM32\RESTORE\rstrui.exe: opens Tool System Restore (for XP only).
  • MSINFO32: Opens the System Information
  • MRT : launches the utility removal of malware.
  • Taskmgr : Opens the Windows Task Manager
  • CMD: opens a command prompt
  • MIGWIZ: Opens the tool for transferring files and settings from Windows (Vista only)
  • Migwiz.exe: Opens the tool for transferring files and settings from Windows (for XP only)
  • SIDEBAR: Open the Windows (Vista only)
  • Sigverif : Opens the tool for verification of signatures of files
  • Winver : Opens the window for your Windows version
  • FSQUIRT: Bluetooth Transfer Wizard
  • IExpress opens the wizard for creating self-extracting archives. Tutorial HERE
  • MBLCTR: opens the mobility center (Windows Vista only)
  • MSRA : Opens the Windows Remote Assistance
  • Mstsc : opens the tool connection Remote Desktop
  • MSDT: opens the diagnostic tools and support Microsoft
  • WERCON: opens the reporting tool and solutions to problems (for Vista only)
  • WINDOWSANYTIMEUPGRADE: Enables the upgrade of Windows Vista
  • WINWORD : opens Word (if installed)
  • PRINTBRMUI : Opens migration wizard printer (Vista only)

Disk management

  • DISKMGMT.MSC: opens disk management utility
  • CLEANMGR: opens disk drive clean up utility
  • DFRG.MSC: opens disk defragmenter
  • CHKDSK: complete analysis of disk partition
  • DISKPART: disk partitioning tool

Connection management

  • IPCONFIG: list the configuration of IP addresses on your PC (for more information type IPCONFIG/? in the CMD menu)
  • INETCPL.CPL: opens internet properties
  • FIREWALL.CPL: opens windows firewall
  • NETSETUP.CPL: opens network setup wizard

Miscellaneous commands

  • JAVAWS: View the cover of JAVA software (if installed)
  • AC3FILTER.CPL: Opens the properties AC3 Filter (if installed)
  • FIREFOX: Mozilla launches Firefox (if installed)
  • NETPROJ: allow or not connecting to a network projector (For Vista only)
  • LOGOFF: closes the current session
  • SHUTDOWN: shut down Windows
  • SHUTDOWN-A: to interrupt Windows shutdown
  • %WINDIR% or %SYSTEMROOT%: opens the Windows installation
  • %PROGRAMFILES%: Opens the folder where you installed other programs (Program Files)
  • %USERPROFILE%: opens the profile of the user currently logged
  • %HOMEDRIVE%: opens the browser on the partition or the operating system is installed
  • %HOMEPATH%: opens the currently logged user C: \ Documents and Settings \ [username]
  • %TEMP%: opens the temporary folder
  • VSP1CLN: deletes the cache for installation of the service pack 1 for Vista
  • System File Checker (Requires Windows CD if the cache is not available):
    • SFC / scannow: immediately scans all system files and repairs damaged files
    • SFC / VERIFYONLY: scans only those files system
    • SFC / Scanfil = "name and file path": scans the specified file, and repaired if damaged
    • SFC / VERIFYFILE = "name and file path": Scans only the file specified
    • SFC / scanonce: scans the system files on the next restart
    • SFC / REVERT: return the initial configuration (For more information, type SFC /? In the command prompt CMD.
(Excerpted from http://en.kioskea.net/faq/403-command-prompts-for-windows)
    Share:

    Wednesday, January 26, 2011

    Monday, January 24, 2011

    Monday, January 3, 2011

    Symantec NetBackup CLI Troubleshooting

    Did you ever need to troubleshoot Symantec NetBackup from the Command Line? Here you go! (Commands also work on Linux, Solaris and Windows)


    C:\Program Files\Veritas\NetBackup\bin\
    bpps             = list NetBackup services
    nbconsole        = launch NetBackup Administration Console GUI
    bpdown -v -f     = shut down NetBackup services by force and show in verbose
    bpup -v -f       = start NetBackup services and show in verbose

    C:\Program Files\Veritas\NetBackup\bin\admincmd\
    bpexpdate -m 123456 -d 0   = expire media ID 123456, effectively releasing the assignment of that tape
    nbemmcmd -listmedia -mediaid 123456    = show the parameter of media 123456
    nbpemreq -suspend_scheduling           = suspend your policies (running jobs are not affected)
    nbpemreq -resume_scheduling            = resume the policies again

    C:\Program Files\Veritas\volmgr\bin\
    vmoprcmd                     = list devices and media server status (it will say "ACTIVE" if disk and tape are up)
    vmoprcmd -d                = list device status
    vmquery -m 123456      = show the parameter of media ID 123456 (not as comprehensive as nbemmcmd -listmedia -mediaid)
    tpconfig -d                     = list device status
    scan -changer                 = probe the robot. If it's connected properly it will show, otherwise, blank
    scan -tape                             = probe the tape drives. It will list those that NetBackup can see via the Operating System.
    If not showing, either they are not connected properly, or driver is invalid/not up to date, or Removable Storage service is running
    tpclean -L       = check the drive cleaning status
    tpclean -C drivename       = clean that drive
    robtest       = do robot operation directly on the robot
    You can use these commands inside robtest:
    s d   = show the drives and what's in them
    s s   = show the slots and what's in them
    m s1 d1 = move tape from slot 1 to drive 1
    m s2 d1 = move tape from slot 2 to drive 1
    m d2 s1 = move tape from drive 2 to slot 1

    Important: always exit from robtest when you are done (q), as robtest locks the robot operation. Other programs won't be able to do robot operation when you are in robtest.

    OS command
    taskkill /f /pid 12345     = kill process ID 12345

    A good place to check for drive / tape errors is to open the errors file below. It will log tape alert messages sent from the library:
    C:\Program Files\Veritas\NetBackup\db\media\errors
    Share:

    Sunday, December 26, 2010

    Office365 vs Google Apps

    Many companies and businesses have been reviewing the various options of Microsoft's Office365 and Google's Google Apps offerings. It can be very confusing to distinguish between the differences on their offerings for executives, IT Managers, or people responsible for the collaboration and email systems of small, medium, and large companies, universities and government organizations. There are some clear and distinct differences to Office365 and Google Apps that must be understood before making a decision that will impact your organization for 3-5 years of your initial investment. Cloud computing has shifted how we do business and whether you select Google Apps or Office365...welcome to the world of real productivity and cloud computing.

    This presentation and tutorial will give you all of the information that you will need to help make a sound decision or it will motivate a more informed and educated discussion.

    URL Link: https://docs.google.com/present/view?id=dd23xpzk_206kqq2nwgf

    Share:

    Saturday, November 20, 2010

    What is Healthcare Administration?


    When thinking about a career in healthcare, images of doctors or nurses might be the first to come to mind. But there are hundreds of different healthcare careers, from the people who administer the healing to the people who administrate the industry. Doctors and nurses cannot function on their own, and many people work behind the scenes in rewarding jobs at all levels of responsibility and pay.

    Like any good business, healthcare needs quality managers to maintain a smoothly-running organization. They plan and supervise the delivery of services by doctors, nurses, and technicians. And they can work in small health clinics or major medical centers. Each operation needs someone to track trends in an ever-changing industry and to keep the business on the cutting edge. Healthcare administrators play an important role in keeping the community healthy.

    Healthcare administrators take on leadership titles such as:
    • Hospital administrator
    • Department or division director
    • Company president
    • Chief executive officer
    • Chief financial officer
    Many professionals begin their careers in this field with just a bachelor's degree, working while earning an advanced degree and moving into management. Sometimes administrators might be specialists in charge of a particular type of department or generalists who oversee entire facilities.

    An estimated 100,000 people today work in healthcare administration. This constantly evolving profession will always be growing and will always need qualified employees-now more than ever, as aging Baby Boomers place greater demands on our healthcare system. Administrators make decisions that improve the efficiency of the organization, coordinate activities, and manage relationships with other healthcare providers and the community.

    Attend ONLY Fully Accredited Schools. This means Regional Accreditation by the US Department of Education and Job Field Certification from the Commission on Accreditation of Healthcare Management Education! DO NOT RISK YOUR CAREER ON A NON-ACCREDITED DEGREE!

    What Do Healthcare Administrators Do?

    Healthcare administration covers such a broad area that it can be difficult to describe the field. What administrators do depends on the type and size of facility at which they are working. Large facilities, such as medical centers, have several layers of administrators, with one officer at the top responsible for setting the direction and making the final decisions. That person typically reports to a board of directors. Small facilities more typically require generalists to oversee all aspects of the operation.

    At a large facility, assistant administrators oversee certain areas or activities of the healthcare operation. Someone might direct nursing activities, personnel, quality assurance, finance, or other areas. Administrators at large facilities are more likely to establish the procedures and policies of the organization in consultation with physicians, and are charged with implementing those policies. Typically, these professionals handle financial decisions and answer to the chief executive officer.

    Small facilities are often set up and run by doctors who control the decisions but hire administrators to carry out the day-to-day operations. Here, administrators are less specialized and more hands-on in their approach. They focus more on the business aspects such as personnel, finance, staffing, and facility operations.

    Some small facilities are specialty clinics. A group of dentists, chiropractors, dermatologists or other specialists organize and hire staffers to oversee the business side of the operation while they handle the medical decisions. Clinical directors of businesses like these often have a background in a particular specialty, such as physical therapy. They create objectives and implement policies. They hire and evaluate personnel, and coordinate the activities of the clinic.

    Administrators earn competitive salaries, but must sometimes tolerate unusual work schedules. Many healthcare services, such as hospitals and clinics, operate around the clock. This means that administrators are on call whenever problems arise. Along with handling budget and staffing matters, administrators must attend numerous meetings. Depending on the size of the organization, administrators may be required to travel extensively to meet with board members, oversee other facilities, or attend industry conventions.

    As with other management positions, healthcare administrators must supervise people, solve problems, and make critical decisions quickly. Your success as a healthcare administrator will depend on your ability to get along with people. You will have regular contact with patients, community members, physicians, nurses, vendors, trustees, and organizational staff. Always strive to develop your skills in working with people, negotiation, and analyzing information.

    Managers in the healthcare sector have varying responsibilities, qualifications, salary range, and work hours. Entry-level administrative positions include marketing assistants, operating assistants, project consultants and managers, health provider representatives, and accountants. Mid-level positions include marketing directors, department managers, case managers, managers of ancillary services such as laboratory and radiology departments, and ambulatory care managers, contract negotiators, and controllers. Senior-level positions include chief executive officers, chief operating officers, chief financial officers, senior vice presidents and vice presidents for various sections and services.

    Healthcare Administration: A Booming Industry

    There's never been a better time to join the healthcare industry. Half of the 20 U.S. occupations projected to grow the fastest over the next few years are in the health services fields. Employment in healthcare administration is expected to grow fastest in practitioners' offices and in services for home healthcare. During the next decade, about 3.5 million new jobs are projected in health services (that's about 16 percent of all new jobs total). This is higher than any other industry. Hospitals constitute just 2 percent of healthcare operations, yet they employ more than 40 percent of healthcare workers. The majority of other jobs are in the practices of individual healthcare practitioners or small groups of practitioners.

    Wages for the healthcare industry are expected to increase about 28 percent by 2012, while salaries for all other industries should increase by about 16 percent. In addition, healthcare jobs are expected to increase faster than the population during that same time, as the older population increases and improved technology advances life expectancies.

    Career Education in Healthcare Administration

    On-Campus and Online College Degree Programs

    High school students can get a jump on a career in healthcare administration by loading up on courses in English, math, and social studies, with a couple of years' worth of science. Some background in a foreign language, particularly Spanish, could prove helpful as well. The basic college curriculum in healthcare administration covers management theory, concepts, and skills, and an overview of the health care industry. These programs are designed to teach students leadership, financial management, economics, law, organizational behavior, quantitative analysis methods, and planning.

    When evaluating candidates for entry-level management positions, employers look for appropriate education, work experience, communication skills, general management skills, leadership skills, business planning skills, quantitative skills, fit with organizational objectives, and character. Students are encouraged to look for volunteer or internship positions with healthcare providers to supplement their coursework.

    Do You Need an Advanced Degree to be a Healthcare Administrator?

    For most entry-level positions in healthcare administration, a bachelor's degree is all that is needed. Anyone hoping to move into a higher-level (and higher-paying) position might need a master's degree for a career boost. Because programs vary from college to college, it is best to investigate as many as possible. Some offer specialty programs, some provide more of a broad introduction to the profession. Be sure to consider your own career goals in choosing a school.

    Online Degrees in Healthcare Administration
    More and more healthcare managers and administrators are choosing online degrees in healthcare administration, especially at the master's level. Since they require little to no clinical practice, these programs are ideal for online study, especially for working healthcare professionals who are ready to move up the career ladder. Though bachelor's degrees are available online, master's degrees are more common and are often designed for professionals already working in the field, who can apply their newfound knowledge directly to their current jobs.

    Bachelor's Degrees in Healthcare Administration
    Bachelor's degree programs are designed to provide an understanding of the general concepts in healthcare administration and the analytical tools necessary to succeed within the structure of healthcare administration. Some of the skills developed here are financial management, statistical and economic analysis in decision-making, legal and ethical concepts, structure of healthcare organizations, and understanding health concerns within a community.

    Master's Degrees in Healthcare Administration
    master's degree will prepare you for a senior-level administrative position. Master's degrees are especially helpful for people working in health-provider jobs who want to move into management. A bachelor's degree is required and good grades are important. Some programs are tailored specifically for the practitioner who wants to obtain management skills. Ideally, you would be able to enter the US Military with a Master's Degree in Healthcare Administration, but it must be CAMHE accredited.

    Schools have different names for their master's programs in healthcare and many offer different concentrations. So look around and consider what best suits your needs. For those who want to focus specifically on financial and business analysis, the healthcare management MBA would be the way to go. Skills developed in this program are in high demand at all levels of healthcare administration and will serve as a definite positive toward career advancement.

    PhD Degrees in Healthcare Administration
    PhD or Doctor of Health Administration degree will allow you to pursue critical studies of advanced problems in healthcare administration. Typically, PhD holders research, teach, and write about high-level policy-related and medical topics throughout the field. Advancement to senior-level positions usually comes with a master's degree and a significant level of accomplishment, so a PhD is rarely required. But if you want to effect change in the healthcare administration field on a broad level, a PhD can provide the necessary background.

    Planning for a Career in Healthcare Administration

    All healthcare administrators should show leadership potential, including the ability to achieve results and complete projects. Entry-level administrators should have strong analytical and computer skills, good writing and communication skills, and demonstrated teamwork ability. Those involved on the financial end certainly should be adept in corporate accounting procedures and in developing financial reports and budgets. Entry-level marketing assistants and operating assistants usually earn $50,000, and the typical workweek might stretch between 40 and 50 hours.

    Professionals moving into mid-level administrative positions should be knowledgeable about company, management, and clinical operations, especially medical managers. Candidates should possess a solid financial background, including knowledge of capital and operational budgets. A broad understanding of systems management and strategic achievement is also helpful. Because of a heavy emphasis on decision-making and management functions, mid-level administrators should have strong analytical, team-building, and communication skills. Salaries might start at $50,000 but easily surpass $85,000 depending on the type of organization and skills required. A mid-level healthcare administrator can expect to work 45 to 55 hours a week.

    A master's degree and 10 years of management experience are basic requirements for senior-level administrators. These jobs involve strategy building and experience with positioning products and services in the marketplace. Senior-level executives are usually charged with strategic planning, raising capital, and following insurance and reimbursement regulations. They need a broad understanding of systems management and the effect of market and environmental changes on the organization. Healthcare executives at the senior level can earn base salaries from $150,000 to $250,000. Bonuses and stock options are often part of an executive package. However, senior-level executives often work 70 or more hours each week.

    What can you do with a College Degree in Healthcare Administration?

    Career Specializations within administration of health care

    A career in healthcare administration presents you with an opportunity to make a significant contribution to the health of the citizens in your community. Options for healthcare executives have never been more diverse. You might accept leadership roles in provider services such as hospitals, physician group practices, nursing homes and home health agencies; in insurance companies and HMOs; or for companies that sell the supplies and equipment for healthcare providers.

    Some of the specialized areas for entry- and mid-level administrators are in finance, government relations, human resources, information systems, marketing, medical staff relations, patient care services, and planning and development. Graduates may choose to work for local, state and federal agencies or with private foundations such as the Red Cross or the American Hospital Association. The U.S. Bureau of Labor Statistics divides the healthcare industry into nine segments:

    Hospitals. Most hospitals provide a complete range of medical care, ranging from diagnostic services to surgery. However, some hospitals specialize in treatment of the mentally ill, cancer patients, or children. The vast array of services requires constant attention to efficiency and quality care. So hospitals employ many mid-level administrators to oversee specific areas.

    Nursing and residential care facilities. Nursing care and convalescent facilities provide around-the-clock personal and nursing care primarily to the elderly and those with limited ability to care for themselves. Some facilities specialize in other assisted-living needs such as alcohol and drug rehabilitation centers, group homes, and halfway houses.

    Physicians' offices. Physicians can work privately, align themselves with a group or hospital, or work in some combination of the two. About a third of healthcare businesses fall into this category. Working with a group allows physicians to share administrative expenses, reduce overhead costs, and provide backup services. Some physicians even work as salaried employees of a group.

    Dentists' offices. Similarly to physicians, dentists can work alone or in groups. Dentists' offices account for about 20 percent of healthcare businesses. As more people live longer lives with their natural teeth intact, experts expect a boom in the demand for dental services.

    Home healthcare services. For patients who do not need constant attention, or choose not to live in a nursing home, many organizations provide in-home services. Nurses or other health practitioners can be sent to a person's home as needed or on regularly scheduled visits. Because of constant improvements in home health services, this is one of the fastest-growing segments of the industry, and it needs good administrators to assure efficient operation. This segment will continue to grow as hospitals look to cut costs by treating people on an outpatient basis.

    Offices of other health practitioners. This segment of the industry includes chiropractors, optometrists, podiatrists, occupational and physical therapists, psychologists, audiologists, speech-language pathologists, dietitians, and other health practitioners. This segment includes alternative medicine practitioners, such as acupuncturists, homeopaths, hypnotherapists, and naturopaths. Frequently, various practitioners will ally themselves to operate more effectively as a group.

    Outpatient care centers. Kidney dialysis centers, outpatient mental health and substance abuse centers, health maintenance organization medical centers, and freestanding ambulatory surgical and emergency centers are parts of this segment.

    Other ambulatory healthcare services. This small but vital segment includes ambulance services, blood and organ banks, and other healthcare services such as pacemaker monitoring services and smoking cessation programs.

    Medical and diagnostic laboratories. These laboratories provide analytic or diagnostic services to medical professionals or directly to patients following a physician's prescription. The labs analyze blood, take X-rays or scans, and perform other clinical tests. It is the smallest segment of the industry in terms of total jobs.
















    (Excerpt Adaptation from Dr. Thomas Fuller)
    Share:

    Thursday, October 28, 2010

    How to Convert VMware SQL Server Express to SQL Server

    One of the things that I realized in having SQL Server Express installed with the vCenter server is that if the vCenter Server crashes (if it is a stand-alone physical server). You are stuck! You are trying like hell to get this server up. However, if you have a SQL Server 2008 Standard Edition Database server. Why NOT use it. Also, if you can convince your company, non-profit, or hospital to pony up on the SQL Server 2008 License. I would say go for it! Yes, you "can" install SQL Server 2008 Express on a server and have vCenter connect to this also. However, this tutorial is for an environment where you want a centralized SQL Server 2008 Database Server. This server will be the DB SVR for vCenter, VUM and whatever else you want to use it for.

    Scenario is based on 2 Physical stand-alone Dell PowerEdge R310 Servers (DC/vCenter) and 5 Dell PowerEdge R710 Servers. Windows 2008 Server Datacenter Edition, VMware ESXi 4.1, vCenter Standard 4.1, and Iomega StorCenter ix12-300r (8TB).

    40 VM's consisting of 2K3, 2K8, 2K8R2, RHEL 5.5, SUSE11-4VMware, UBUNTU10.4 Templates, DHCP on VM, DC2, DC3, File Server Cluster (2 Clustered on iSCSI SAN drive), Print Server Cluster (2), AV, WSUS, SQLSRV2K8 DB SRV, PROXY RHEL Cluster (2), VUM, VDR, VSHIELD (5), vDistributed Switches for 1GB Ethernet Intel NICs, HA/DRS Clusters.

    Here we go...Screenshots soon to come.

    1. Make sure you ISO's are on an NFS Share so that you can access them. Just Map a Drive to the NFS Mount. Use Virtual Clone Drive to kick off the ISOs. Virtual Clone Drive should be an ABSOLUTE MUST for your VMware Arsenal.

    1. Stop all of the VMware vCenter Services (i.e. vCenter, VUM, etc).
             ----> START >> Run >> services.msc (If it says vCenter stop it. Leave the VMware Tools alone).

    2. Copy all of the VIM_VCDB.mdf Database Files to your SQL 2008 Server.
             ---->START >> Run >> \\SQLSRV2K8DB\c$\Program Files\Microsoft SQL Server\ and then hit
             the enter key. You want to go to the "Data" Folder and drop the databases into this folder.

    3. Login to your SQL Server. Launch SQL Server. Connect to the server and right-click on Databases and "attach" the database. (I created a database and imported the migrated DB to the new created DB. You may decide to use the attached DB, but I wouldn't.)

    4. Right-click on the database and Backup the Database with a Full Backup.

    5. Open up ODBC (under Administrator Tools). Go to System DSN and Test Connectivity to the SQL Server 10.0 Native Client. Make sure your DB is the default (I named mine VCENTER since you can't jack this up and even Joe new guy will know not to touch this database.).  Make sure you can connect to the server because if you can't guess what. vCenter won't either.

    6. Uninstall vCenter Server from the Server and just re-install it. Point the vCenter DB to the new SQL Server 2008 Server and make sure you DO NOT OVERWRITE THE DATABASE!!!

    7. Launch vCenter and if it comes up. Your golden!

    References:
    http://www.vmware.com/files/pdf/vc_microsoft_sql_server.pdf
    http://www.ntpro.nl/blog/archives/1423-How-to-migrate-the-vCenter-database-to-Microsoft-SQL-Server-2008.html
    http://get-admin.com/blog/?p=646
    http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1028601
    http://www.sysadmintutorials.com/tutorials/vmware-vsphere-4/esx4/installing-vmware-view-4-composer/
    Share: