Regarding mdf file

[lalitN]

Hi All, How we make the .mdf file of a database ? I want a script or C# code that could be used in a utility in C#.Net. Please help !! Regards, Lalit

[Lost User]

lalitN wrote:

How we make the .mdf file of a database ?

That extension is used both for Sql Server as well as Microsoft Access. Which are you targetting?

Bastard Programmer from Hell :suss:

[lalitN]

I am using SQL Server 2008 R2.

[Lost User]

The command to create a database is documented here[^], examples are at the bottom of the page.

Bastard Programmer from Hell :suss:

[lalitN]

Hi, Can we create the mdf file by taking the backup of one existing database ? Regrds, Lalit

[Lost User]

Yes. Backup the existing database, and restore[^] it. Keep in mind that this procedure will convert "older" database versions (backups from 2005) to the format of your server (2008R2).

Bastard Programmer from Hell :suss: