Activity overview
Latest activity by DBNewbie_2007
Impact of VERIFY on Backups
We have the Backup Option "CHECKSUM" selected, but not "VERIFY"... would "best practices" be to have this option set? If yes, what is the "hit" in terms of processing speed? A lot of our databases ...
I realize this is an older post/announcement, but I just wanted to make sure anyone who does an "uninstall" reads the full "uninstall" document first. / comments
I realize this is an older post/announcement, but I just wanted to make sure anyone who does an "uninstall" reads the full "uninstall" document first.
Not sure how this was even possible with the "Support and Upgrade" expired, but the backup instance in Production had the "GUI" components set to 10.1.18.2060 but the "server components" were still 10.0.14.1166. Update was done in June. Removed the GUI component, re-installed the 10.0.14.1166 version and backups appear to be working correctly. Manually ran a "RESTORE VERIFYONLY" on a few files to confirm they were OK. [image] [image] / comments
Not sure how this was even possible with the "Support and Upgrade" expired, but the backup instance in Production had the "GUI" components set to 10.1.18.2060 but the "server components" were still...
SQL Backup Restore Errors (End of File)
It appears all of the backups on our production (aka Prod) and development (aka Dev) servers are bad. While the logs indicate everything backed up fine, when we try to restore the backups we get th...
Glad I found this! I just lost a lot of work (code) that I had not saved (**SIGH**... save and save often) and thought it was related to SSMS 18.9.1! Right clicking on a tab caused the entire session to just disappear. Release 10.6.14 appears to have solved this issue. / comments
Glad I found this! I just lost a lot of work (code) that I had not saved (**SIGH**... save and save often) and thought it was related to SSMS 18.9.1! Right clicking on a tab caused the entire sessi...
SQL Backup Error Messages
We recently had an interesting problem. We have a script to restore a lot of backups onto a secondary server. One of the steps is to capture the information about the backup file, i.e., <div>DECLAR...
Note sure if this is related, but after a Windows 10 update (KB4528760), when in SSMS (17.9.1/14.0.17289.0), checking for an update of SQL Prompt (10.0.1.12389) throws an error, then SSMS restarts. Downloading the SQLPrompt installer and manually updating SQL Prompt to 10.0.8.13382 appeared to have resolved the problem. / comments
Note sure if this is related, but after a Windows 10 update (KB4528760), when in SSMS (17.9.1/14.0.17289.0), checking for an update of SQL Prompt (10.0.1.12389) throws an error, then SSMS restarts....
SQL Backup Logs and fn_dump_dblog()
We had an incident earlier in the week where data was accidentally deleted from a database and we needed to track down when it happened and who caused it. There are a few undocumented functions for...
SQL Backup Logs and fn_dump_dblog()
We had an incident earlier in the week where data was accidentally deleted from a database and we needed to track down when it happened and who caused it. There are a few undocumented functions for...
I tried to re-submit a ticket for this, as the problem has not been resolve and this is now causing serious issues, since we are unable to schedule or perform additional backups/restores. / comments
I tried to re-submit a ticket for this, as the problem has not been resolve and this is now causing serious issues, since we are unable to schedule or perform additional backups/restores.