transaction-log

相关标签：javascript jquery android 多少钱 iPhone

SQL Server 2008 log file size is large and growing quickly

Most of the time users will hit the database to read news. There are very few number of queries executed under transactions. 95% of the database hits wo开发者_StackOverflowuld be for read-only purpose[详细]

2023-01-07 11:34 分类：问答
Log SQL queries in production?

I\'m having a dilemma on whether or not to log SQL queries in production as well. I don\'t know how slow writing files is in PHP. Probably some benchmarks could give some answers, but I wanted to see[详细]

2023-01-02 13:36 分类：问答
SQL Server - What's in that log backup?

So I noticed that one of my log backups is about 1开发者_开发百科000x larger than normal.I\'d like to see what is in there.Is there something I can use to read it?[详细]

2022-12-31 23:02 分类：问答
Sql Server: chunking deletes still fills up transaction log; on fail all deletes are rolled back - why?

Here is my scenario: we have a database, let\'s call it Logging, with a table that holds records from Log4Net (via MSMQ). The db\'s recovery mode is set to Simple: we don\'t care about the transaction[详细]

2022-12-28 13:47 分类：问答
DB2 Transaction log is full. How to flush / clear it?

I’m working on a experiment regarding to a course I’m taking about tuning DB2. I’m using the EC2 from Amazon (aws) to conduct the experim开发者_开发技巧ent.[详细]

2022-12-26 17:21 分类：问答
SQL Server 2005 - How to find out what transaction log files have been restored

How can you find out what transaction log backup files have been restored using SQL in SQL Ser开发者_运维百科ver 2005?Try;[详细]

2022-12-24 23:16 分类：问答
Recovering transaction log from corrupt SQL Server database

We have a database that is backed up weekly in simple mode.Yesterday, we had a crc error corrupt the mdf file and we were unable to save it.I restored the backup from last week, but now we have a gap[详细]

2022-12-24 10:38 分类：问答
DBCC shrinkfile gives error

I am trying to shrink my log file using DBCC SHRINKFILE(db_2.ldf), which is the name for log file It 开发者_如何学Pythongives me error every time:[详细]

2022-12-22 15:10 分类：问答
SQL - shrink database log file

I am trying to shrink my database log file. I have tried to run: USE databasename BACKUP log databasename[详细]

2022-12-19 06:28 分类：问答
SQL Server 2005 transaction log is always too big

I\'ve read other posts and have done hours of research but am still none the wiser. I have a database that is 65 gig in the data file, and currently 230 gig in the log file. I\'m trying to redesign th[详细]

2022-12-19 04:46 分类：问答