<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Basit Ali Farooq
»
Database Snapshots
Database Snapshots
Rate Topic
Display Mode
Topic Options
Author
Message
alimcitp
alimcitp
Posted Monday, May 26, 2008 11:42 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, January 14, 2011 7:53 AM
Points: 78,
Visits: 344
Comments posted to this topic are about the item
Database Snapshots
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
Post #506674
Anipaul
Anipaul
Posted Tuesday, May 27, 2008 2:06 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,816,
Visits: 1,343
Nice article......:)
Post #506736
Lian Pretorius
Lian Pretorius
Posted Tuesday, May 27, 2008 2:10 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 6:46 AM
Points: 1,144,
Visits: 1,112
Thanks 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,
Lian
Post #506741
rbernstein-664486
rbernstein-664486
Posted Tuesday, May 27, 2008 8:43 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, October 29, 2009 6:34 AM
Points: 15,
Visits: 23
Since 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.
Post #506962
alimcitp
alimcitp
Posted Tuesday, May 27, 2008 9:28 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, January 14, 2011 7:53 AM
Points: 78,
Visits: 344
If you have read the introduction it cleary states that it is the Enterprise only edition. Please read carefully before you comment on any thing.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
Post #507011
rbernstein-664486
rbernstein-664486
Posted Tuesday, May 27, 2008 9:37 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, October 29, 2009 6:34 AM
Points: 15,
Visits: 23
Well, 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.
Post #507019
dbaforever
dbaforever
Posted Tuesday, May 27, 2008 9:56 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, December 11, 2012 3:02 PM
Points: 135,
Visits: 460
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.
Post #507041
Jason Shadonix
Jason Shadonix
Posted Tuesday, May 27, 2008 10:51 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:49 AM
Points: 1,409,
Visits: 2,032
John Bates (5/27/2008)
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.
An interesting point. I just made a survey for this question.
http://www.sqlservercentral.com/Forums/Topic507082-149-1.aspx
Jason Shadonix
MCTS, SQL 2005
Post #507091
thecosmictrickster@gmail.com
thecosmictrickster@gmail.com
Posted Tuesday, May 27, 2008 2:27 PM
SSCrazy
Group: General Forum Members
Last Login: Thursday, June 06, 2013 8:37 PM
Points: 2,609,
Visits: 768
John Bates (5/27/2008)
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.
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.
Scott Duncan
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Post #507257
James Cornell-521376
James Cornell-521376
Posted Tuesday, May 27, 2008 4:23 PM
Grasshopper
Group: General Forum Members
Last Login: Monday, April 22, 2013 11:35 AM
Points: 10,
Visits: 273
Good article. I might have missed it but I'm guessing that ideally you would want to place the snapshot on a different drive?
JC
-----
James Cornell
Kainell Database Specialists
http://www.kainell.com
Post #507311
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
