Database

public bool BackUpDB(string DBpath)
        {
            try
            {
                // Create a new connection to the selected server name
                ServerConnection srvConn = new ServerConnection(Program.serverName);
                // Log in using SQL authentication instead of Windows authentication
                srvConn.LoginSecure = true;
                // Create a new SQL Server object using the connection we created
                srvr = new Server(srvConn);
                // If the user has chosen a path where to save the backup file
                // Create a new backup operation
                Backup bkpDatabase = new Backup();
                // Set the backup type to a database backup
                bkpDatabase.Action = BackupActionType.Database;
                // Set the database that we want to perform a backup on
                bkpDatabase.Database = Program.databaseName;
                //set incremental to false because this is full backup
                bkpDatabase.Incremental = false;
                bkpDatabase.Initialize = true;
                //Specify that the log must be truncated after the backup is complete. 
                bkpDatabase.LogTruncation = BackupTruncateLogType.Truncate;
                // Set the backup device to a file
                BackupDeviceItem bkpDevice = new BackupDeviceItem(DBpath , DeviceType.File);
                // Add the backup device to the backup
                bkpDatabase.Devices.Add(bkpDevice);
                // Perform the backup
                bkpDatabase.SqlBackupAsync(srvr);
                return true;
            }
            catch (Exception)
            {
                return false;
            }
        }

public bool RestoreDB(string DBpath)
        {
            try
            {
                // Create a new connection to the selected server name
                ServerConnection srvConn = new ServerConnection(Program.serverName);
                // Log in using SQL authentication instead of Windows authentication
                srvConn.LoginSecure = true;
                // Create a new SQL Server object using the connection we created
                srvr = new Server(srvConn);
                // If the user has chosen the file from which he wants the database to be restored
                // Create a new database restore operation
                Restore rstDatabase = new Restore();
                // Set the restore type to a database restore
                rstDatabase.Action = RestoreActionType.Database;                
 
                // If specified database does not exist create it by using master database
                if (!srvr.Databases.Contains(Program.databaseName))
                {
                    try
                    {
                        DbConnection dbcon = new DbConnection("Data Source=" + Program.serverName + ";Initial Catalog=master;Integrated Security=True");
                        dbcon.ExecuteCommand("CREATE DATABASE "+Program.databaseName, null);
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("Veritabanı yaratılırken hata oluştu. Program yine de yedeğinizi geri yüklemeye çalışacak. Ancak bu değişiklik programınıza yansımayabilir. Bu durumda bizimle iletişime geçiniz.","Uyarı",MessageBoxButtons.OK,MessageBoxIcon.Warning);
                    }
                }
                
                // Set the database that we want to perform the restore on
                rstDatabase.Database = Program.databaseName;
                
                rstDatabase.Devices.AddDevice(@DBpath, DeviceType.File);
 
                // If the database already exists, replace it
                rstDatabase.ReplaceDatabase = true;
                // Perform the restore
                rstDatabase.SqlRestoreAsync(srvr);
                return true;
            }
            catch (Exception)
            {
                return false;
            }
        }

NGB	CCU	0	0	0	0	6
NGB	CCU	0	0	4	0	0
SHA	SIN	0	0	0	0	4
SHA	SIN	0	0	0	1	0
SHA	SIN	0	0	25	0	0

NGB	CCU	0	0	4	0	6
SHA	SIN	0	0	25	1	4