Click here to Skip to main content
15,883,705 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello all,

I am learning SQL Server replication feature. I have configured replication on my SQL server instance. Everything works as expected in between source and destination DB.

My question is , what if i restore my publisher(source) db from backup taken before configuring replication. Will it overwrite replication settings? If yes then What steps do I need take if I want to restore it from old back which was taken before configuring replication.

What I have tried:

I tried restoring source DB and then replication stopped working
Posted
Updated 22-Oct-20 21:55pm

 
Share this answer
 
using System;
using System.Windows.Forms;

namespace KAYAN_YAZI
{
    public partial class Form1 : Form
    {
        private int xPos = 0, YPos = 0,Hiz=5;
        public string mode = "SoSa";
        public string mode1 = "Asagi";

        public Form1()
        {
            InitializeComponent();
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            if (mode == "SoSa")
            {
                int ss = -lblMesaj.Width;
                if (this.Width < xPos)
                {
                    xPos= ss;
                    this.lblMesaj.Location = new System.Drawing.Point(xPos, YPos);
                    
                    xPos += Hiz;
                }
                else
                {
                    this.lblMesaj.Location = new System.Drawing.Point(xPos, YPos);
                    xPos += Hiz;
                }
            }
            else if (mode == "SaSo")
            {
                if (xPos < (-lblMesaj.Width))
                {                    
                    this.lblMesaj.Location = new System.Drawing.Point(this.Width, YPos);
                    xPos = this.Width;
                }
                else
                {
                    this.lblMesaj.Location = new System.Drawing.Point(xPos, YPos);
                    xPos -= Hiz;
                }
            }

            if (mode == "Asagi")
            {
                int ss = -lblMesaj.Height;
                if (this.Height < YPos)
                {
                    YPos = ss;
                    this.lblMesaj.Location = new System.Drawing.Point(xPos, YPos);

                    YPos += Hiz;
                }
                else
                {
                    this.lblMesaj.Location = new System.Drawing.Point(xPos, YPos);
                    YPos += Hiz;
                }
            }
            else if(mode == "Yukari")
            {
                if (YPos < (-lblMesaj.Height))
                {
                    this.lblMesaj.Location = new System.Drawing.Point(this.Width, YPos);
                    YPos = this.Height;
                }
                else
                {
                    this.lblMesaj.Location = new System.Drawing.Point(xPos, YPos);
                    YPos -= Hiz;
                }
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            xPos = lblMesaj.Location.X;
            YPos = lblMesaj.Location.Y;
            mode = "SaSo";
            timer1.Start();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            xPos = lblMesaj.Location.X;
            YPos = lblMesaj.Location.Y;
            mode = "SoSa";
            timer1.Start();
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            Hiz = Convert.ToInt32(comboBox1.Text);
        }

        private void button4_Click(object sender, EventArgs e)
        {
            xPos = lblMesaj.Location.X;
            YPos = lblMesaj.Location.Y;
            mode = "Yukari";
            timer1.Start();
        }

        private void button5_Click(object sender, EventArgs e)
        {
            xPos = lblMesaj.Location.X;
            YPos = lblMesaj.Location.Y;
            mode = "Asagi";
            timer1.Start();            
        }

        private void button3_Click(object sender, EventArgs e)
        {
            if (button3.Text== "DUR")
            {
                button3.Text = "DEVAM";
                timer1.Stop();
            }
            else
            {
                button3.Text = "DUR";
                xPos = lblMesaj.Location.X;
                YPos = lblMesaj.Location.Y;                
                timer1.Start();
            }
        }

    }
}
 
Share this answer
 
Comments
CHill60 23-Oct-20 4:07am    
This has nothing to do with the original question. I advise you to remove this post before you are reported for abuse

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900