Timeline for How to restore database (daily) with multiple bak files using a T-SQL script?
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 20 at 18:37 | comment | added | Java | @Ronaldo I guess they are full back up. Sorry. I am still trying to learn this stuff. Sorry that I confused you. I actually gave up on my previous T-SQL and posted to a new thread (stackoverflow.com/questions/78890056/…) using the generated T-SQL. Thank you. | |
| Aug 20 at 18:31 | comment | added | Ronaldo | @Java what kind of backup generated those files: FULL, DIFF or LOG backup? In the original script you were treating them as if they were log backups, now, from the generated script of update (8/19/2024) it seems you're restoring from a full backup. Do you still have an error? | |
| Aug 19 at 17:57 | comment | added | Java | @Yano_of_Queenscastle Thank you so much. I have a question. How do I modify the area where it has a static date like "20240819_1.bak" to wildcard kinda like "..2024*_1_bak'? I updated the post with the script that I have. (on the top) | |
| Aug 19 at 17:47 | history | edited | Java | CC BY-SA 4.0 |
added 578 characters in body
|
| Aug 19 at 5:51 | comment | added | Yano_of_Queenscastle | "I tried using GUI, and it worked." FYI: If you can prepare the desired action in SSMS, instead of executing it by clicking OK, you can often ask SSMS to script the action for you. Then tweak the generated T-SQL script as necessary. imgur.com/a/CrQehhD | |
| Aug 19 at 1:57 | history | edited | Java | CC BY-SA 4.0 |
added 75 characters in body
|
| Aug 19 at 0:27 | history | edited | Java | CC BY-SA 4.0 |
added 296 characters in body
|
| Aug 19 at 0:16 | history | edited | Java | CC BY-SA 4.0 |
added 130 characters in body
|
| Aug 19 at 0:03 | history | edited | Java | CC BY-SA 4.0 |
added 170 characters in body
|
| Aug 18 at 23:57 | history | edited | Java | CC BY-SA 4.0 |
added 170 characters in body
|
| Aug 16 at 23:30 | answer | added | Ronaldo | timeline score: 3 | |
| Aug 16 at 22:38 | comment | added | nbk | see if this helps stackoverflow.com/questions/18360666/… | |
| Aug 16 at 20:57 | history | edited | Java | CC BY-SA 4.0 |
added 10 characters in body
|
| Aug 16 at 20:52 | history | asked | Java | CC BY-SA 4.0 |