transaction-log
Transaction log shipping together with backup job = conflict?
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[详细]
2023-03-25 05:12 分类:问答Don't quite understand SQL Server transaction logs
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[详细]
2023-03-04 20:00 分类:问答Is there are a way to check the last time a shrink operation was done on a SQL Server 2000 transaction log
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.[详细]
2023-02-17 21:38 分类:问答Finding what is writing to the Transaction Log in SQL Server?
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[详细]
2023-02-12 13:51 分类:问答How to view transaction logs in SQL Server 2008 [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]
2023-02-01 05:44 分类:问答SQL Server 2008 Transaction Log: Date/Time
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.[详细]
2023-01-31 23:32 分类:问答Can a large transaction log cause cpu hikes to occur
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[详细]
2023-01-31 18:50 分类:问答How do I undo an update statement I made to a database
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[详细]
2023-01-26 04:00 分类:问答Log Chains and SQL Server Transaction Log - sanity check
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.[详细]
2023-01-24 14:41 分类:问答SQL Server 2005 failed backup effect on transaction logs
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[详细]
2023-01-14 22:01 分类:问答