SQL Server in “Recovery Pending” status after reboot

We have quite a few programs of our own design which communicate to our SQL Server (SQL Server 2014 Express). Every now and then they start blowing up all over the place; we run around trying to figure out what’s wrong, only to open up SQL Server Management Studio and find that our database isn’t running.

To be more specific: we open SSMS, expand the “Databases” node and it says:
[DATABASE NAME] (Recovery Pending)

Opening the SQL Server Configuration Manager and restarting the service for the down database fixes the problem and everything starts to work again… for a while.

After running across this problem a few times, I’ve noticed that it only happens after we reboot the server- though not every time. Meaning that sometimes when the server boots up, SQL fails to do the same. An interesting fact is that we have multiple databases running on the SQL server and they don’t go down together; one of the databases might say “(Recovery Pending)” while the other one works fine.

I have not been able to find a solution to this problem- or even a cause. Any ideas?

EDIT:

After going through the server’s event logs I found this:

Log Name: Application
Source: MSSQL$SQLEXPRESS
Event ID: 17204
Task Category: Server
Level: Error
Keywords: Classic
Description:
FCB::Open failed: Could not open file C:Program FilesMicrosoft SQL ServerMSSQL12.SQLEXPRESSMSSQLDATADuraDB.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).

What would be causing the file to lock, especially after a reboot?

All topic

Databases in ‘Recovery Pending’ and ‘Backup:CommitLogArchivePoint’ not committing

I’ve got a bit of an odd one that I’m wondering if anyone’s seen before.

Last week I had a bunch of databases showing as ‘Recovery Pending’.

Some digging at the time found that SQL was complaining about the trans log being full even though there was a ton of space on the disk and none of the logs were restricted in anyway.

All that the server log shows is ‘The Transaction Log for the Database ‘XXX’ is full due to ‘ACTIVE_TRANSACTION’

The AG was failed over and things are working fine but I’ve been doing some digging and can see what happened but don’t understand why.

Basically, after a log backup takes it should update the boot page using a transaction named ‘Backup:CommitLogArchivePoint’. Looking at the databases, there is an active transaction ‘Backup:CommitLogArchivePoint’.

With a spot more investigation and poking around in the transaction log I can see ‘Backup:CommitLogArchivePoint’ start but it never committed for the affected databases. The boot page is updated but the transaction is left uncommitted which obviously means that the transaction log can’t be truncated or (for some reason I’m guessing is because SQL thinks that something is changing the boot page) grown out.

Has anyone seen this behaviour before, it happened on a random handful of databases at various points during the day? I’ve not seen any occurrences since failing over the AGs. Any help in understanding what caused this would be great as I’m pulling my hair out here.

Thanks!

All topic

Fuhu Nabi 2 tablet bricked recovery

Total noob here, sorry… I’ve spent the last three weeks reading up on my issue with no progress at all. I think I have the answer, but need to run this by someone who probably knows!

I modded a stock UK Nabi 2 with nabilab2 from the xda forums, http://forum.xda-developers.com/showthread.php?t=2101277 I needed to do an ota update from Nabi and needed the device to be returned to stock. I lost my original backup so I used the generic stock backup that comes with nabilab2. This put the device back to US stock, with no root privileges or serial number.

There were three ota’s, during the instal of the third one, the device crashed – a ton of text sprawled up the screen the device shut down-restarted and booted into <3e> recovery. At that point I had lost TWRP recovery.

Several weeks of reading and falling at every turn… Here is where I am now; The device boots and is usable, I can install apk files and use the tablet normally, however I cannot update. The last ota I need to install downloads via the update service, but fails with errors upon install. I also downloaded the ota manually via the xda forums nabi 2 wiki page and tried to install from the sd card but that fails too. (maybe as my UK stock with serial device, is now a US stock with no serial device, which is causing a signature fail during install of the latest ota?). The device is no longer rooted, so no shell r/w access. I cannot see the device in fastboot. Using the command ‘reboot recovery’ reboots the device but then it freezes up and is no longer seen via usb. When ‘Fastboot recovery’ option is chosen in <3e> recovery the device locks up, and the same thing happens when choosing ‘Forced recovery’. All signed recovery .zips I have tried to install through <3e> recovery fail with the message ‘file verification failed’.

I’m kinda going round in circles with this… I know I need to root to get TWRP back, which allows a custom kernel/recovery to be used, but as I have no Su permission I have no r/w privileges to install the super user files and/or recovery image files to the necessary places. So unless there is some way to get the required recovery files onto the device by the adb command without su access (I’m doubtful of), or via a modded/signed recovery image zip file within <3e> recovery (which again I’m doubtful of, as other signed .zips fail), I’m guessing that the device is bricked?

Any feedback to help solve/answer will be gratefully appreciated.

All topic

Question: System recovery windows 8.1. Can/should I use an image made on another PC?

Question: System recovery windows 8.1. Can/should I use an image made on another PC?

Question: System recovery windows 8.1. Can/should I use an image made on another PC?

My desktop has been black screening after it hits the windows logo when booting up. I think my SSD that has my OS on it has started to fail (never did back that thing up). I want to keep my files if possible.

So I need to either Refresh the PC using the “Windows installation or recovery media” (in the slow process of getting) or do a System Restore/System Image Recovery, neither of which I have available right now. I have no restore points.

What would you recommend I do? I’ve just initialized the download of 8.1 from the Microsoft website on my laptop, which I assume will work. Would it work just as well, be better, faster or even work, to make an image of my Laptop OS and refresh my desktop with that?

Should I just get Windows 10? Should I make sure that this works first, back up my OS and then upgrade to 10?

Thanks for any advice given

All topic

Wallet recovery help – 24 words length mnemonic seed [duplicate]

This question already has an answer here:

  • Missing one word from 25 word mnemonic seed

    3 answers

I have a 24 length mnemonic and I’m having hard time to re-sync my wallet. I tried different ways but it seems the 25 length mnemonic is a standard now. Please note that the last word of my mnemonic is a duplicate. So I tried to sync through gui-v.0.12.3.0 which gave me 0 balance. I also tried https://xmr.llcoins.net/ (offline) but it says: ‘You seem to be missing the last word in your private key, please try again’. The last thing that I didn’t try is to write mnemonic to https://mymonero.com since it will cost me 1xmr. Is there any other way? I don’t know my private spend/view keys.

Thanks for any advice!

All topic

Acer Aspire s7-391 BIOS recovery

Model: Acer Aspire S7-391; 256GB SSD/4GB RAM; OS: Windows 10

Before going dead, the laptop used to randomly display ‘no bootable device found’ warning while turning it on. But usually it booted up with two or three times using the power button. One fine day, it went off suddenly while using it on battery and since then whenever i try to power it up – there’s only black screen without Acer logo. Now, the present state is whenever I power up the laptop, there is no response except the continuously glowing power LED till i manually power it off.

I tried the following solutions after reading some forums..
Connected with an external monitor to rule out the screen issues
Battery reset (pinhole)
Removed and reinstalled battery
Removed the SSD and tried to boot – still black screen. So reinstalled it
Tried hardware reset using power button and F12 key (In S7, F12 is Fn+F12)

Assuming it to be a corrupt BIOS after reading a number of forums where there are numerous reports of Acer Aspire models suffering from similar issues, i decided to do a BIOS recovery. I downloaded the “BIOS_Acer_2.18_A_A.zip” from their website and extracted the files on to the root of a “FAT32” formatted USB stick. Removed the battery out of the laptop, and plugged in the power cord. With the Fn+Esc keys held, i used the power button to turn the laptop on and then released the keys after the Power LED turned on. But there is no response (no symptoms of USB stick being read – the green LED indicator which blinks when it is read did not even blink once). I tried to rename the “isflash.fd” file to “Heliumx64.fd” as mentioned in their service manual, no luck. Now my question is – Was i supposed to change the BIOS settings (while the laptop was working) in order to do a BIOS recovery through USB stick? What are the files that are supposed to be in USB stick? I am not sure if i am missing something here! Please help!

All topic

Why can’t Odin recognize the phone in system recovery?

If I boot the phone in system recovery, it doesn’t detect the phone:

But when I boot the phone normally, Odin can detect it:

If I flash TWRP recovery anyway, the log is:

 Odin engine v(ID:3.1005)..
 File analysis..
 SetupConnection..

and it’s stuck there (which makes sense).

I have unlocked OEM and USB debugging. More Information:

  • Odin version: 3
  • Phone: Samsung J1-6 J120H

All topic

mount: No such file or directory with encrypted recovery

I have destroyed my Mint Linux installation. I just wanted access to my remote storefront. So what happened was I was having trouble with ICEauthority file in my home directory. So following different directions on the internet I came to the conclusion that I could set the home directory recursively to chmod 755 to allow that file to work…eventually I ran into problems with the system loading. Eventually by setting the home directory to executable permission for root was I able to get read/write access…but then i reset my machine oh why oh why did i reset my machine!!! – now the system throws me the same error with ICEauthority but it never gets me into the OS because the disk is encrypted. Nothing I’ve tried seems to work and I don’t have the original mounting seed. I’ve also tried sudo ecryptfs-recover-private but my system then just says No such file or directory:

frankenmint@honeybadger /home $ sudo ecryptfs-recover-private
INFO: Searching for encrypted private directories (this might take a while)...
INFO: Found [/home/.ecryptfs/frankenmint/.Private].
Try to recover this directory? [Y/n]: y
INFO: Found your wrapped-passphrase
Do you know your LOGIN passphrase? [Y/n] y
INFO: Enter your LOGIN passphrase...
Passphrase: 
Inserted auth tok with sig [979c6cdf80d2e44d] into the user session keyring
mount: No such file or directory
ERROR: Failed to mount private data at [/tmp/ecryptfs.Hy3BV96c].

I’m really worried because I had important files on there that were stored on a virtual machine…If I could just get to those files then I would have no qualms nuking the setup and starting over

All topic

Phone stuck on loading screen and recovery mode doesn’t work

I have a Samsung Galaxy S1 with CyanogenMod, and I don’t know what happened but when I turn on the phone it just stays on the loading screen, something like this:

It’s just a black screen with that little loading icon in it (without animation) I tried running both recovery and downloading mode (Volume Up/Volume Down, Menu, Power) but nothing works.

There is another strange behaviour, sometimes it show me the “Downloading…. do not turn off target !!!” message. When it is in that screen, the PC does recognise the Samsung driver but I have no access to it, and Odin doesn’t find the device.

Any advice please?

UPDATE :
After charging it for few hours (wall) the phone now isn’t stuck in the loading screen, instead it goes directly to “Download Mode” (Downloading … Do not turn off Target !!!).

When I plug it to the PC, it installs a driver then a message (windows driver)
“SAMSUNG USB Composite Device Ready to use”.
The bad new is that Odin doesn’t recognize the device :/

I have Samsung Kies installed (a long time ago for my Samsung Wave Y), I also made sure that it’s not working on background though. I have also installed the Samsung USB driver manually. I really don’t know what to do next.

All topic

ASUS_T00J zenfone 5 recovery mode shows no command

I have an Asus Zenfone 5 (ASUS_T00J). When I go to recovery mode from droidboot it only shows no command. What might be the problem?

All topic