Thread: Files in use
View Single Post
Old January 26th, 2008, 01:48 PM
urtrivedi urtrivedi is offline
Friend of Wrox
Join Date: Oct 2007
Location: , , .
Posts: 130
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via AIM to urtrivedi

By default there are two files associated with sql database
.mdf and .ldf

you can find this files in program files/mssql/........../data
if you want to keep copy of that file than stop sql service and then copy files
also you can use attach,detach database procedures