Take a databse back up with LINQ ?

[Mohammad Dayyan]

Hi guys. I'm using LINQ to modify a database. I want to take a back up from the database. Could you please guide me , how I can do it with LINQ ?

[Not Active]

You don't need Linq to backup a database. What is it that you want to accomplish?

---

only two letters away from being an asset

[Mohammad Dayyan]

I've created a SQL database beside my exe file, I'm trying to take backup from it through my application. At first , I've used File.Copy, but I receive this Exception cannot access because it is being used by another process Could you guide me, how I can do it ?

[Not Active]

Mohammad Dayyan wrote:

cannot access because it is being used by another process

Perhaps your application? If the app uses a mdf file as a resource then it is possibly loading the file at start up. That should give you a start of where to look.

---

only two letters away from being an asset

[Abhishek Sur]

Run normal backup code from your application, rather than to use File.Copy. File.Copy needs the mdf files to be detached from your server instance which is not good technique.

BACKUP DATABASE [DbName] TO DISK = N'C:\dbName.bak' WITH NOFORMAT, NOINIT, NAME = N'DbName-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

Just change the dbName, disk location for your backup and Name of the Backup file and run this using command.ExecuteNonQuery(). And believe me... you dont require LINQ for doing this . :-D :-D :-D

Abhishek Sur

---

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.

[Mohammad Dayyan]

Thanks Abhishek Sur. I'm using LINQ, so I've used the following code :

public static void GetBackUp()
{
if (!Directory.Exists(StaticVariables.BackUPFolder))
Directory.CreateDirectory(StaticVariables.BackUPFolder);

using (RezaRestaurant.SQL.DataClasses1DataContext dbc = new RezaRestaurant.SQL.DataClasses1DataContext())
{
    dbc.ExecuteCommand(@"BACKUP DATABASE " + dbc.Mapping.DatabaseName + " TO DISK='c:\\aaa.bak'");//Exception
}

}

and this Exception has occurred : http://www.codeguru.com/forum/attachment.php?attachmentid=25454&d=1253973435[^]