InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 01:40:41 GMT20http://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspxGood article. I might have missed it but I'm guessing that ideally you would want to place the snapshot on a different drive? JCTue, 27 May 2008 16:23:29 GMTJames Cornell-521376http://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspx[quote][b]John Bates (5/27/2008)[/b][hr]In the 3 companies I've worked for, none had the Enterprise Edition.It would be interesting to see a survey of the percentages of DBAs who have only Standard Edition versus Enterprise.Enterprise costs a lot more $ but doesn't really contain that many additional features that are useful to me.[/quote]I agree. When evaluating needs vs edition features for our organisation's new database servers, there wasn't enough justification to recommend going to Enterprise Edition given the price hike vs additional features offered. Some things like online index rebuilds would've been nice to have, but not at the price and not for what we were going to be running on the servers.Tue, 27 May 2008 14:27:21 GMTThe CosmicTricksterhttp://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspx[quote][b]John Bates (5/27/2008)[/b][hr]In the 3 companies I've worked for, none had the Enterprise Edition.It would be interesting to see a survey of the percentages of DBAs who have only Standard Edition versus Enterprise.Enterprise costs a lot more $ but doesn't really contain that many additional features that are useful to me.[/quote]An interesting point. I just made a survey for this question. [url=http://www.sqlservercentral.com/Forums/Topic507082-149-1.aspx]http://www.sqlservercentral.com/Forums/Topic507082-149-1.aspx[/url]Tue, 27 May 2008 10:51:36 GMTJason Shadonixhttp://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspxIn the 3 companies I've worked for, none had the Enterprise Edition.It would be interesting to see a survey of the percentages of DBAs who have only Standard Edition versus Enterprise.Enterprise costs a lot more $ but doesn't really contain that many additional features that are useful to me.Tue, 27 May 2008 09:56:02 GMTdbaforeverhttp://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspxWell, rookie, take your own advice. I did not say or imply that I read the whole article. I did read the intro and bailed out when I saw the Enterprise restriction.What I wrote about was unnecessarily clicking into the article because there was no restriction mentioned to prevent navigating to the article.Another word of advice, lighten up.Tue, 27 May 2008 09:37:06 GMTrbernstein-664486http://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspxIf you have read the introduction it cleary states that it is the Enterprise only edition. Please read carefully before you comment on any thing.Tue, 27 May 2008 09:28:55 GMTalimcitphttp://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspxSince this feature applies only to the Enterprise version, it would be nice if users were informed of the limitation before the click. I doubt that I am the only person to unnecessarily open the artice.Tue, 27 May 2008 08:43:36 GMTrbernstein-664486http://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspxThanks for the article.I wonder how good it would be to use for it reporting purposes. Besides reports running on the same server as a production db & the added overhead the older the snapshot is; what other performance issues should one consider/expect?Thanks,LianTue, 27 May 2008 02:10:42 GMTLian Pretoriushttp://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspxNice article......:)Tue, 27 May 2008 02:06:29 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic506674-1300-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Database+Snapshots/63004/">Database Snapshots</A>[/B]Mon, 26 May 2008 23:42:37 GMTalimcitp