How do u backup SQL Server db with C# 3.0 ?
Add a comment
|
4 Answers
You can use SQL SMO to backup the database and perform other SQL functions through c#.
answered Jul 7, 2009 at 15:45
Quintin Robinson
82.6k14 gold badges128 silver badges132 bronze badges
Comments
You can call the "BACKUP DATABASE" SQL command using a SQL Command Object. You should be able to find some documentation but here is some basic syntax I found
Example
BACKUP DATABASE [Master] TO [MasterDevice] WITH
RETAINDAYS = 5, NOFORMAT, INIT, NAME = N'Master-FullBackup', SKIP, NOREWIND,
NOUNLOAD, STATS = 10
GO
Syntax BACKUP DATABASE {database_name | @database_name_var} TO [,...n] [WITH [BLOCKSIZE = {blocksize | @blocksize_variable}] [[,] DESCRIPTION = {text | @text_variable}] [[,] DIFFERENTIAL] [[,] EXPIREDATE = {date | @date_var} | RETAINDAYS = {days | @days_var}] [[,] FORMAT | NOFORMAT] [[,] {INIT | NOINIT}] [[,] MEDIADESCRIPTION = {text | @text_variable}] [[,] MEDIANAME = {media_name | @media_name_variable}] [[,] [NAME = {backup_set_name | @backup_set_name_var}] [[,] {NOSKIP | SKIP}] [[,] {NOUNLOAD | UNLOAD}] [[,] [RESTART] [[,] STATS [= percentage]] ]
Comments
You don't - C# is a programming language and as such is unsuitable for database maintenance. The .NET Framework has an API that will allow you to work with a SQL Server database but even this is not the best way to do database maintenance.
SQL Server has a rich array of tools that can be used for backing up a database. Please see these links for more information:
Comments
by executing a backup database command, but this has nothing to do with C#
