VMware Fusion Help Howto Videos Understanding VMware Fusion Virtual Machines and What VMware Fusion Can Do What Is a Virtual MachineCanadian and USA supplier of DinoLite Handheld Digital Microscopes. Say cheese on taking snapshots with SAP HANAAs projects with HANA just like with any other technology move on, at some point in time the requirement to perform tests and trainings comes up. If this is not the case in your project, please go and talk to your project responsible right away Stil here Ok, so youre actually want to perform some testing One important thing when performing tests is that you repeat them in the same environment and maybe alter one thing at a time. So, how do you achieve this with a database You restore a backup taken earlier, rightYeah, right Thats one way to do it. A disadvantage of this approach is that it takes a lot of time as the whole database backup needs to be read from the backup medium and be written to the database storage. Another way to deal with this requirement is to take snapshots of the database and set it back to a snapshot once required. If youve worked with a virtual machine e. VMWare, Virtual. Box or Parallels you know how snapshots work the system is frozen for a moment, a snapshot is taken and afterwards you can continue to work with the system. From that moment on you always have the option to flash back to the system state when you took the snapshot. SAP HANA is offering a pretty similar functionality. Those of you that know SAP Max. DB snapshots will clearly recognize the concepts. The HANA implementation is quite close to the Max. Manually Delete Snapshots Parallels MacWith the launch of the Xbox One X only a few months away Microsoft needs an interim win to keep people interested in the console that is currently in a very distant. While Mac OS X works well for most tasks, there are times when it just cant do what you want it to. More often than not this means running Windows on your Mac. Weeks after the US Army told personnel to immediately shelve all drones made by Chinese manufacturer DJI, citing unspecified cyber vulnerabilities associated with. A communitybuilt site of hints and tips on using Apples new Mac OS X operating system. You probably think you know how to keep your internet habits secret. Clearing browser history is too obvious, you say. I just do all my sketchy stuff in an. Tree 3D Model For Maya. This question is part of the Ask Lifehacker advice column, where Lifehacker staff answers readers burning questions with practical tips. After all, some of the. Hi Lars, Id like to make an addition, because it wasnt really clear to me after reading your blog Snapshots disappear with EVERY system restart, not only if. DB feature. SNAPSHOTS in HANASo, I can take snapshots of my HANA instance Great, show me the button for that in HANA studio Unfortunately there is no frontend UI support for HANA snapshots yet no idea whether this is on the backlog for development. Therefore, this little walktrough involves a bit of typing and readingBut, wait a minute where is all the old data stored then Ok, lets answer this obvious question first. Manually Delete Snapshots Parallels DefinitionSimilar to many filesystems and in fact very similar to Max. DB HANAs persistency employs the shadow paging concept http en. Shadowpaging. That means that whenever a changed data page is written from memory to the disks this is called a savepoint in HANA the changed page is stored at a different physical position. The old page is not immediately overwritten. Instead the old version of the page remains in the storage until one of the subsequent savepoints overwrites it with newly changed data. To keep track of which pages are current and which ones can be overwritten, HANA uses a mapping structure called the converter hello Max. DB again. Having these two concepts savepointconverter in place, a snapshot is now easy to create. All youve to do is to keep a specific state of the Converter and keep all pages referenced by this converter version from being overwritten. And thats exactly what happens within HANA when you take a snapshot. Since savepoints can be recovered transactionally consistent by their design, HANA can simply switch back to a saved Converter version and resume working from there. By knowing this, the answer to the question is easy to give the data is still in the data area and wont be overwritten. Obviously, if you do change a lot of the data that is part of the snapshot, the data area usage will grow quite a bit, even if youre only doing UPDATEs or DELETEs funny effect, isnt it Well, then lets see what the snapshot is like with HANA. And off we go my annotated HANA snapshot walkthrough The commands I use I found in our documentation   System Administration and Maintenance Information    SAP HANA Administration Guide    1. SQL Syntax for Backup and Recovery. SQL Statements for Data Snapshot1. Syntax    lt executecreatesnapshot BACKUP DATA CREATE SNAPSHOT  lt executedropsnapshot BACKUP DATA DROP SNAPSHOTJust there I also found this interesting remark that I will check out later in more detail   Examples of SQL Statements for Data Snapshot    BACKUP DATA CREATE SNAPSHOT    Create a database wide snapshot based on a transactional consistent savepoint similar to the data backup. If a snapshot exists, no complete data backup is possible. Every request of this kind is rejected with a notification that a data backup is still in process. BACKUP DATA DROP SNAPSHOT    Drop a database wide snapshot. E6%90%9C%E7%8B%97%E6%88%AA%E5%9B%BE_2013-04-28_16-29-48.png' alt='Manually Delete Snapshots Parallels Software' title='Manually Delete Snapshots Parallels Software' />From this point in time on, complete data backups are possible. To start I setup a test table and fill it with some data. I also make sure that the table is not fully merged, since I want to know whether the snapshot works with the change log of column tables as well    no commits here as AUTOCOMMIT ON. LARS. merge delta of lars. NORA. lets check what weve got. I cut away the columns that Im not interested in for readabilty. SNAPPY. SCHEMANAME TABLENAME  RECORDCOUNT    RAWRECORDCOUNTINMAIN    RAWRECORDCOUNTINDELTA. LARS        SNAPPY      2               1                           1. Now, I take a snapshot of this database. Statement backup data create snapshot successfully executed in 3. Started 2. 01. 2 1. Rows Affected 0. That was easy. Noteworthy is that the time to take a snapshot is notrelated to the size of the database. Instead its bound to how many changed pages have to be written out for the savepoint that is triggered. Remember A HANA snapshot is a frozen savepoint. Well, while were at it, we could also just check on this, shall we    select from msavepoints. HOST             PORT           VOLUMEID          STARTTIME                       STATE          VERSION          REQUESTEDFREQUENCY          TIMESINCEPREVIOUS          DURATION          CRITICALPHASEDURATION          TOTALSIZE          FLUSHEDPAGES          FLUSHEDPAGESINCRITICALPHASE          FLUSHEDROWSTOREPAGES          FLUSHEDROWSTOREPAGESINCRITICALPHASE          FLUSHEDSIZE          FLUSHEDSIZEINCRITICALPHASE          FLUSHEDROWSTORESIZE          FLUSHEDROWSTORESIZEINCRITICALPHASE          RTTSIZE. DONE           8. DONE           8. RTT   rollback transaction table see RTTSIZE column description for msavepoints viewThe first line shows our snapshot savepoint. Dont ask me about the mismatch of DURATION 5. Another system view to check out is wait for it msnapshots    select from msnapshots. HOST             PORT           VOLUMEID          ID             TIMESTAMP                        FORBACKUP          ANCHOR. TRUE                1. TRUE                1. TRUE                1. The avid reader will have noticed, that we took ONE snapshot and now we see THREE entried in our system view. Upton closer look we find that these snapshots belong to different volumes of different services notice the PORT cokumn. This is already a hint to how snapshots are handled in our distributed system distributed over separate services with separate persistencies eventually distributed over several nodes. Being the old support guy I am, I also peek into the current indexserver trace file and find one line   . Logger       Savepoint. Impl. cpp0. 20. 77 Snapshot 8. RTT size0. P0. O0. D. Noticable here is apart from the savepoint number 8. If no snapshot would be present we would find snapsp0 there. Finally, the backup. T2. 1 4. 3 5. 80. P0. 75. 89      1. INFO    BACKUP   SNAPSHOT started. T2. 1 4. 3 5. 80. P0. 75. 89      1. INFO    BACKUP   state of service nameserver, vml. Backup. Prepare. Savepoint. In. Progress. 2. 01. T2. 1 4. 3 5. 80. P0. 75. 89      1. INFO    BACKUP   state of service statisticsserver, vml. How to Keep Your Podcasts Synced Between Devices. This question is part of the Ask Lifehacker advice column, where Lifehacker staff answers readers burning questions with practical tips. After all, some of the best hacks are borne from the most annoying problems. Dear Lifehacker As a user of both Android and i. OS, is there a way to have my podcast feed synced between both i. OS and Android and be able to just start listening where I left off on either device I think Stitcher might be the only option for this, but having Amazon Echo as well, it would be nice to ask my Echo to play where I left off as well. Thanks for the great work and any help you can provide Darrell. Dear Darrell Hi, Darrell As an avid podcast listener and owner of both i. OS and Android devices, I feel your pain. Starting your favorite podcast on one device and finishing it up on another shouldnt feel like rocket science. And while Ive got a Google Home, I also use my voice assistant to play the latest episodes of my favorite shows. Heres how you can, too. Try Pocket Casts for Cross Platform Syncing. Some podcast apps allow you to listen on either i. OS or Android, as well as the web. Luckily, you can easily sync your podcasts between the two mobile operating systems if you use the right app. There arent many options to choose from, but youve already named one. Stitcher is indeed useful for multi platform listening, and syncs your podcasts and listening position across devices. Podcasts have become one of the best forms of entertainment around, but its tough keeping track of Read more Read. That being said, I find podcast app Pocket Casts more user friendly and reliable than Stitcher. The cross platform app can sync your podcasts between your i. OS and Android devices, supports controls via Android Wear and Apple Watch wearables, and even offers a web friendly experience after a one time 9 fee. Whats more, you can schedule your podcast updates to happen either over Wi. Fi or overnight, adjust playback speed, and build your own playlists either manually or using filters. Unfortunately, while it supports playback via Google Home, theres no support for Amazon Echo yet. Podcast Listening via Voice Assistants. Now, about your listening to podcasts through your Amazon Echo. Its pretty easy to get your Echo to start playing the latest episode of your favorite showperfect for news podcastsbut a bit more complicated to listen to a shows back catalog. Echo gets its podcast list from Tune. In, which features over 5 million podcasts in its repertoire. You can use the Alexa app to control Tune. In podcasts on your phone, but the interface is terribly organized and features obscure categories mixed in with more traditional podcast genres. Its not exactly a joy to use, but you can search for podcasts by name and pick the episode from there. Want to listen to your favorite fictional community radio podcast Just say Alexa, play Welcome to Night Vale podcast to play it on your Echo. If you need to go back you can ask it to play the previous episode, but you can only advance or rewind one episode at a time. It wont remember your place or sync with your other devices, however, so if you decide to revisit your podcast listening at a later date youll be back to where you started. Bluetooth Is Always an Option Unless its NotNow you can ask Alexa to set the mood for you. Read more Read. Of course, you might want to listen to an episode released a few weeks back. If you want more control you can use your own podcast app, in this case Stitcher or Pocket Casts. How do you get it to play on your Echo Simple pair your phone and Echo via Bluetooth. Tell your Echo to pair Bluetooth to have it connect to your smartphone. From there you can treat your Echo like a normal speaker. You wont be able to control playback with your voice, but at least your podcasts are booming through your living room. While Google Home doesnt support Bluetooth playback yet, you can also play your podcasts by asking your virtual assistant. If you ask it for the latest episode of Lifehackers The Upgrade, itll start right up. You can also play podcasts using supported podcast apps like Pocket Casts. Just say Hey Google, play Kotaku Splitscreen from Pocket Casts to enjoy some riveting conversation about Final Fantasy XII I assume youre a fan of Final Fantasy XII. Yeah, theres much to be done when it comes to syncing podcasts on every audio friendly device, but right now a combination of the right voice assistant plus the right podcast app should solve your podcast syncing woes. Want to ask Lifehacker a question Its pretty simpleEmail patrick. Ask Lifehacker along with your question. Broad questions are best For example, while we probably wont answer pointed ones about how to fix your Black. Berry Bolds headphone jack, we can help you find a new phone, figure out which headphones fit your lifestyle, or decide if you actually need a physical keyboard instead of a touchscreen.