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 ««12

Compressed Backups Expand / Collapse
Author
Message
Posted Friday, June 13, 2014 7:36 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:13 AM
Points: 4,156, Visits: 5,549
Almost missed the critical phrase "in a backup set"
Good question, Steve, thanks


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1580516
Posted Friday, June 13, 2014 7:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:43 PM
Points: 1,053, Visits: 2,354
TomThomson (6/13/2014)
Koen Verbeeck (6/13/2014)
An easy question on Friday the 13th, who knew

If it's easy, there must be a lot of not very bright and knowledgable people using SQL Server central. 61 out of 152 got it wrong so far. If people who just guess are split evenly between those who say "of course it works, why on earth wouldn't it" and those who say "there must be some reason for asking this, so probably it doesn't work" and there are at most 20% who think they know but are wrong (which surely would be true for an "easy" question) that means that 31 of the people who got it right were guessing, so only 60 out of 152 knew or successully looked up the answer, which is a pretty low proportion (less than 40%) for an"easy" question.

Anyway, it's a good question because at least the 40% with wrong answers may learn from it, and maybe some of the people who got the right answer by guessing will in future actually know the answer.


+1

well, more than one way to learn.... either way or anyhow or somehow or whatever...it is helping all the people around the world to gain the knowledge.


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1580518
Posted Friday, June 13, 2014 11:04 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:02 AM
Points: 18,060, Visits: 16,089
TomThomson (6/13/2014)
Koen Verbeeck (6/13/2014)
An easy question on Friday the 13th, who knew

If it's easy, there must be a lot of not very bright and knowledgable people using SQL Server central. 61 out of 152 got it wrong so far. If people who just guess are split evenly between those who say "of course it works, why on earth wouldn't it" and those who say "there must be some reason for asking this, so probably it doesn't work" and there are at most 20% who think they know but are wrong (which surely would be true for an "easy" question) that means that 31 of the people who got it right were guessing, so only 60 out of 152 knew or successully looked up the answer, which is a pretty low proportion (less than 40%) for an"easy" question.

Anyway, it's a good question because at least the 40% with wrong answers may learn from it, and maybe some of the people who got the right answer by guessing will in future actually know the answer.


Well it was qualified as being easy for "Friday the 13th."

It could have been a really bloody and difficult question ;)




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1580652
Posted Saturday, June 14, 2014 5:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:46 AM
Points: 1,429, Visits: 685
TomThomson (6/13/2014)
Koen Verbeeck (6/13/2014)
An easy question on Friday the 13th, who knew

Anyway, it's a good question because at least the 40% with wrong answers may learn from it, and maybe some of the people who got the right answer by guessing will in future actually know the answer.

Now it`s 37%
Post #1580821
Posted Saturday, June 14, 2014 5:53 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:46 AM
Points: 1,429, Visits: 685
Raghavendra Mudugal (6/13/2014)
Thank you for the post, SJ, good one, got it right, as I tried this before and was sure of the choice.

Same here
Post #1580828
Posted Saturday, June 14, 2014 6:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:46 AM
Points: 1,429, Visits: 685
Stewart "Arturius" Campbell (6/13/2014)
Almost missed the critical phrase "in a backup set"
Good question, Steve, thanks

+ 1
Post #1580830
Posted Monday, June 16, 2014 6:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 4:31 AM
Points: 278, Visits: 242
nice question... i am aware of this kind of restore and backup...

Manik
You cannot get to the top by sitting on your bottom.
Post #1581092
Posted Tuesday, June 17, 2014 4:57 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: 2 days ago @ 5:24 AM
Points: 828, Visits: 1,439
Hi,

I have tried taking the backup with the following t-sql commands

case I

-----------------------------------------------------
backup database XTEST_DB to disk
='c:\XTEST_DB.bak' with compression

backup database XTEST_DB to disk
='c:\XTEST_DB.bak'

-----------------------------------------------------

Both the backups are successful. first backup is with compression and next one is normal backup, both existed in the same media set.

but when I use like the below ,

case II (like the QOTD order)

-----------------------------------------------------

backup database XTEST_DB to disk
='c:\XTEST_DB.bak'

backup database XTEST_DB to disk
='c:\XTEST_DB.bak' with compression

-----------------------------------------------------

Then I am getting the error that both cannot co-exist

My question is , if both cannot co-exist, first case also should fail , why the first case is successful and where as the second one is not ?
Post #1582225
Posted Tuesday, June 17, 2014 6:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
pmadhavapeddi22 (6/17/2014)
Hi,

I have tried taking the backup with the following t-sql commands

case I

-----------------------------------------------------
backup database XTEST_DB to disk
='c:\XTEST_DB.bak' with compression

backup database XTEST_DB to disk
='c:\XTEST_DB.bak'

-----------------------------------------------------

Both the backups are successful. first backup is with compression and next one is normal backup, both existed in the same media set.

but when I use like the below ,

case II (like the QOTD order)

-----------------------------------------------------

backup database XTEST_DB to disk
='c:\XTEST_DB.bak'

backup database XTEST_DB to disk
='c:\XTEST_DB.bak' with compression

-----------------------------------------------------

Then I am getting the error that both cannot co-exist

My question is , if both cannot co-exist, second case also should fail , why the first case is successful and where as the second one is not ?



Nice catch pmadhavapeddi22,

Looks like it's SQL generosity.


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1582277
Posted Friday, September 5, 2014 9:03 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:27 AM
Points: 1,028, Visits: 1,555
easy & straight forward.

Thanks.
Post #1611061
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse