![]() ![]() I can write some basic SQL to list all my snapshots. Ouch… It looks really big □ But lets look at the actual disk usage We delete the table by accident.īecause snapshot files tend to get big I am really curious about the size of it. Insert into mySuperImportantTable values (5, 'Secret 5')ĬREATE DATABASE AdventureWorksDW2012_Mysnapshot ONįILENAME = 'C:\db snapshotfile\AdventureWorksDW2012_Mysnapshot.ss' ) Insert into mySuperImportantTable values (4, 'Secret 4') Insert into mySuperImportantTable values (3, 'Secret 3') Insert into mySuperImportantTable values (2, 'Secret 2') Insert into mySuperImportantTable values (1, 'Secret 1') Lets start by creating a snapshot of the AdventureWorksDW2012 database and create a “super important” table.Ĭreate table mySuperImportantTable ( int, varchar(2000)) For example if you are doing a scary update or something you have the possibility to “roll back” these changes.ĭid you know that you could make snapshots even in SQL Server? The snapshot feature is most useful when you want to preserve the state of the database so you can return to the same state repeatedly. ![]() In these products you have a really useful feature called “snapshot”. I am working quite a lot with virtual machines in Hyper-V and VMWare. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |