Databases

57K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

How to fix OLE DB connection error while connecting Oracle database using SSIS
In this article, we will see how we can fix the OLE DB connection error when connecting to an Oracle database using SQL Server Integration Services.
0
Exploring SharePoint 2016
LVL 13
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

High Availability and Disaster Recovery are two of the most factors to make sure our business running. However, it requires much effort to configure and maintain. With Microsoft Azure solution, it's quite simple for us to configure.
0
Recently, our client has been planning to use Azure platform and one of the most important factors is to migrate their data from MongoDB Atlas into Azure Cosmos DB. In this article, I would like to summarize some necessary steps to migrate data from MongoDB.
0
Be a MySQL Ninja! Install MySQL the PowerDEV way - without installers!
0
In this article, we will get a brief idea on MariaDB, how to install and configure it on a Windows environment.
0
Exchange Disaster Recovery
Best Disaster Recovery Plans for Exchange 2016, 2013, 2010 environment. Step by Step guide for Exchange Recovery of Server, Database and Mailbox Level after Disaster (Corruption and accidental deletion) recovery using PowerShell Commands and automated solutions.
0
Restore Exchange 2010 Database to Exchange Server
Now restore dismounted Exchange 2010 Database to a Different Server such as 2013, 2016 and below environment. Use Windows Server Backup and restore back offline database mailboxes to again in an Exchange environment. Also, Exchange Administrator can try the Exchange recovery tool.
0
Exchange Recovery
The article will provide methods for admins and users of MS Exchange to recover a disabled mailbox by using Exchange Admin Center and Exchange Management Shell. Microsoft has provided built-in ways to connect this disconnected mailbox to an Active Directory user account.
0
Microsoft Exchange Server

Migration will be from 2007 to 2010/2013 then from 2010/2013 to 2016

Why do we need to migrate from 2007 to 2010/2013 then from 2010/2013 to 2016?

As per Microsoft limitations, we cannot migrate to any version of Exchange without passing the next version


Process plan & schedule day's to Migrate Exchange Server 2007 to Exchange 2016:

  • Install Exchange 2010/2013 into Exchange 2007 organization.1-2 day’s
  • Configure Exchange 2010/2013 and Exchange 2007 coexistence. 2-3 day’s
  • Migrate Exchange 2007 mailboxes, public folders, and other components to Exchange 2010/2013.2-3 day’s - Depending on Complexity
  • Configure Exchange 2010/2013 SSL-Cert. 1 day
  • Decommission and remove all Exchange 2007 servers.1-2 day’s
  • Install Exchange 2016 into Exchange 2010/2013 organization. 2-3 day’s
  • Configure Exchange 2016 and Exchange 2010/2013 coexistence. 2-3 day’s
  • Migrate Exchange 2010/2013 mailboxes, public folders, and other components to Exchange 2016. 2-3 day’s (Depending on Complexity)
  • Configure Exchange 2016 SSL-Cert. 1 day
  • Decommission and remove all Exchange 2013 servers.1-2 day’s

    so a total is 15-20 days’ work (rough estimate) 




Decommissioning Exchange Server 2007 Process  :

The steps to decommission Exchange Server 2007 are listed below:


1. Backup Exchange Server along with its User Mailbox database(s) and Public Folder database(s)


2. Migrate user mailboxes with their complete properties and settings to another Exchange Server


3. Migrate Public Folders to another Exchange Server


4. Disable Local Continuous Replication of User Mailbox Database and Public Folder Database


5. Remove User Mailboxes


6. Stop the usage of Exchange Server 2007


7. Remove the Public Folder Database

 

7a. Force removal of Public Folder Database


8. Remove the User Mailbox Database


9. Remove the Storage Groups


10. Remove or move the Offline Address Book (OAB)


11. Move Routing Group Connector to another Exchange Server


12. Remove Exchange Administrative Group, if no other Exchange Server is installed in the domain.


13. Uninstall Exchange Server 2007








 Hardware & Software Requirements:


- 2 Servers for Migration steps.


- 2 Server’s if we need to establish 2 parallel Exchange server’s one as a backup server.


- 2 SAN/NAS Storage Virtual Disks if we going to use DAG as High Available Database with the same drive letter.


- Windows Server 2012 R2 /2016 License.


- Windows Server UsrCALs


- Exchange Server 2016 License.


- Exchange Server UsrCALs


-- Mailbox Exchange Repair & Recovery Software, in case we got corrupted data.


- Offline Copy of the mailbox database:


-
Exchange database (.edb)


- Transaction log (.log file).


-
Checkpoint file (.chk).


-
Reserve log files (.jrs).


-
Temporary file (tmp.edb).


How to Calculate Space for new Exchange Server :


Space depends on Number of Org Users, Here we have 200 users, with 4GB Quota


 (200 * 4GB ) +(200*15MB)= (800GB +3000MB )   (no of mailbox’s * Quota ) + ( no of mailbox’s * whitespace)  Active

 (200 * 4GB ) +(200*15MB)= (800GB +3000MB )   For use ( Database Availability Groups  )  DAG’s for High Available    Passive


Note:
Whitespace isn't freed up until after the retention period is passed for the mailboxes you have moved, also not all the space of a mailbox will be freed up so trying to stop stores expanding by moving mailboxes out of them doesn't really work, you would be better off moving the mailboxes to a fresh store and removing the old store, this will give you the added advantage of defragging the store as well and should result in smaller databases


Edited by: Andrew Leniart 

0
Microsoft Access
If your application will be used by financial auditors, then never ever use the delete functions to remove incorrect documents from your ledgers because financial auditors will require to audit, even cancel or reject documents and reasons for their rejection.
0
LVL 59

Expert Comment

by:Ryan Chong
Comment Utility
It depends on local regulatory, financial data could be kept for at least N years before it can be purged. financial auditors will audit on the what, where, when, which, how of your data is being stored, modified, deleted.

the Confidentiality, Integrity, Availability (so called CIA) should always be taken into consideration for the information system that involving data.

fraud could also happen if the data integrity was compromised regardless it's whether delete query or flag tagging.

and it not only applied to MS Access but in general applied to other DBMS/ RDBMS as well.
0
Introduction to R
LVL 13
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Restore Stored Procedure in SQL Server
In this article, we will discuss how to deal with a situation wherein you face an issue with a mandatory stored procedure in your critical database.
0
A more efficient Linked Table Manager -
Are you ready for a Linked Table Manager (LTM): - with a sizable form - which identifies which connections are valid and how many tables are associated with the connection - which doesn't ask you to select the BE multiple times when you've identified tables from multiple sources to refresh?
5
LVL 28

Expert Comment

by:Andrew Leniart
Comment Utility
Hi Charlotte.

Andrew, my biggest pet peeve about Access training and "how-to" articles is that they address the tools in Access but rarely the underlying design principles that are essential in building a database.

Indeed. You make an excellent point, one that I hope Dale (author of this article) and other readers will take note of for future article submissions. Perhaps an article explaining just that? :) Yes, there are already many explanations to be found with Google.

The difficulty I see here is that the term "Database" is so broad that to a layman, can also sound such technical a term as to discourage the excitement of learning about it. A title like "Learn the underlying design principles involved in building a database" wouldn't likely attract my attention, nor dare I say it, most others who don't have a vested interest in learning Access or other related software.

Yet if I saw something I could relate to, like "Learn to organize your favorites so that all browsers can use them" and do that in Access, well, that might be something I'd click on and actually read. The trick is in finding a way to educate using a hook and subject matter that will entice people to want to read and want to learn more. That's why I think different ways of educating on the same topic is so important.

Take the question: What is a database?

If I "Google" that as kindly suggested to me earlier by Joe, then the first thing I get is that its "a structured set of data held in a computer, especially one that is accessible in various ways."

Sounds too much like programming to me and doesn't really entice me to continue digging in order to learn more. I think that's a core problem of why many don't turn to something like Access and use Excel instead - it's too much like programming.

It's only when the penny drops (and for me, it's by reading articles like this one out of need while editing) that you start to get more interested in digging further. Editing articles such as this one prompt me to ask the question, how can I relate what I do in Excel, to do it even better in something like Access?

I confess I have a vested interest in promoting for these types of articles, both as someone who wants to read them, and someone who gets to edit article submission here in a volunteer Page Editing capacity. We already have a ton of technical "how to" articles as you say, but I think that's a good thing and keep them coming I say!

Yet I think interestingly written articles that will attract the "Joe Averages" of the world, who use Excel to store information in mostly because it seems easier to come to terms with using, yet will never know until enticed to dig deeper just how much easier life could be by delving into the cryptic world of databases.

That's the type of "How to" article I'm trying to promote be written here. Is there a single way of doing that? I don't think so. I'm just trying to encourage readers who have the necessary knowledge to give it a go. Hope that makes sense? :)

Look for a book by Michael J Hernandez, "Database Design For Mere Mortals"

Thanks for the heads up. I'll most certainly do that.

Regards, Andrew
0
LVL 53

Author Comment

by:Dale Fye
Comment Utility
for those of you using the Linked Table Manager, the latest version (posted in the original article) is 1.14.07, which fixes several bugs, including one which caused the linking operation to fail if the path to the backend is > about 100 characters (has to do with the Title property of the FileDialog).

enjoy.
0
Sysadmin Day 2018 is coming up on July 27th, and, going along with the recent premiere of the new hit movie The Incredibles 2, we want to share a light-hearted and comical explanation of what sysadmins are and why they are so incredible.
2
Export Exchange Mailbox to PST
Getting Error, Export Database to PST file failed in In Exchange 2016/13/10 due to file size, bad items, syntax error of Powershell commands. Fix file status issue by directly exporting mailboxes of Exchange into pst format via the export utility.
0
Recover Exchange Mailbox
In Exchange Server 2003 and 2007 the command isinteg is used to check the health of database and to repair Exchange Database. If the command is not successful to restore a corrupt damaged Exchange Mailbox. try an automated solution as isinteg command supports Exchange 2007 and below versions only.
0
“The Microsoft Jet Database engine stopped the process…” while working with a Microsoft Access database. The database may be saved as MDB or ACCDB file depending on the Access version that you used to create the database file.
0
Test data generation in software testing depicts the underlying conditions for a test and speaks to the medium through which the tester impacts the product. It is a critical piece of most Functional Testing.
0
Repair Exchange Database
Check Mailbox Corruption in Exchange for the proper working of Exchange Server. Use IsInteg Or New-MailboxRepairRequest for regular health auditing and to check Integrity of Exchange Database(.edb) file. Repair corruption in EDB file via Eseutil Powershell commands in MS Exchange 2013/10/07 versions
2
This tutorial is a great guide for newbies in SQL Server who never backup the database and for people with some experience, because you will learn some tips that you may not know.
1
Exploring SQL Server 2016: Fundamentals
LVL 13
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

SQL Backup Repair
Know how to repair corrupted backup files using SysTools SQL backup Recovery, Also understand the reasons behind .bak file corruption in SQL Server.
0
Recover Exchange Mailbox
Know how to repair Exchange Database of 2016/ 13/ 10/ 07 using eseutil /p, /r, /d Powershell commands. Also fix Dirty Shutdown and Event 501, 533, 1216 ID Error using inisteg and New-MailboxRepairRequest to repair Mailbox Database of Exchange 2016 /13/10/07 and other below versions.
0

Expert Comment

by:Sunil Sharma
Comment Utility
Facing Exchange Server mailboxes is really difficult to handle, but by using exchange server recovery tool, you can easily fix the issue very easily. The tool is well equipped to deal with (in dealing with) Exchange disasters situations. You can restore mailboxes from any of the backups created at any point of time, even the ones created using third-party backup tools.
0
LVL 6

Expert Comment

by:bobluis
Comment Utility
If Exchange database is in clean shutdown state, then move Checkpoint file and all Log files to a different folder and try to mount the Exchange database. If the database is in dirty shutdown. You should restore the database from backup. Or you need to repair the database from using Eseutil/p command.
0
Repair Corrupt Exchange Mailbox
Learn how to reduce mailbox database size of Exchange 2016,2013, 2010, 2007 and other versions. As Storage Limits for Exchange Mailboxes in Exchange versions are different. Try to use Defragment mailbox to remove whitespace to shrink the mailbox size of Exchange Mailboxes to increase performance.
0
Reverse path filtering setting between RHEL 5 vs RHEL 7
This is about the change in the value setting for the rp_filter parameter in Linux.
0
Fix an SQL Server Deadlock
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
0
Are you working to mount the dismounted Exchange 2013 database? Then the best course of action is to analyze the causes of Database issue, their probable solutions and decide for the appropriate course of action.
0

Databases

57K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.