Timeline for How to restore database (daily) with multiple bak files using a T-SQL script?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 19 at 13:02 | comment | added | Ronaldo | @Java see This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY | |
| Aug 19 at 11:55 | comment | added | Ronaldo |
@Java, your new error seems to imply that you're trying to restore a backup from a database that was created on an older (or maybe not patched) version of SQL Server to a newer one. If that's the case, it might be a limitation of the option WITH STANDBY and the correction would be just remove that option of the restore command. Please, run a SELECT @@VERSION on both servers to compare if the server your're restoring has a newer version of SQL Server.
|
|
| Aug 19 at 0:20 | comment | added | Java | Thank you for your help. I replaced the Part 5 with your code and got the error on the top (Update on the original post). Does Part 6 look ok (stay same)? Also, the original DB is on "normal" status. | |
| Aug 16 at 23:30 | history | answered | Ronaldo | CC BY-SA 4.0 |