Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Better Backups Expand / Collapse
Author
Message
Posted Saturday, January 21, 2012 4:19 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:48 AM
Points: 33,089, Visits: 15,198
Comments posted to this topic are about the item Better Backups






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1239872
Posted Sunday, January 22, 2012 8:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:56 PM
Points: 2,270, Visits: 3,781
Steve, Looks like an incorrect option is chosen as the right one. Needs modification.

Question is very good though.


Mohammed Moinudheen
Post #1239926
Posted Sunday, January 22, 2012 9:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, February 1, 2012 3:57 AM
Points: 91, Visits: 125
Nice Stuff.
Post #1239927
Posted Sunday, January 22, 2012 9:50 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:13 PM
Points: 989, Visits: 1,821
Yep, the question says to limit I/O as answer when clearly (even in the explanation) you want to limit CPU. Should be A and D.
Post #1239929
Posted Sunday, January 22, 2012 1:47 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 9:26 PM
Points: 2,953, Visits: 436
The answer and the explanation contradicts each other (for the 2nd option, answer says C but explanation says D). I chose A & D, which are supposed to be the correct answers, but was told wrong.

Having said that, I never thought of using the Resource Governor to reduce the impact of backup to the production system, so good question, made me have to look up BOL.



Urbis, an urban transformation company
Post #1239960
Posted Sunday, January 22, 2012 3:40 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:15 PM
Points: 1,622, Visits: 292
Good question, but wrong answer. Should be "Enable backup compression" and "Create a user that is classified into a limited CPU workload group in Resource Governor"
Post #1239966
Posted Monday, January 23, 2012 12:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:40 PM
Points: 2,067, Visits: 520

wrong answer A & C !
When we enable compression we increase the cpu load and decrease the io load as we need less space for saving beckup. So we must use Resource Governor with limited cpu resource pool.

Right answer are A & D.


PS Give me back my point !


MCITP x 3
MCSE x 1
Post #1240008
Posted Monday, January 23, 2012 1:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:50 AM
Points: 2,466, Visits: 2,343
Another question "Please, my points back!"
Post #1240020
Posted Monday, January 23, 2012 1:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 9, 2013 11:12 PM
Points: 1,263, Visits: 1,081
Jostein Saethern (1/22/2012)
Good question, but wrong answer. Should be "Enable backup compression" and "Create a user that is classified into a limited CPU workload group in Resource Governor"

+1

Thanks,
-Michael
Post #1240023
Posted Monday, January 23, 2012 1:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:22 AM
Points: 1,298, Visits: 471
I have not as mutch points to just loose one!
Post #1240025
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse