November 27, 2019 at 3:51 pm
I was restoring a nightly backup for a application upgrade that failed and even after the restore of app server and db the application did not like the database. I restored the database with 'Overwrite...' and the application was able to connect.
If the database had been updated then i restored a prior backup why would the restored application see the database as different? Are there a database properties that do not get reset on restore?
thanks
November 27, 2019 at 4:05 pm
Do you have the respective RESTORE statements that you used? If you restore with NORECOVERY, for example, you won't be able to access the database until you've recovered it. If there are active transactions in the log and you don't use WITH REPLACE (overwrite), the restore will fail. This is one of the reasons why I prefer T-SQL to using the GUI - you can always go back and see what you did.
John
November 27, 2019 at 4:05 pm
'Overwrite' is not a T-SQL RESTORE option. Did you mean REPLACE, perhaps?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply