There is already a backup job plan that runs every 15 minutes. I created transaction log shipping process but afte开发者_JS百科r 1 or two restored logs this job stops working (error: it can\'t find ma
I\'ve read up on SQL Server transaction logs, but still not entirely comfortable with how to use/manage them. I get that they are important for things like transaction rollbacks, mirroring, replicatio
I\'ve got a database running on a clients SQL Server 2000 box where the transaction log file is only 1MB in size. This seems very perculiar.
Is there a way to see w开发者_运维问答hat is writing to the transaction log? I have a log file that has grown 15 Gigs in the last 20 minutes.Is there a way for me to track down what is causing this?A
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
Need to roll back a delete query, so I\'m sifting through the transaction logs without really knowing what the meanings of most of the headers are.
I have a client with a very large database on Sq开发者_如何转开发l Server 2005. The total space allocated to the db is 15Gb with roughly 5Gb to the db and 10 Gb to the transaction log. Just recently a
It\'s a test environment, I needed some data to test an Update query, but accidentally updated a column in all 开发者_开发技巧rows to have wrong data. Must I use a backup to restore the data back to t
I\'m helping with a rather ad-hoc disaster recovery, and we\'ve restored a database backup from a few weeks ago and then restored t开发者_开发问答ransactions from a transaction log backup.
I have an SQL Server 2005 instance whose full backup (.BAK) failed due to low disk space.However half hourly transaction log backups continue (.TRN).Assuming I have an older full backup, could these c