MSSQL ‘Recovery Pending’ Problem

Back to homepage

To solve MSSQL Recovery Pending problem follow the steps

  • Stop SQL
  • Remove transaction log on this database
  • Change database mode to emergency mode and restart database
  • After restart run this commands for your database

ALTER DATABASE [DB_Name] SET EMERGENCY;

DBCC checkdb ([DB_Name], REPAIR_ALLOW_DATA_LOSS )

ALTER DATABASE [DB_Name] SET online;

ALTER DATABASE [DB_Name] SET Multi_USER WITH NO_WAIT

Uninstall Edge from Windows 10

To uninstall Microsoft Edge from Windows 10 Close the Edge browser on your computer.Open the file explorer. You can easily do this by right clicking the Windows start button and then selecting File Explorer.In the file explorer, select This PC.Once in this PC navigate...

High Performance is not shown on PowerSetting

Right click StartSelect RunType regedit and press enter to open the registry editorGo to the folder: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\PowerOn the right, check one of the keys called CsEnabledClick on that keyChange the value from 1 to 0Restart your...

Convert an MBR disk into a GPT disk

Converting using the Windows interface Back up or move the data on the basic MBR disk you want to convert into a GPT disk.If the disk contains any partitions or volumes, right-click each and then click Delete Partition or Delete Volume.Right-click the...

MacBook Virtual Keyboard solution for broken touchbars

The solution was in Karabiner. Download Karabiner. Downloaded the "Map fn + number keys to their corresponding function keys" plugin If you need help you can reach us free online remote support over Anydesk. https://karabiner-elements.pqrs.org/

Prevent deleting Google Chrome history

It is absolutely possible in windows. You can do it by adding a policy to the chrome browser using Registry Editor. Click the Windows button and search for Registry EditorRight-click on it and select Run as administrator.Navigate to HKEY_LOCAL_MACHINE >...

Lenovo 13 Thinkpad series camera freezes after 2 sec

Its realy big problem for Lenovo, when you started the camera, it freeze 2-3 seconds later. Thats the solve 🙂 Press Windows key + R, type regedit, and press Enter.Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Media Foundation\Platform.Right-click on the...

Print non-white colors in your PDF file as only black

On Windows, you can print all of the non-white colors in your PDF file as black, resulting in a simple monochrome printout. Printing as black is useful for printing PDFs that contain text only, or for printing engineering drawings that have lightly colored lines....

Change default browser page Edge to Explorer

Open Microsoft Edge browserGo to SettingsSelect Default browser tab optionin the internet Explorer compatibility setting, you will see an option "Let Internet Explorer open sites in Microsoft Edge" , the default value is Incompatible Sites only(Recommended). You can...

Mac SMC reset

Just hold down Shift+Option+Control when the laptop is off for 7 seconds. It will turn on. After 7 seconds keep holding the keys down and additionally press the power button (Touch ID). The laptop will turn off. Wait a few seconds then turn it on normally, and your...

Delete Windows partition on Mac bootcamp

Launch the Boot Camp Assistant.Click the Continue button in the first screen.Select the Create or Remove a Windows Partition option in the next screenClick Continue again.Select the drive that has your Boot Camp partition, enable the Restore Disk to a Single Mac OS...