Backup of SQL Server Database using Command Prompt in C# and VB.Net

Question

Hello sir wheather  is it possible to take the backup of database from server by using command prompt Thnx in advance

Mudassar · Accepted Answer

ReferSQL Server Express Automated Backup Console Application C

dharmendr · Answer

Hi  chinmayyRefer below sample for creating the backup file using Console applicationThe following code uses TSQL script to run through and create the bak file in the location specifiedCodeCusing SystemTextusing SystemConfigurationusing SystemDataSqlClientclass Program    static void Mainstring args            ConsoleWriteLine34Enter Database name 34        string backupPath  34DFiles34         Generating Backup Script        StringBuilder sb  new StringBuilder        sbAppendLine34DECLARE name VARCHAR50 34        sbAppendLine34DECLARE path VARCHAR256 34        sbAppendLine34DECLARE fileName VARCHAR256 34        sbAppendLine34DECLARE fileDate VARCHAR20  CONCATCONVERTVARCHAR8 GETDATE 112 CONVERTVARCHAR6 GETDATE 115 34        sbAppendLine34SET path  3934  backupPath  3439 34        sbAppendLine34DECLARE dbcursor CURSOR FOR 34

Backup of SQL Server Database using Command Prompt in C# and VB.Net

SQL Server Express Automated Backup Console Application C#

Company

Explore

Follow us

Contact Us