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 |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-04-11 : 08:55:42
|
| Hi,I try to used this command to free some space BACKUP LOG HTPN WITH NO_LOG but then I got the error:Server: Msg 3023, Level 16, State 3, Line 3Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.Server: Msg 3013, Level 16, State 1, Line 3BACKUP LOG is terminating abnormally.What that mean? and what should I do now to free up the space because the transaction log full thanks |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-11 : 09:32:31
|
| Most likely you already have another backup operation already in progress. You must wait until it runs to completetion (or kill it) before you can backup your log.---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
 |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-04-11 : 10:38:32
|
| You should consider truncating the transaction log on every backup. That way the backed log records are removed from tlog and you free up space. |
|
|
|
|
|
|
transaction log