asked
problem with backup
hi, i am taking the backup of a database with file name msd_tsp-wer-rty-123 then i am getting the error i am trying to rename the database to msd_tsp_wer_rty_123 then the database could not be exclusive ly locked to perform the opreration.when i am converting to single user mode then also its saying the same error can any one can help how to take backup now i am using the syntax Backup Database msd_tsp-wer-rty-123 to disk='c:\sts.bak' please its urgent. help me now
Did you try using brackets for the database name? BACKUP DATABASE [msd_tsp-wer-rty-123] TO DISK 'c:\some\directory\filename.bak' or in your case Backup Database [msd_tsp-wer-rty-123] to disk='c:\sts.bak'
Thanks a lot it worked.you have helped me at right time.Thanks once again. when i talken the backup by givin braces[] it worked thanks.
Can you post the actual syntax you are using? I typically use. BACKUP DATABASE MY_DB TO DISK = 'J:\BACKUP\FULL\MY_DB_06-30-2011.BAK'
@sunithalee : it would better if you could post the ACTUAL code - you have a syntax error, and it is difficult to say where if you only post generic code.
if you have '-' in your database name, you should reference it between [] delimiters e.g. BACKUP DATABASE [msd_tsp-wer-rty-123] ........
