How to create SQL Backup and Restore Server-based (.mdf) Database built in Visual Studio 2010?

carm_ella

I want it in runtime using C#.

kalaisw

Hi, Try following links Using SMO for Backup, Restore and Security Purposes[^] SQL Server 2005 Database Backup and Restore using C# and .NET 2.0[^]

Lost User

carm_ella wrote:

I want it in runtime using C#.

You want mayo with that, hon? Should I wrap it, or are you gonna eat the code right away? :^)

Bastard Programmer from Hell :suss:

carm_ella

Thank you! I want the code sir. However, can you give me some tutorials on how to create SQL database in visual studio 2010 using c# with backup and restore? I knew a lot in MySQL using a server package of it and currently studying SQL built-in in VS2010. :)

Lost User

First, the answer to your question; BACKUP[^] and RESTORE[^].

carm_ella wrote:

I want the code sir.

You have been given links to the manual. I suggest you read it and write the code.

Bastard Programmer from Hell :suss: