I agree with you. But in mine case, I don;t have any DB with same name. I just got a BAK file from some other server and tried to restore the same on another server.

G-U-R-U

As per the above mentioned link .... Force restore over existing database means if a database already exists with the same name that you are restoring, then overwrite it. If one doesn't exist, just create it. But for mine case, I don;t have any existing database and still I'm getting the error.

G-U-R-U

I don't know a way to read the log file. And the only tool i know which can possibly help you is Apex SQL Log.

G-U-R-U

For few of us, its seems to be a simple question, I already have a solution for this... I don;t need solution, I need explanation. Problem: I'm trying to backup the database by selecting the database source, backup type = full, name the backup set, and leave the rest as default. The backup seems to be successful. The problem comes when I need to restore the backup database. I 've tried many times and a few different kinds of selection, all fails. I've selected the source for restore from device, that is the .bak file from backup folder and remains the rest of selection as default. Here is the error message I get: System.Data.SqlClient.SqlError: The backup set holds a backup of the database other than the existing 'testing' database. (Microsoft.SqlServer.Express.Smo) I know the solution to this: In Restore window-> Options tab, check "Force restore over existing database" I need why should I check force restore. Can some one please explain?

G-U-R-U