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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-21 : 10:21:09
|
| Yuliya writes "Recently I have upgraded SQL 7.0 to 2000. I've created the new maintenance plan. And now here is the error i'm getting on every transaction log backup:"Database log truncated: Database:MyDatabse"And that happened with 3 databases on the server. The recovery mode is "Full". Also i've checked DATABASEPROPERTY('MyDatabse','IsTruncLog') = 0. What am i doing wrong here? What else should i check?Thanks in advance." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-21 : 12:37:44
|
| What compatibility mode is your database set to? After upgrading to 2000, you have to change your compatibility mode to 80 in order for it to be truly a 2000 database.Anyway, are there any errors in the SQL Server Error Log? What happens if you run the transaction log backup using BACKUP LOG in Query Analyzer?Tara |
 |
|
|
portnova
Starting Member
1 Post |
Posted - 2004-04-26 : 09:18:13
|
The compatibility mode is 80. The SQL Server Error log has following line:2004-04-25 21:00:02.89 backup Database log truncated: Database: iMISProd.I did not get any error when i run BACKUP LOG from Query Analyzer.Where is a problem
What compatibility mode is your database set to? After upgrading to 2000, you have to change your compatibility mode to 80 in order for it to be truly a 2000 database.Anyway, are there any errors in the SQL Server Error Log? What happens if you run the transaction log backup using BACKUP LOG in Query Analyzer?Tara[/quote] |
|
|
|
|
|
|
Database log truncated: Database:MyDatabase