Cannot change db to full recovery

[Luvsql]

I need to backup our log (too big) but cannot change recovery to full. I receive the following error "Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized."

I need to shrink the log as it is taking up to much space, but can't back it up either.

 

[mrdenny]

Sounds like someone else is running an ALTER DATABASE command. If lots of extents are happening those are ALTER DATABASE commands and you will need to stop what ever is causing the database to grow.

Why do you trying to switch the database to FULL recovery? What recovery mode is the database in?

If the database is in simple recovery and the log is growing that's because someone is running a large command which is using a lot of log space. Once the command is done the log will truncate and you can shrink it with the DBCC SHRINKFILE command.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com