I'm trying to create a backup file of a database in SQL 2005. When I try to execute the backup operation I get an error saying "cannot access this file, it is in use by another process". Any advice on what I have to do to get this working?
Thanks!
Are you able to put the database in single-user mode? Try to back it up that way as a test.
Any chance you have another program running against that database, for example Visual Studio, or have log file open in notepad or something?
It turned out that this database wasn't being used anymore and I ended up reformatting.
BACKUP DATABASE [yourdatabase] TO DISK='C:\temporarybackup.bak' WITH COPY_ONLY
?