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 Wednesday, September 22, 2010 11:46 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 2:42 PM
Points: 33,278, Visits: 15,447
It doesn't make sense, but I can see people trying to do this and thinking they can somehow capture all changes with a backup and a verify, or a reindexing, or something.

I missed it, thinking that the transaction would be ignored.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #991417
Posted Wednesday, September 22, 2010 10:14 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
Great question!!!

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #991694
Posted Thursday, September 23, 2010 1:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 6:10 AM
Points: 350, Visits: 429
Nice question, I got it right :)

- SAMJI
If you marry one they will fight with you, If you marry 2 they will fight for you
Post #991774
Posted Friday, August 12, 2011 12:35 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:16 PM
Points: 2,548, Visits: 542
I thought that the backup would complete successfully, regardless of the transaction. It could have been a nice feature to be able to :
- start a transaction
- do some changes to the database that you want to test later without interfering other users
- take a backup (it shouldn't participate in the transaction)
- rollback the transaction to remove your changes (not the backup)
- restore the backup with a new name (or a virtual restore with Red gate Virtual Restore)
- do your testing in your copy of the database

But the uncommitted changes would't be in the backup anyway, so the feature wouldn't work anyway.


/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Post #1158984
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse