The current location of data & log file of sql server express,
"C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA"
I got this following error when I tried to copy the database .mdf and .ldf files to another location.
"This action can't be completed because the file is open in sql server(SQLEXPRESS)".
To Resolve this open windows service and stop the sql server(Express) service.
How to open Windows Service?
Prees Windows+R and open run command and type "Services.msc" and Click Enter.
Search for "SQL Server(Express)"
Right Click on it and click stop button.
and then try copy and paste the database files to another location.
Post your comments / questions
- How to fix HAXM is not installed |in Android Studio
- How to fix CMOS Checksum Error in Computer or Laptop | SOLVED
- Reactivating windows after a Hardware change on PC or Laptop
- FIXED: Windows reported that the hardware of your device has changed. Error code :0xc004F211
- "redirect" is not defined pylance("reportUndefinedVariable)
- Unicode error 'unicodeescape' codec can't decode bytes in position 2-3: truncated UXXXXXXXX escape
- Could not find the 'angular-devkit/build-angular:dev-server' builder's node package | Angular Error
- Error: error:0308010C:digital envelope routines::unsupported