Unable to copy SQL Server Database MDF and LDF files

Question

HII detach databse from sql server 2008 and now I want copy ldf and mdf file but when I want copy  these files into other location below error happen   what should I doBest Regards Neda

Azim · Accepted Answer

This Link will guide you best for stop and start services of sqlhttptechnetmicrosoftcomenuslibraryhh403394aspxYou cannot simply COPY the mdf and ldf while the services are running  If you do not want to stop the service the other way that you can try is to make a FULL backup of your database The full backup database will contain both MDF and LDF file anyway

Mudassar · Answer

You will need to type servicemsc in RUN command windowand the find and stop SQL Server Service

Unable to copy SQL Server Database MDF and LDF files

Company

Explore

Follow us

Contact Us