Sql Backup
-
hi everybody I want to take my database backup which is created in sql server 2000 in windows application using C# so i have no network its an independent system i want to display all sqlserver instances in combobox without internet(Lan etc..) how can i take backup my database using c# hope you help me thanks in advance nagendra...
-
hi everybody I want to take my database backup which is created in sql server 2000 in windows application using C# so i have no network its an independent system i want to display all sqlserver instances in combobox without internet(Lan etc..) how can i take backup my database using c# hope you help me thanks in advance nagendra...
I don't know which bit you are needing help with. Listing the SQL Server instances or taking the backup. You can use SMO (SQL Server Mangement Objects) to enumerate the available servers. http://msdn.microsoft.com/en-us/library/ms162169.aspx[^] Since a SQL Backup can only be done to the machine that a SQL Server resides on a LAN isn't necessary. In fact, it won't make any difference since the backup file must be local to the SQL Server. You can issue a backup command through the
SqlCommandobject in the .NET Framework andExecuteNonQuery().*Developer Day Scotland - Free community conference Delegate Registration Open