P6 EPPM Upgrade (from 16.x to 17.12) – PART 1

Perform a database-only upgrade on a copy of production database to ensure the upgrade goes smoothly.

  1.  Using SQL Server Management Studio, make a backup of your production database and call it P6.bak to a different location.
  2. Create a blank database container.

 

3.  Call database name: P6-TEST and click OK.

4.  Restore database.

 

5. Source for restore is from device and check restore.

 

6. First, check ‘WITH REPLACE’ and ‘WITH KEEP_REPLICATION’.  Second, on PMDB_dat and PMDB_log add the name like this PMDB_dat_TEST.MDF and PMDB_log_TEST.ldf.  See next snapshot before clicking OK.

https://stackoverflow.com/questions/3829271/how-can-i-clone-an-sql-server-database-on-the-same-server-in-sql-server-2008-exp

7.  Do the same name change to PMDB_fs_doc_TEST.mdf and then click OK.

 

8.  Restoring database.

 

9.  Restore of database ‘P6-TEST’ completed successfully.  IF YOU DIDN’T GET ANY ERROR AT THIS POINT, THIS MEANS YOUR DATABASE UPGRADE IS SUCCESSFUL!  NOW YOU CAN PERFORM THE SAME PROCEDURE TO YOUR PRODUCTION DATABASE.

 

10. Test MDF and LDF directory.

Advertisements

Meraki MX64 WAN Ports

The Meraki MX64 comes with 1 WAN Port and 4 LAN Ports.  You can configure it to utilize one of the LAN ports for WAN #2.

PowerEdge R230 – UEFI Drivers Issues and L2/L3 Error Mesage

Avago EFI SAS Driver: Unhealthy status reported by this UEFI driver without specific error message(s).

UEFI0116: One or more boot drivers have reported issue(s).  Check the Driver Health Menu in Boot Manager details.

One or more boot drivers require configuration changes.  Press any key to load the driver health manager for configurations.

 

Resolution:

1. Power down system and remove the PERC H330 card.

2. Boot system and enter F2 setup menu and change BIOS UEFI mode to BOOT mode and Exit.

3. Boot system, you’ll get error message. That’s normal. Power down system.

3. Re-install the PERC H330 card.

4. Power up the system and press “X” when boot error prompt for user interaction.

5. Enter F2 setup menu and change BIOS BOOT mode back to UEFI mode. Exit BIOS and it should boot properly without L2/L3 error message

 

 

How to clear NVRAM.

NVRAM_CLR Jumper Reset

 

NVRAM_CLR Jumper Default

 

 

Winload.exe Missing in Windows 10

Unable to boot to Windows 10, winload.exe error.  The cause may be the boot configuration data is missing/corrupted.

Resolution:

Use a Windows 10 bootable disc or usb drive to boot to the menu like below.  Then following the screen shots.

Commands to repair critical disk structures are as follow (I’m retyping as shown the above image).

bootrec /rebuildbcd

Y

exit