September 29, 2015 at 1:25 am
Hi all!
I am programming using a pretty big SQL DB.
Every time i want to check my programming, I have to restore the DB to come back to the 'Before' situation.
Only pretty few records are changed, but i have to restore +1 GB every time, which is quite time consuming.
Its a test enviroment, so I can do pretty muvh what i want here.
Can I replace changed part only? When i looked in old replies, I found, that it at that time was not possible to restore just one table from a backup.
MSSQL 2012, but the 2012 forum section has no 'Newbies' section.
Best regards
Edvard Korsbæk
September 29, 2015 at 1:28 am
September 29, 2015 at 3:28 am
If you're using Enterprise or Developer edition, you can create a database snapshot before you run your tests and revert to the snapshot afterwards. It's not a backup, snapshots are a point-in-time view of the database as of the time they were created, they allow the entire database to be reverted to the point that the snapshot was created, or you can manually select from the snapshot to undo changes made to the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2015 at 3:40 am
Thanks both!
snapshots seems to be the answer to my question.
Seems like the examples in the first answers makes it possible to use my express edition, where solution two needs a more pro version.
Edvard Korsbæk
September 29, 2015 at 3:46 am
Edvard Korsbæk (9/29/2015)
Thanks both!snapshots seems to be the answer to my question.
Seems like the examples in the first answers makes it possible to use my express edition, where solution two needs a more pro version.
Edvard Korsbæk
Nope - "Database snapshots are available only in Microsoft SQL Server 2005 Enterprise Edition and later versions." This does mean it is within the Developer Edition, but the constraints of use for that version might not make it viable for yourself, depending upon your circumstance.
September 29, 2015 at 4:27 am
If you're really spending time and effort learning SQL Server and you intend on making this a profession, the $50 to purchase the Developer Edition is worth every penny.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply