How to create SQL Server 2008 database full backup programmatically in desired folder

Question

How to create SQL Server 2008 database full backup programmatically in desired folder with using Microsoft visual studio 2010 c#

possible dublicate -> stackoverflow.com/questions/3953598/… — Andrew Orsich
– Andrew Orsich, Commented Dec 16, 2010 at 23:52
@Bugai13 that is about how to restore. but i have to learn how backup first :) — Furkan Gözükara
– Furkan Gözükara, Commented Dec 17, 2010 at 1:29

Alex · Accepted Answer · 2010-12-17 00:34:33Z

6

Just execute SQL Server command

 BACKUP DATABASE database_name TO DISK='d:\path\to\backup\file\on\the\server.bak'

answered Dec 17, 2010 at 0:34

Alex

2,46823 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

marc_s Over a year ago

And just remember that you can only backup to drives attached to your SQL Server machine (including UNC paths); you cannot back from a server to a local drive on your PC

Furkan Gözükara Over a year ago

so it is this much easy. i will try now :)

Furkan Gözükara Over a year ago

ok i tried and it works great. but 2 questions. can there be any timeout problem because my database is really big ? also is this same with ms sql server management studio right click desired database tasks backup full ?

Alex Over a year ago

1) probably yes; and 2) yes, created backup has exactly the same format.

Ciaran Gallagher Over a year ago

Hi, does this command also work with SQL Server 2005? Must either SQL Server 2005/2008 have to have any particular components installed (e.g. SMO components)? Thanks

|

Collectives™ on Stack Overflow

How to create SQL Server 2008 database full backup programmatically in desired folder

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related