backup database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » backup database

24 posts, Page 3 of 3

«««1 2 3

backup database

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Wednesday, September 22, 2010 11:46 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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

Raunak Jhawar

Posted Wednesday, September 22, 2010 10:14 PM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

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

COOL_ICE

Posted Thursday, September 23, 2010 1:29 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 20, 2013 4:17 AM
Points: 350, Visits: 425

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 Smile

Post #991774

hakan.winther

Posted Friday, August 12, 2011 12:35 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 06, 2013 5:31 AM
Points: 2,226, Visits: 438

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

Post #1158984

« Prev Topic | Next Topic »

24 posts, Page 3 of 3

«««1 2 3

Permissions