Timeline for Backing up / restoring a 20GB database with images stored as binary code
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 16, 2017 at 20:10 | history | edited | Hannah Vernon♦ | CC BY-SA 3.0 |
removed superflous "thanks" wording.
|
| Aug 16, 2017 at 20:07 | answer | added | Hannah Vernon♦ | timeline score: 2 | |
| Nov 1, 2015 at 11:05 | history | edited | marc_s | CC BY-SA 3.0 |
added 20 characters in body
|
| Oct 30, 2015 at 16:49 | comment | added | William P | Thank you Marian. 1) As long as the data is saving in the engine itself, the fact that we can't read it in Management Studio is a lesser issue. I was concerned that whilst backing up the data through MS, this data could get lost. 2) I've done a DBCC CHECKDB on the db and it's got no issues. It appears to have been a problem with the backup itself but I've run another backup and it's now saying: Backup mediaset is not complete. Files: C:\Databases\2015-10-30\zapkam.bak. Family count:2. Missing family sequence number:2 Is it missing something? How could I find what's missing? | |
| Oct 29, 2015 at 22:23 | comment | added | Marian | 1. can't do in SQL, need to do it in .NET or something similar. You probably try to export it in SSMS, which has some limits. 2. reads more like a backup failure. Run a verify on the backup, or a DBCC CHECKDB on the db itself. 3. That's, most likely, a network issue, not a db one.. try another way of moving it around. | |
| Oct 29, 2015 at 20:12 | history | migrated | from stackoverflow.com (revisions) | ||
| Oct 29, 2015 at 14:21 | history | asked | William P | CC BY-SA 3.0 |