backup database not working
-
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
-
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
Why "Force restore over existing database"?[^]
thatraja |Chennai|India|
Brainbench certifications
My Dad had a Heart Attack on this day so don't... -
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
In a simple file copy pasting scenario what happens ? If you're pasting file at the location where file with the same name exists there, They will ask you whether you want to overrite it ? Same happens with DB, If you're restoring DB that sets is already existed in DB then you need to override it rather then creating duplicate DBs. I hope you get your answer.
Regards, Hiren.
My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator. -
Why "Force restore over existing database"?[^]
thatraja |Chennai|India|
Brainbench certifications
My Dad had a Heart Attack on this day so don't...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
-
In a simple file copy pasting scenario what happens ? If you're pasting file at the location where file with the same name exists there, They will ask you whether you want to overrite it ? Same happens with DB, If you're restoring DB that sets is already existed in DB then you need to override it rather then creating duplicate DBs. I hope you get your answer.
Regards, Hiren.
My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.