SQL Server Database Mirroring with Simple Steps (Video)

SQL Server Database Mirroring with Simple Steps with Manual Failover

[pushkarmantridolphinunisys]

धन्यवाद नरेश. मानवासाठी खूप महान कार्य तुम्ही करीत आहात. डेटा उडल्यावर काय अनुभव असतो त्यातून नक्कीच शिकण्यासारखे आहे. मी व्यक्तीश: तुमचा ऋणी आहे.

[hansel]

Thanks for this simple yet very intuitive video. Much appreciated!👏

[thegodking]

You solved my Database (restoring...) loop problem. Error 1406. I love you

[fernandomori]

excellent video, so next time you will teach to failover principal to mirroring and mirroring to principal (two way)

[atuldangi]

Can we set bi directional syncing with 2 different SQL servers using this method?

[mariaguralnik]

Excellent up to the point where you executed the "Replication recovery database" file under the Projects folder. What's in it - is it built in SQL Server somehow?TIA! Maria

[huyo]

What problem when i mirroring while the system are in use? I just try to backup full DB and a transaction log but still get the eror: "The log in this backup set begins at LSN, which is too recent to apply to the database". What can i do to mirroring with big system and can stop that?

[DeveshSharmaishere]

Hi Naresh,

Excellent Video Tutorial there. Could you please advise on how to configure mirroring when the instances (principal and mirror) are running under LocalSystem ?

I am trying to configure Mirroring without witness and my principal seems unable to establish a connection with the mirror

Your insight will be greatly appreciated

Thanks

[revolutionu]

how you can remove failover?


thank you

[ahmedzidan]

I would like to ask..when i start mirroring it gives an error says database can;t be opened..it's in middle of restore...any ideas?

[muralisriram]

Hi Naresh how r u, i am murali ur friend we met wilshare with pcrao and mnrao

[bhuvanesh]

Is database needs to be imported on witness server?
Shall we use listener ip without installing third server?

[Dontneed_dear]

Naresh, when you restoring backup files successfully done in this video but one thing wrong i.e.., log file extension is trn but you just backup and restoring simply with extension both files with bak like (nareshfull.bak & nareshlog.bak) How it is possible?? log file must n should with trn extension ok

[erisheqeri]

which sql server did you use here and where did you got it cause i have tried many sql servers and neither of them has the mirroring option ... please help me :((

[youssragannoune]

hi man please help me i have a probleme when i click start mirroring now and i click yes after an error mesage show up error number 927 please help me i need your help

[JSunilKumar]

How to troubleshoot 927 error in Database Mirroring ?

[itguy]

Hello Sir,
Please tell us,
SQL database is mirrored from A location to B location,
How to configure the alert if mirroring gets broken . We should get an alert via email if mirroring gets broken.
Please reply.
Thanks

[bhuvanesh]

Is Sql express is enough for witness server?