使用C#恢复SQL Server数据库

using System;
using System.Data.SqlClient;

namespace DatabaseRecovery
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
            string backupFilePath = "C:\\Backup\\YourBackup.bak";

            try
            {
                using (SqlConnection connection = new SqlConnection(connectionString))
                {
                    connection.Open();

                    // 恢复数据库
                    string restoreQuery = $"RESTORE DATABASE YourDatabase FROM DISK = '{backupFilePath}' WITH REPLACE";
                    using (SqlCommand command = new SqlCommand(restoreQuery, connection))
                    {
                        command.ExecuteNonQuery();
                    }

                    Console.WriteLine("数据库恢复成功！");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("数据库恢复失败：" + ex.Message);
            }

            Console.ReadLine();
        }
    }
}