Timeline for SSMS Restore Database wizard slow to respond
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 20, 2020 at 3:34 | history | edited | Kind Contributor | CC BY-SA 4.0 |
added warning from comment
|
| Jun 18, 2020 at 18:02 | comment | added | Keith E. Truesdell |
Sorry, one more thing, this was the perfect solution, thank you. But to add something else, the sproc 'sp_delete_backuphistory` will delete all history for all DBs older than that @oldest_date variable. One may want to have older history on some DBs than others. This sproc will not do that based on the DB.
|
|
| Jun 18, 2020 at 17:59 | comment | added | Keith E. Truesdell | Also, i agree that it should be part of your maintenance plan. We just switched from a vendor doing the backups to Ola's scripts and I am surprised that this was not (from what I could see) in Ola's scripts. Unless I am missing something, maybe a default we switched turned that off or it was something leftover from the vendor. | |
| Jun 18, 2020 at 17:57 | comment | added | Keith E. Truesdell |
As a small edit, just make sure you are on the msdb for that sproc. It may seem obvious, but i was on the database I was trying to restore and it tripped me up for a couple minutes wondering if I had an older version of SSMS or SQL Server that doesn't have that sproc
|
|
| Apr 27, 2020 at 21:28 | vote | accept | Schmallen | ||
| Jun 27, 2019 at 0:15 | review | First posts | |||
| Jun 27, 2019 at 8:17 | |||||
| Jun 27, 2019 at 0:14 | history | answered | Kind Contributor | CC BY-SA 4.0 |