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.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Differential backup Fail

Author  Topic  rupesh81 Starting Member 1 Post Posted - 2008-09-30 : 05:48:37 Hi, We have SQL Server 2000 on Window 2000 OS. Jobs running are: 1.Full backup of database.(1:10 AM) 2.Transaction logs after every one hr. 3.Differential backup of database (12:45 PM). 4.Weekly once (monday) optimization of objects and intergity of users (6:10 AM) So when the optimizations job gets finished then:(i.e on monday) 1.At 6:56 transaction log size is 16 GB which should be something 32 KB or 16 KB. 2.Differential backup get run but the size of differential backup is full size of database. My issues is differential backup gets something problem and transactions log DBA Support