Hi,
I've having trouble getting this clear in my head after pouring over Books Online for the past 30 mins.
Basically, I've got a SQL Server which gets a full backup each weeknight, but the transaction logs aren't clearing.
I'm using the default subclient which is autodetecting the various databases on my server. I've restored data from time to time and generally think thinks are OK, other than these transaction logs which have now run me out of space.
ERROR CODE [30:325]: Error encountered during backup. Error: [ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'dbFranchise' is full. Back up the transaction log for the database to free up some log space.
In my mind, doing a FULL should clear the logs, just like it does on my Ezchange servers.
Can someone explain it to me and tell me the best fix?
I've having trouble getting this clear in my head after pouring over Books Online for the past 30 mins.
Basically, I've got a SQL Server which gets a full backup each weeknight, but the transaction logs aren't clearing.
I'm using the default subclient which is autodetecting the various databases on my server. I've restored data from time to time and generally think thinks are OK, other than these transaction logs which have now run me out of space.
ERROR CODE [30:325]: Error encountered during backup. Error: [ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'dbFranchise' is full. Back up the transaction log for the database to free up some log space.
In my mind, doing a FULL should clear the logs, just like it does on my Ezchange servers.
Can someone explain it to me and tell me the best fix?