InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 20:01:02 GMT20http://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxThank you, please don't forget to rate the articleWed, 27 Apr 2011 14:13:36 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxNice tip. Thanks for the post.Wed, 27 Apr 2011 11:08:00 GMTSQLKnighthttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxLocation: recovery.cpp:3080Expression: m_recType != REPLICASPID: 54Process ID: 1748Msg 1823, Level 16, State 1, Line 1A database snapshot cannot be created because it failed to start.Msg 1823, Level 16, State 2, Line 1A database snapshot cannot be created because it failed to start.Msg 3624, Level 20, State 1, Line 1A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support. Msg 9003, Level 20, State 5, Line 1The log scan number (45:1518:0) passed to log scan in database 'Mirror_Test' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. I also attached SQLdump file.--SQL Server Version -- Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)Fri, 04 Mar 2011 05:55:13 GMTtuntunhttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspx[quote][b]tuntun.oo (3/3/2011)[/b][hr]Excellent article.It gave me new trick.After testing with new File Group and File at principal, mirroring works.But, I cannot create database snapshot at mirror.Before adding File, the following one worked. CREATE DATABASE Mirror_Test_snapshot ON ( NAME = N'Mirror_Test_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Mirror_Test_Data_snapshot.snap') AS SNAPSHOT OF Mirror_Test; After adding File at Node1\Mirror_Test_FG_IDX_1.Mirror_Test_FG_IDX_1.ndf at principalRestoring at Node2\Mirror_Test_FG_IDX_1.ndf at mirror, this one doesn't work. CREATE DATABASE Mirror_Test_snapshot ON ( NAME = N'Mirror_Test_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Mirror_Test_Data_snapshot.snap'), (NAME = N'Mirror_Test_FG_IDX_1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Node2\Mirror_Test_FG_IDX_1_snapshot.snap') AS SNAPSHOT OF Mirror_Test;[/quote]do you get an error message, if so what is it?Thu, 03 Mar 2011 15:03:24 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxExcellent article.It gave me new trick.After testing with new File Group and File at principal, mirroring works.But, I cannot create database snapshot at mirror.Before adding File, the following one worked. CREATE DATABASE Mirror_Test_snapshot ON ( NAME = N'Mirror_Test_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Mirror_Test_Data_snapshot.snap') AS SNAPSHOT OF Mirror_Test; After adding File at Node1\Mirror_Test_FG_IDX_1.Mirror_Test_FG_IDX_1.ndf at principalRestoring at Node2\Mirror_Test_FG_IDX_1.ndf at mirror, this one doesn't work. CREATE DATABASE Mirror_Test_snapshot ON ( NAME = N'Mirror_Test_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Mirror_Test_Data_snapshot.snap'), (NAME = N'Mirror_Test_FG_IDX_1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Node2\Mirror_Test_FG_IDX_1_snapshot.snap') AS SNAPSHOT OF Mirror_Test;Thu, 03 Mar 2011 12:53:16 GMTtuntunhttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxGuysThank you very much for all your kind replies I'm glad you find it useful[quote][b]george sibbald (3/1/2011)[/b][hr]I think the lesson to take away though is to set your live and failover servers up with exactly the same drive\directory structures in the first place. :-)[/quote]George I couldn't agree more, although sometimes you may inherit a system and will have to roll with it. This is especially for these types of systemsTue, 01 Mar 2011 19:44:51 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxNice article Perry. ThanksTue, 01 Mar 2011 14:02:22 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxThank you very much for the article, it is good to learn about the pitfalls before actually falling into them.Tue, 01 Mar 2011 13:17:04 GMTUMG Developerhttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxnice article Perry and very useful info.I think the lesson to take away though is to set your live and failover servers up with exactly the same drive\directory structures in the first place. :-)Tue, 01 Mar 2011 11:06:58 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxHi Perry,Another good article, thanks for the tip!CheersJohnTue, 01 Mar 2011 02:40:06 GMTjohn.knight-557608http://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxgood article and good tip for addining files without the need to do a full backup and restore.Tue, 01 Mar 2011 02:32:42 GMTdave-djhttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspx[quote][b]dibbydibby (3/1/2011)[/b][hr]nice article. one question?in your backup TLog statement did you mean to say.... [code="sql"]BACKUP [b]DATABASE[/b] AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT[/code]?[/quote]Hiwell spotted, no the backup and the restore statement should readBACKUP LOGRESTORE LOGRegardsPerryTue, 01 Mar 2011 02:16:41 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxnice article. one question?in your backup TLog statement did you mean to say.... [code="sql"]BACKUP [b]DATABASE[/b] AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT[/code]?Tue, 01 Mar 2011 02:13:25 GMTdibbydibbyhttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxExcellent tip to "trick" SQL into thinking we did a full backup/restore of the DB to be able to move the new database file.Cheers,SteveMon, 28 Feb 2011 22:30:18 GMTS. Kusenhttp://www.sqlservercentral.com/Forums/Topic1070983-1452-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Database+Mirroring/72294/">Using Disparate File Paths in SQL Server Database Mirroring </A>[/B]Mon, 28 Feb 2011 22:29:17 GMTPerry Whittle