copy mdf and ldf files
Posted on 2015-01-26
proper and safe way to copy ldf and mdf files.
sql server is the rdbms
is it safe for me to stop the sql service and then copy the mdf files or ldf files.
or do i have to detach or brind the db's offline to make this a safe process.
i need to copy the mdf and ldf files on a instance but i can't use the backup service for this.
it needs to be a copy and paste job.
also, dumb question but thought i would check my bases.
making a copy of the mdf and ldf files is just as good as making a full copy only backup of a database correct.
thanks a bunch