I am pretty much a novice with SQL 2005/2008. I am working with a new client that has GFI Mail Archiver. From what I can tell the database that is setup to archive the messages is corrupt. The DB is 2.6GB and I have a very large binary attachments file. No big deal but this one DB will not work.
I can't figure out what is going on.
1- What are my options to datacheck?
2- I have tried exporting to a newly created DB and it still fails?
3- I have tried to export to a csv file and it still fails.
Basically I need help all over. Any suggestions. This is time critical.
OK. I imagine you are trying to use something to do an export. Perhaps that something is just generating a big text file ( a script) that can recreate the database by issues TSQL commands
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
I've encountered valid database schemas that do not have a primary key. For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis. However, occasionally due to user error or a scheduled task…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…