Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, December 11, 2014 5:11 AM
Points: 654, Visits: 267
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: Tuesday, June 30, 2015 9:47 AM
Points: 2,160, Visits: 2,204
Nice question thanks!
Post #990876
Posted Wednesday, September 22, 2010 12:58 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:17 AM
Points: 3,204, Visits: 3,051
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:20 AM
Points: 2,196, Visits: 7,904
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: Tuesday, June 21, 2016 2:43 AM
Points: 1,805, Visits: 6,103
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: Monday, August 18, 2014 4:04 AM
Points: 176, Visits: 567
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: Saturday, March 5, 2016 7:55 PM
Points: 1,354, Visits: 1,300
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
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, June 14, 2016 8:49 AM
Points: 3,004, Visits: 1,629
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: Friday, June 17, 2016 12:26 PM
Points: 2,831, Visits: 2,624
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, June 24, 2016 6:39 AM
Points: 2,753, Visits: 2,575
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