how to convert Mdf/ldf database files to .bak file (db restore) using T-SQL or .net code

sql-server database-restore mdf ldf
Amr Elnashar picture Amr Elnashar · Jan 6, 2011 · Viewed 7.9k times · Source

I have sql server database files (Mdf/Ldf) and i want to convert them to backup file using T-SQL commands or .net Code (C# or Vb.net).

any suggestions.

thans

Answer

Sachin Shanbhag picture Sachin Shanbhag · Jan 6, 2011 
BACKUP DATABASE [NameOfDatabase] TO  DISK = N'D:\path\filename.bak' 
WITH NOFORMAT, NOINIT,  NAME = N'NameOfDatabase-Full Database Backup', 
SKIP, NOREWIND, NOUNLOAD,  STATS = 10  

Replace NameOfDatabase with name of your database.
Replace D:\path\filename.bak with place you want to backup with
Replace Name = N database name for cosmetic indexing reasons...

Original source - http://forums.asp.net/p/1448416/3870094.aspx

Related questions

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)

I am using SQL Server 2008 R2 Standard (version 10.50.1600.1) for my production website and SQL Server Express edition with Advanced Services (v10.50.1600.1) for my localhost as a database. Few days back my SQL Server crashed and I had to install a …

Read More
Import .bak file to a database in SQL server

I have a file with .bak extension. How can I import this date to a database in SQL Server?

Read More
How to import a bak file into SQL Server Express

I have a .bak file, and I want to use this file to recreate the database in a fresh install of SQL Server 2008 Management Studio. Can someone point me in the right direction on how this can be done? I …

Read More