Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dutch_OnE
Starting Member
1 Post |
 Posted - 2009-03-25 : 04:12:22
|
| hello,i have ms sql server 2005 with newest service pack.the problem is my backup strategy and the transaction log file.My backup plan:complete backup every day (but the ldf file is always full and the database stopped;properties from database said that database is backup, but not database transaction protocol) i dont understand this, because i make a full backup !!!Now i make a second backup task with only transaction protocol.after doing this manual, the database transaction protocol said that protocol backup is well done.Did anyone has a better ideas ? |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-25 : 07:48:47
|
| Have you set the log file to autogrow? What is size of logfile? |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-03-25 : 08:04:33
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=116898 |
|
|
|
|
|
|
Problems with a large ldf Transaction File