Recover eSign Dropdown with airSlate SignNow

Recover esign dropdown

hey there is this thing on i think it's hungry better be on otherwise i'm just talking to myself for no good reason welcome my name is eric i work for rentals our unlimited and today we're going to talk about how to restore transaction logs using the standby syntax and how that can help you in emergencies you need to recover some data figure out which log file has the data that you need to restore now it's a dba must to understand and know how to use this syntax and be able to well i don't know the moment do it off the top of your head remembering syntax is hard hard work uh scripting things out a few times does help you remember that uh we're gonna look at a pretty simple example of how it works and how it can help you in an emergency there are more advanced uses using syntax with stop ads stop that mark and start stop before mark which can take either a date time or an lsn or a transaction name and you can use that to uh stop at a particular point within a transaction log that is covered in our senior dba class since you're watching this video you maybe you know it's not there yet maybe you just need to get some junior mid-level dba advice on how to restore a transaction log this is a very popular thing to do with blog shipping because you can offload queries to a log server and you can restore logs with a standby and you can allow people to report and run queries on that server because the database will be readable uh just keep in mind that you know when you when you restore logs like that when you even if you stand by when you start restoring the logs people will get kicked out of that that database they won't be able to run their queries their queries will get cancelled the logarithmic stores will start piling up and when you do that when you use standby and you let people offload reports to log chip servers you have to pay for you have to license that server as a completely completely licensed sql server you use no software assurance that allows you to have that with software assurance you do get the one uh standby server has standby server we do not get a readable server that's true for availability groups that's true for if you use mirroring and you use snapshot backups to allow people to take to run point in time queries off a snapshot backup of a mirrored database or if you use replication as long as people are reading that data you must pay for it so let's hop on to our example let's want to do it do a demo downloads are great so we're going to do some stuff here we got to use master all right it's a good...