backup

Question

hi How can i take backup of SQL Server 2005 which created with the use of c# 2005 for windows application.

Mahesh Chand · Answer

Go to the Management Studio right click on your database name and select Tasks >> Back up option and follow the wizard stepos. If you are looking for backup from the code here are some articles on backup: SQL Server Backup file in standard Zip format by Joshy George on Oct 12 2006 This is SQL Server Backup and restore tool the system will store the backup files in standard Zip format the user-friendly screen let you backup and restore SQL Server database to local harddisk or remote network driver easily and quickly.The program can restore database easily. Automated Backup with NAnt by Liam McLennan on Aug 22 2006 An article describing how to use the NAnt build tool to create a custom automatted backup process. Automatic SQL Server Backup Utility using Sqlserver Agent by Joshy George on Oct 06 2006 It is a sample C# (VS2005) application for Automatic Sql server Backup Utility using sqlserveragent. I have used SQL-DMO dll. This article will show you how to create a automatic backup in Sql server 2000. FuliggineBackupper in C# by zeppaman on Aug 24 2006 This articles shows how to create a simple backup manager in C#. Creating SQL Server Database Dynamically in .NET using SQL DMO by Joshy George on Oct 05 2006 It is a sample ASP.NET and Visual Studio 2005 application for creating a SQL Server database at runtime. I have used SQL-DMO dll. This article will show you how to create a database in SQL Server 2005 and 2000.