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 123»»»

backup database Expand / Collapse
Author
Message
Posted Tuesday, September 21, 2010 10:29 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
Comments posted to this topic are about the item backup database
Post #990875
Posted Tuesday, September 21, 2010 10:30 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
Nice question thanks!
Post #990876
Posted Wednesday, September 22, 2010 12:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:39 AM
Points: 2,397, Visits: 2,287
Some operations have no sense inside a transaction. I surprise to see so many wrong answers.
Post #990899
Posted Wednesday, September 22, 2010 2:33 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:00 AM
Points: 1,659, Visits: 6,006
I guessed wrongly that because it makes no sense to do a backup within a transactiobn, then the transaction would be ignored and it would work.

I'm not sure what the question was supposed to teach us though - would anybody really try doing a backup inside a transaction?!
Post #990932
Posted Wednesday, September 22, 2010 3:07 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:39 AM
Points: 1,529, Visits: 5,185
Had to read through the BACKUP item in Books Online to be sure what would happen here, because it certainly makes no sense to put a backup inside a transaction and I had no idea what SQL would actually do if you tried!
Post #990947
Posted Wednesday, September 22, 2010 4:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 7:04 PM
Points: 176, Visits: 563
I thought this was on error then rollback. I remember you could test a backup without anything really happening, just a test to see if the wirings, pipes and screws are correct.
Post #991005
Posted Wednesday, September 22, 2010 4:46 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
Toreador (9/22/2010)
I guessed wrongly that because it makes no sense to do a backup within a transactiobn, then the transaction would be ignored and it would work.

I'm not sure what the question was supposed to teach us though - would anybody really try doing a backup inside a transaction?!


Woo hoo, I finally got one right.

Believe it or not, a simple Google search reveals people did try to run a backup within a transaction:

http://www.sqlnewsgroups.net/sqlserver/t10622-commit-rollback.aspx

What were they thinking?
Post #991011
Posted Wednesday, September 22, 2010 6:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 17, 2014 6:09 AM
Points: 2,370, Visits: 1,263
I learned something. I thought that the backup would be OK, but the there would be no history for the backup in msdb.

Good question.
Post #991077
Posted Wednesday, September 22, 2010 6:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
Toreador (9/22/2010)
I guessed wrongly that because it makes no sense to do a backup within a transactiobn, then the transaction would be ignored and it would work.


My logic as well. Tough question.
Post #991108
Posted Wednesday, September 22, 2010 7:05 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 1,888, Visits: 1,865
I think the proper way to "rollback" a backup is to do a restore.
Post #991115
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse