http://www.sqlservercentral.com/blogs/robert_davis/archive/tags/Dynamic+Management+Views/default.aspxTags: Dynamic Management ViewsenCommunityServer 2007.1 (Build: 20917.1142)http://www.sqlservercentral.com/blogs/robert_davis/archive/2009/03/10/Database-Snapshots-Can-Take-a-Long-Time-to-Create.aspxWed, 11 Mar 2009 06:06:00 GMT70975365-724d-4ce8-8d1c-45c963ab81ff:10764Robert Davis0http://www.sqlservercentral.com/blogs/robert_davis/rsscomments.aspx?PostID=10764http://www.sqlservercentral.com/blogs/robert_davis/commentapi.aspx?PostID=10764http://www.sqlservercentral.com/blogs/robert_davis/archive/2009/03/10/Database-Snapshots-Can-Take-a-Long-Time-to-Create.aspx#commentsDatabase Snapshots Can Take a Long Time to Create Believe it, it&#39;s true!! One of the big selling point for database snapshots is that creating them is almost instantaneous. Since a database snapshot is created as an empty shell, it should be and almost always is a very quick process. What they don&#39;t tell you is long running active transactions can extensively delay the creation of the snapshot file. ...(<a href="http://www.sqlservercentral.com/blogs/robert_davis/archive/2009/03/10/Database-Snapshots-Can-Take-a-Long-Time-to-Create.aspx">read more</a>)<img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=10764" width="1" height="1">Tips &amp; TricksTroubleshootingDynamic Management Views