While sql server is active, some related data folders are not allowed to be copied.
2006-10-27 02:38:47 · 4 answers · asked by x_squared 4 in Computers & Internet ➔ Programming & Design
No it does not cause any damage to data.But if u want to copy the .mdf database files u have to stop the server.Then copy the databse to the folder C:\Program Files\Microsoft SQL Server\MSSQL\Data.
and u also have to attach that database also from enterprise manager
click microsoft SQL server->SQL server groups->local(databases)->then right click here u will get the option to attach database in all task submenu.Only thne that database can be used.
2006-10-27 03:24:47 · answer #1 · answered by Friend 2 · 0⤊ 0⤋
Yes surely I myself has done it to make my PC faster it only stops the sQl server processes to stop temporarily.
2006-10-27 10:01:32 · answer #2 · answered by sunny 2 · 0⤊ 0⤋
It is definitely not encouraged to do that since there are risks involved although the regular kill signal will allow the program to do a clean exit if it responds properly.
2006-10-27 09:42:03 · answer #3 · answered by juliepelletier 7 · 0⤊ 1⤋
Na..no damage.
2006-10-27 09:40:24 · answer #4 · answered by Josh B 5 · 0⤊ 0⤋