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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-11-09 : 02:55:09
|
| Hi,Using SQL 2000.I'm facing recently two issues on these commands.1. backup log dbname1 with no_log checkpoint dbcc shrinkfile ('db_Log', 1500, TRUNCATEONLY )Error: Msg 3023, Level 16, State 3, Line 1Backup 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.Msg 3013, Level 16, State 1, Line 1BACKUP LOG is terminating abnormally.Could not locate file 'db_log' in sysfiles.Please help. |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-11-09 : 03:28:31
|
| My guess, there is another backup running at the same time. Is it possible to handle this in the stored procedure, Like, if process running, dont call these statment else run the backup. Also, how to verify that there is a process which is already running. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-09 : 10:42:59
|
| USE dbname1;GObackup log dbname1 with no_logcheckpointdbcc shrinkfile ('db_Log', 1500, TRUNCATEONLY )why are you doing this? should be taking log backups instead |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-11-09 : 11:23:50
|
| Use dbname1 will allow the dbcc shrinkfile successful but what abt the error # 3023.How to handle in case the backup is already running by other process. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-09 : 12:15:59
|
| you shouldn't be doing this. why are you? if a backup is running, let it run. you should be taking regular (scheduled) log backups if your db is not in simple recovery |
|
|
|
|
|
|
|
|
Backup Log error