3
votes
1answer
1k views

How to move folder of SQL Server LocalDB instances from the default location?

I get multiple errors with LocalDB (startup error, can't create DB from SQL Server Management Studio and also multiple issues when trying to restore a backup) and none of the fixes I found are helping ...
2
votes
2answers
918 views

Remove Database from SQL Management Studio Database List

I'm working with MS SQL Express 2008 and Visual Studio 2010. If you are attached to a local MDF file how do you remove it from the Databases list without deleting the file? The reason is to purge the ...
3
votes
1answer
956 views

Removing Instances and SQL Server Express edition and going to Standard/Developer/Enterprise

I would like to move from SQL Server 2008 R2 Express to SQL Server 2008 R2 Developer or Enterprise. I just noticed that I have the following services running: SQL Server (MSSQLSERVER) SQL Server ...