Taking copy of database programatiocally

[tijujoseph]

Please help me.
Any one knows how to take copy of a database programatically ?

[blackjack2150]

Please help me.
Any one knows how to take copy of a database programatically ?

What kind of database?

[tijujoseph]

it is an sqlserver 2005 database

[blackjack2150]

it is an sqlserver 2005 database

I don't know how it can be done for Sql Server databases. If it had been an Access of MySql database, then all you had to do was copy the files associated with the database to a desired location.

In the case of Sql Server, however it seems that the database files(two files for each database) cannot be copied from their location.("Cann ot read ...." error).
But I can't assure you that this is the definitive answer.

Best of luck!

[kenobewan]

Where do you want to copy it and what is you platform?

[tijujoseph]

i want to copy it to a local disk .
my platform is DotNet .i am using c# code