How to delete the localdb instance owned by System

Question

I deleted the localdb instance files which were located in

"C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0"

by accident. The system cannot start the localdb instance now. The way that I know how to fix the issue is to delete the instance by command

"sqllocaldb delete instancename"

, and re-create the instance again. But I found this approach could only work for user account if I deleted the instances files located in

"C:\Users\UserName\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0"

So how can I solve this problem to delete the db instance owned by System?

Answer 1

Get PsExec from here: http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx

Run cmd.exe as LocalSystem as demonstrated in this link: How do you run CMD.exe under the Local System Account? psexec -i -s cmd.exe

Now you can run SqlLocalDb stop InstanceName and SqlLocalDb delete InstanceName