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
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
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?
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
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.
How can you find out what transaction log backup files have been restored using SQL in SQL Ser开发者_运维百科ver 2005?Try;
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
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:
I am trying to shrink my database log file. I have tried to run: USE databasename BACKUP log databasename
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
加载中,请稍侯......