how to copy a sql server database using File.Copy function in C#

Question

how to copy a sql server database using File.Copy() function in C#

Mahesh Chand · Answer

I agree with Arshad.

Arshad · Answer

I will suggest you to go for to detach the data base save it where you need and again attach with the sql server. that is the way to do. Please check the below link. it might be helpful for you. http://social.msdn.microsoft.com/Forums/en/sqlsmoanddmo/thread/2708f62e-984f-48cb-a522-6e38d259cbc7 Regards Arshad.