Detaching SQL Database .mdf file !

[jeshra279]

I have a SQL database .mdf file.I want to detach this database mdf file and then copy the file into a new directory using VisualBasic code. How to do this?

[Mycroft Holmes]

I recommend that you BACKUP the database instead of copying the MDF.

Never underestimate the power of human stupidity RAH

[jeshra279]

I was trying to backup the database file by copying it from one folder to another, but it is throwing error that file is in use. So I thought of detach it first and then copy. So How to do this?

[Mycroft Holmes]

The file is in use because the (SQL) server is using it - always. There are some excellent examples of how to take a backup correctly[^] right here on CP

Never underestimate the power of human stupidity RAH

[Abhishek Sur]

Use this :

BACKUP DATABASE [DataBaseName]
TO DISK = N'D:\DataBases\BackupDB.bak' WITH
NOFORMAT,
NOINIT,
NAME = N'DataBaseBackup-Name',
SKIP,
NOREWIND,
NOUNLOAD,
STATS = 10

Create an object of SqlCommand and pass this as CommandText. Run this in master Database (I mean the connection object should point to master database) Use ExecuteNonQuery to take backup to Disk location mentioned. :rose:

Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.

---

My Latest Articles-->** Microsoft Bing MAP using Javascript
CLR objects in SQL Server 2005
Uncommon C# Keywords/xml>