DBA
-
Try General DataBase Forum..!
MyFirstArticlePublished: MenuControlSelectedItem Why Do Some People Forget To Mark as Answer .If It Helps.
-
don't ask such question? if u don't know anything just put your question(code if needed) and leave it to other? by the way let me know your question.
Regards Keyur Satyadev
-
Are you still havign trouble with your transaction log ? I understand you want a permanent fix to your transaction log file growing, but there is no "fix" to your problem. This is normal operation of a database, each time a record is inserted/updated/deleted, there is a before and after image of the record written to the transaction log so that you can either rollback the transaction or apply re-do logs after a database crash. You can't prevent transaction logs from growing, you just need to know how to manage them. For example, the most basic management of SQL db could be implemented as follows: 1) Set the recovery model to "simple" 2) Each night, perform a full backup of the database. 3) Truncate the transaction log file Also, you may want to review the following TechNet article ... How to stop the transaction log of a SQL Server database from growing unexpectedly http://support.microsoft.com/kb/873235[^]
-
AndyInUK wrote:
Any DBA here ??
Is this your question ? Please read forum guideline before asking any questions !
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET
-
Are you still havign trouble with your transaction log ? I understand you want a permanent fix to your transaction log file growing, but there is no "fix" to your problem. This is normal operation of a database, each time a record is inserted/updated/deleted, there is a before and after image of the record written to the transaction log so that you can either rollback the transaction or apply re-do logs after a database crash. You can't prevent transaction logs from growing, you just need to know how to manage them. For example, the most basic management of SQL db could be implemented as follows: 1) Set the recovery model to "simple" 2) Each night, perform a full backup of the database. 3) Truncate the transaction log file Also, you may want to review the following TechNet article ... How to stop the transaction log of a SQL Server database from growing unexpectedly http://support.microsoft.com/kb/873235[^]
Thanks for your reply and a good article,
David Mujica wrote:
You can't prevent transaction logs from growing
But if it increasing by certain amount then it's fine but it increased to 200 GB or more in few weeks time bringing it to 450GB or so which is just bizzar. We are using recovery model to full - could this be an issue ??
-
don't ask such question? if u don't know anything just put your question(code if needed) and leave it to other? by the way let me know your question.
Regards Keyur Satyadev
-
jj
-
jj
-
jj
chandni patel wrote:
jj
What does it mean ?
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET
-
Andy, You should give the reference of your message while post the fast one. Other wise it is very difficult to understand ;)
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Visit My Latest Article : Beginner's Guide : Exploring IIS 6.0 With ASP.NET