I have a long running redgate script that is applying a bunch of schema type changes to a database. It is going to take 3 hours to run. This script will be run on a production database that has mirroring and transaction log shipping in place. My specific question is how is transaction log shipping going to be affected by a huge redgat...
How to find out the current transaction log size? Is it possible to do e.g. by querying some system tables with SQL? It would also be interesting to find out the maximum size for the transaction log. Is the only option to look it up from the file system? ...
Hey I wrote a test java application that uses sqlitejdbc. I was wondering if there was a way to obtain a transaction log that displays the way that the application communicated with the database while it ran. heres what I have written: Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db...
I would like to query for all databases (in SQL Server 2008 instance) date when the last transaction log backup has been taken. How to do that? I know that this information is somewhere, but I don't know where. ...