InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 14:58:42 GMT20http://www.sqlservercentral.com/Forums/Topic1398892-1549-1.aspxIf you have a principal server with database file path "D:\MSSQL\MYDBS" and you create the database file "D:\MSSQL\MYDBS\adventureworks_data2.mdf" and the path does not exist on the mirror, this will cause the mirror session to be suspended. [url=http://msdn.microsoft.com/en-us/library/ms189127.aspx#FailedCreateFileOp][u][b]This link[/b][/u][/url] details that for mirroring to work seamlessly, the file paths should be synchronised between the servers.Fri, 28 Dec 2012 07:06:15 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1398892-1549-1.aspx[quote][b]Perry Whittle (12/28/2012)[/b][hr][quote][b]SQLCrazyCertified (12/27/2012)[/b][hr]Does anyone know what else can cause the mirroring to be in a [b]suspended[/b] state?SueTons.[/quote]Creating a new file on the principal when the file paths between the principal and the mirror are different[/quote]Hi Perry,Can u explain what exactly you mean creating a file, are you talking about new ndf file? Please advise with some example if you don't mind.SueTons.Fri, 28 Dec 2012 06:40:01 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1398892-1549-1.aspx[quote][b]Perry Whittle (12/28/2012)[/b][hr][quote][b]SQLCrazyCertified (12/27/2012)[/b][hr]Does anyone know what else can cause the mirroring to be in a [b]suspended[/b] state?SueTons.[/quote]Creating a new file on the principal when the file paths between the principal and the mirror are different[/quote]Hi PFri, 28 Dec 2012 06:38:22 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1398892-1549-1.aspx[quote][b]Perry Whittle (12/28/2012)[/b][hr][quote][b]SQLCrazyCertified (12/27/2012)[/b][hr]Does anyone know what else can cause the mirroring to be in a [b]suspended[/b] state?SueTons.[/quote]Creating a new file on the principal when the file paths between the principal and the mirror are different[/quote]Hi PFri, 28 Dec 2012 06:38:02 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1398892-1549-1.aspx[quote][b]SQLCrazyCertified (12/27/2012)[/b][hr]Does anyone know what else can cause the mirroring to be in a [b]suspended[/b] state?SueTons.[/quote]Creating a new file on the principal when the file paths between the principal and the mirror are differentFri, 28 Dec 2012 02:24:48 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1398892-1549-1.aspx[quote][b]Preet_S (12/20/2012)[/b][hr]Hi AllDoes anybody know if suspending db mirroring prevents automatic failover should the primary fail ?I know that Suspending stops transactions being sent to the mirror and the principal runs exposed, but would the witness still attempt to failover should the primary become unavailable ?Thanks in advancePreet[/quote]I believe, suspending mirroring means, it's paused somehow, can be done manually or can cause by many different things.....It can be due to network failure, or space issues.Does anyone know what else can cause the mirroring to be in a [b]suspended[/b] state?SueTons.Thu, 27 Dec 2012 08:53:13 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1398892-1549-1.aspxNo it most certainly will not failover automatically.Thu, 27 Dec 2012 06:23:43 GMTkenneth.gorehttp://www.sqlservercentral.com/Forums/Topic1398892-1549-1.aspxI do not believe so.[quote]Automatic failover requires the following conditions: The database mirroring session must be running in high-safety mode and must possess a witness. For more information, see Synchronous Database Mirroring (High-Safety Mode). [b]The mirror database must already be synchronized. This guarantees that all of the log sent to the mirror server has been written to disk.[/b][/quote][url=http://technet.microsoft.com/en-us/library/ms189590(v=SQL.105).aspx]Automatic Failover[/url]Wed, 26 Dec 2012 03:08:58 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1398892-1549-1.aspxHi AllDoes anybody know if suspending db mirroring prevents automatic failover should the primary fail ?I know that Suspending stops transactions being sent to the mirror and the principal runs exposed, but would the witness still attempt to failover should the primary become unavailable ?Thanks in advancePreetThu, 20 Dec 2012 03:59:15 GMTPreet_S