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: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Nice question thanks!
Post #990876
Posted Wednesday, September 22, 2010 12:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:33 AM
Points: 2,469, Visits: 2,346
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 @ 8:40 AM
Points: 1,715, Visits: 6,265
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: Friday, July 25, 2014 3:12 AM
Points: 1,610, Visits: 5,482
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: Friday, June 6, 2014 12:28 AM
Points: 176, Visits: 565
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: Today @ 5:33 AM
Points: 2,448, Visits: 1,320
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: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
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: Today @ 8:04 AM
Points: 2,012, Visits: 2,014
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