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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-07-11 : 13:38:23
|
| It's me again with backups problemsI just did a full backup, when i try running the front end which is access2000, i'm getting a message that " the log file is full, back up the trannsaction for the database to free up some space"I was getting that message before i ran the full back up, i thought once i did a full backup it would free up the tracsacion log.Now when i try backing up the transaction log i'm getting error23.Could you please help with this problem?thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-07-11 : 17:55:10
|
| Are you using transaction log backups? i.e. do you need to try to recover as much as possible - if not just rely on full and incremental backups and set the log to truncate, makes life a lot easier.You will need to backup or truncate the log. Now you will probably have to expand the log file a bit to allow it. Make sure nothing is holding a transaction (probably not an issue now).==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
mbevon
Starting Member
41 Posts |
Posted - 2002-07-12 : 08:48:17
|
| I think i'll use the full backup,how do i truncate the log file?thanksmarlon |
|
|
|
|
|
|
Backups