tag:blogger.com,1999:blog-33238911443533182072024-03-17T03:18:28.955-04:00SteveMann's PathDiscussions on technology related to collaboration with SharePoint and InfoPath along with other cool and possibly geeky stuff.Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.comBlogger190125tag:blogger.com,1999:blog-3323891144353318207.post-51322768312799656352018-06-25T09:04:00.000-04:002018-06-25T09:04:40.845-04:00The Challenges of Microsoft Exchange Recovery (Backup is not always the solution)<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
<span style="font-family: "calibri" , sans-serif; line-height: 107%;"><b><span style="font-size: large;">Introduction</span></b></span></h2>
<span style="font-family: "calibri" , sans-serif; font-size: 11pt; line-height: 107%;">The
integrity of Exchange Server and the associated mail storage should always be the top priority of an Exchange administrator. Email is essential in an organization as it is a primary communication tool in conducting business both internally and externally. Many users place emails in folders and rely on them for their work processes. Corruption of mailboxes and loss of emails could be detrimental to any organization. Therefore, w</span><span style="font-family: "calibri" , sans-serif; font-size: 11pt;">ithout an Exchange data recovery plan in place, the IT team never
retrieves lost data, which can bring an entire organization to a standstill. </span><br />
<span style="font-family: "calibri" , sans-serif; font-size: 11pt;"><br /></span>
<span style="font-family: "calibri" , sans-serif; font-size: 11pt;">This post explores the challenges of maintaining the integrity of Exchange Server while providing some of the best practices for Exchange data recovery
planning; solidifying the protection of data loss within an Exchange Server infrastructure.</span><br />
<span style="font-family: "calibri" , sans-serif; font-size: 11pt;"><br /></span>
<span style="font-family: "calibri" , sans-serif; font-size: 11pt;"><br /></span>
<span style="font-family: "calibri" , sans-serif;"><b><span style="font-size: large;">Challenges</span></b></span><br />
<span style="font-family: "calibri" , sans-serif;"><br /></span>
<span style="font-family: "calibri" , sans-serif;"><b>Data Recovery Plans</b></span><br />
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;">The top challenge in my book is not having a plan at all. It is essential to document steps and processes for the remediation of issues and disasters. A document or Wiki page within an IT's intranet site provides a resource for understanding what needs to be performed to resolve critical incidents. Shirley Zhang, a data recovery expert, explains what should be included in a document plan in her article <a href="https://www.datanumen.com/blogs/4-top-challenges-facing-data-backup-recovery/">here</a>. </span></span><span style="font-family: "calibri" , sans-serif; font-size: 14.6667px;">Shirley has the lack of plan as her second challenge, however, her remaining two challenges revolve around the plan itself. </span><br />
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;"><br /></span></span>
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;">It is one thing to have a plan in place and documented, however, the plan is only as good as the due diligence and testing of the processes outlined. It important to prove out the disaster recovery steps and perform testing, if not in production then at least a staging environment that mimics production and is not isolated to a virtual standard environment. </span></span><br />
<br />
<span style="font-family: "calibri" , sans-serif;"><b>Backup Technology and Processes</b></span><br />
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;">Recovering from data loss or corruption usually involves the reliance on backups. Depending on the backup cycles, there could still be a lapse of data restoration. That is, data recovery may only provide the information and transactions from the last backup; which could mean the lose of data for the past 12 hours or so. In a database environment, there are logs to roll forward. This also applies to Exchange but it could get hairy as shown in Microsoft's procedures <a href="https://support.microsoft.com/en-us/help/296788/offline-backup-and-restoration-procedures-for-exchange">here</a>. </span></span><span style="font-family: "calibri" , sans-serif; font-size: 14.6667px;">Backup restoration and log processes can become tedious. </span><br />
<span style="font-family: "calibri" , sans-serif; font-size: 14.6667px;"><br /></span>
<span style="font-family: "calibri" , sans-serif; font-size: 14.6667px;">It may be better to repair your Exchange databases if you had a robust and reliable third-party tool. I did find one <a href="https://www.stellarinfo.com/edb-exchange-server-recovery.htm">here </a>by Stellar Phoenix. They have produced software for <a href="https://www.stellarinfo.com/edb-exchange-server-recovery.htm">Mailbox Exchange Recovery</a>.</span><br />
<span style="font-family: "calibri" , sans-serif; font-size: 14.6667px;"><br /></span>
<span style="font-family: "calibri" , sans-serif; font-size: 14.6667px;"><b>Disk Space and Data Size</b></span><br />
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;">In many organizations emails fly by the thousands. Users can send and receive several hundred emails per day. Business emails often contain attachments which are usually kept in the email itself. Therefore, mailboxes can become very large.</span></span><br />
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;"><br /></span></span>
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;">Multiply one large mailbox by the amount of employees and the gigabytes get up there. This presents a problem with disk space for backups as well as the duration for restoration. Restoration may require downtime and, with large amounts of data, this could take longer than the business can tolerate.</span></span><br />
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;"><br /></span></span>
<br />
<b style="font-family: Calibri, sans-serif;"><span style="font-size: large;">Solution</span></b><br />
<span style="font-family: "calibri" , sans-serif; font-size: 14.6667px;"><br /></span>
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;">As you can see from the challenges, once you have a recovery plan, the backup restoration may not be the best option using the standard "out-of-the-box" procedures. Without a third-party tool, restoration is better than repair as Tej Pratap Shukla `Dexter points out in his article <a href="https://www.experts-exchange.com/articles/16099/MS-Exchange-Server-Administration-and-its-Challenges-A-Walk-Through.html">here</a>. </span></span><br />
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;"><br /></span></span>
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;">However, with the right software, repairing your Exchange mailboxes instead of restoring would provide a quicker remediation with less downtime and a higher confidence of success. The Stellar Phoenix Exchange Recovery tool (available </span><a href="https://www.stellarinfo.com/edb-exchange-server-recovery.htm" style="font-size: 14.6667px;">here</a><span style="font-size: 14.6667px;">) is very reliable and gives you the coverage for dealing with mailbox disasters. This tool recovers, repairs, and restores Exchange assets making it a no-brainer for Exchange administrators to have in their back pocket.</span></span><br />
<b style="font-family: Calibri, sans-serif;"><span style="font-size: large;"><br /></span></b>
<br />
<b style="font-family: Calibri, sans-serif; font-size: x-large;">References</b><br />
<span style="font-family: "calibri" , sans-serif;"><span style="font-size: 14.6667px;"><b><br /></b></span></span>
<br />
<div class="MsoNormal">
(1) <a href="https://www.datanumen.com/blogs/4-top-challenges-facing-data-backup-recovery/">https://www.datanumen.com/blogs/4-top-challenges-facing-data-backup-recovery/</a><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
(2) <a href="https://www.experts-exchange.com/articles/16099/MS-Exchange-Server-Administration-and-its-Challenges-A-Walk-Through.html">https://www.experts-exchange.com/articles/16099/MS-Exchange-Server-Administration-and-its-Challenges-A-Walk-Through.html</a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
(3) <a href="http://searchexchange.techtarget.com/news/1137440/Best-Practice-2-Building-your-plan-around-the-technology-at-hand">http://searchexchange.techtarget.com/news/1137440/Best-Practice-2-Building-your-plan-around-the-technology-at-hand</a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
(4) <a href="http://blog.wei.com/backup-and-recovery-disaster-plan-challenges-tips%7C">http://blog.wei.com/backup-and-recovery-disaster-plan-challenges-tips|</a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
(5) <a href="https://support.microsoft.com/en-us/help/296788/offline-backup-and-restoration-procedures-for-exchange">https://support.microsoft.com/en-us/help/296788/offline-backup-and-restoration-procedures-for-exchange</a></div>
<div class="MsoNormal">
<br /></div>
</div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-48531828310860376822018-04-10T13:34:00.001-04:002018-04-15T18:32:54.623-04:00Uber Announces Improved Driver Experience with New App<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="background-color: white;"><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Los Angeles, Tuesday, April 10, 2018 - 10AM PT</span></span></span></div>
<div style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="background-color: white;"><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="letter-spacing: 0.08px;"><br /></span></span></span> </span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="background-color: white;"><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="letter-spacing: 0.08px;">Uber CEO, </span></span></span><a href="https://www.uber.com/newsroom/leadership/dara-khosrowshahi/" rel="noopener" style="background: 0px 0px rgb(255, 255, 255); box-sizing: border-box; color: #536a81; cursor: pointer; letter-spacing: 0.08px;" target="_blank">Dara Khosrowshahi</a>, <span style="background-color: white; letter-spacing: 0.08px;">announced on Tuesday </span><span style="background-color: white; letter-spacing: 0.08px;">major upcoming improvements to the driver experience. These improvements entail the deployment of an updated Uber Driver App. Several key players presented the improvements as well as discussed the development process including Alpha and Beta versions (along with retrieving feedback and bug reporting). </span><span style="background-color: white;"><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="letter-spacing: 0.08px;">The new Uber Driver App will be rolled out in a phased approach over the next few months. Continuous feedback and additional improvements will continue during this deployment phase.</span></span></span></span></div>
</div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzpkip_KzWKeeHSr7D_Y4kb6xn8YqKXYGMmXu9gGGWwd_vBLTkP5HvlC-AgsUUSz0eb1RY8NOAoGlRn5rUp1FBxXm_URp2dCJXoRG0shUMURphVWtTGtBdl1iuEgzxjp_6KrYYX4mdisU/s1600/uber1.PNG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="516" data-original-width="733" height="449" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzpkip_KzWKeeHSr7D_Y4kb6xn8YqKXYGMmXu9gGGWwd_vBLTkP5HvlC-AgsUUSz0eb1RY8NOAoGlRn5rUp1FBxXm_URp2dCJXoRG0shUMURphVWtTGtBdl1iuEgzxjp_6KrYYX4mdisU/s640/uber1.PNG" width="640" /></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span> <span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="background-color: white;"><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">The new app encompasses the following improvements:</span></span></span></div>
<div style="text-align: left;">
</div>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Current daily earnings posted at top of driving screen</span></span></li>
</ul>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Cleaned up maps for improved clarity</span></span></li>
</ul>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Navigation to promotional or surge zones</span></span></li>
</ul>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Enhanced surge map display with improved street/landmark clarity</span></span></li>
</ul>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Time and Distance displays to rider pickup</span></span></li>
</ul>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Quick (text) responses to riders will now be possible</span></span></li>
</ul>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Handling of lost of internet connections such that trip progress is no longer hindered</span></span></li>
</ul>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Improved organization and presentation of notifications</span></span></li>
</ul>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">Reorganized driver profile</span></span></li>
</ul>
<ul>
<li><span style="font-family: , "helvetica neue" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; letter-spacing: 0.08px;">New enhanced help guide including videos</span></span></li>
</ul>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-family: inherit;">PRESENTATION STARTS AT THE 42:10 MARK</span>:</span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="background-color: white; letter-spacing: 0.08px;"><br /></span> </span></div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-50731583090329389682018-04-07T18:22:00.001-04:002018-04-07T18:22:23.344-04:00CORTANA Urban Myths - English (Australia)<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/BCbwdxDc65s" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-45463190768249146002018-04-07T18:02:00.001-04:002018-04-07T18:02:18.389-04:00CORTANA Sports Jokes - English (Australia)<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/-79sfqfgDw8" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-74934557052096502732018-03-10T16:13:00.001-05:002018-03-10T16:13:19.319-05:00CORTANA Tongue Twisters - English UK<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/bdlsv-C3eeo" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-56376350510455520482018-03-07T17:55:00.001-05:002018-03-07T17:57:59.258-05:00CORTANA Riddles - English (UK)<div dir="ltr" style="text-align: left;" trbidi="on">
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/QLgmN_SmubE" width="480"></iframe></div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-75016731220560424232018-02-25T19:48:00.000-05:002018-04-15T18:36:08.522-04:00Completely Uninstalling Programs from Windows<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="http://8450aiud-7txtmenob3uie-5yd.hop.clickbank.net/" target="_top">Download the Perfect UnInstaller Software Here!</a>
<br />
<br />
<span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;">Have you ever been bothered with software/application/program that is half-installed/uninstalled incorrectly?</span><br />
<span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;">Have you been annoyed with the program you don't want is not in the currently installed programs list so you can not uninstall it through the standard Windows Add/Remove Programs?</span><br />
<span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;">Have you been afraid of the system errors or system crashing as you uninstall a corrupted program manually?</span><br />
<span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;"><br /></span><b style="background-color: #fafff7; font-family: arial, helvetica, sans-serif; font-size: 12px;">Perfect Uninstaller</b><span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;"> is a better, easier and faster way for you to completely uninstall any unwanted program that standard Windows Add/Remove Programs can't remove.</span><br />
<span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;"><br /></span><span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;">The key is that it searches for leftover files and registry keys --- and removes them! Here is my video:</span><br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i9.ytimg.com/vi/lUrOUPBgQP0/default.jpg?sqp=CKDUzdQF&rs=AOn4CLD6iIUsIzXzl8oSUZwBp-bc7MXukA" frameborder="0" height="266" src="https://www.youtube.com/embed/lUrOUPBgQP0?feature=player_embedded" width="320"></iframe></div>
<span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;"><br /></span><span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;"><br /></span> <span style="background-color: #fafff7; font-family: "arial" , "helvetica" , sans-serif; font-size: 12px;"><br /></span> <a href="http://8450aiud-7txtmenob3uie-5yd.hop.clickbank.net/" target="_top">Download the Perfect UnInstaller Software Here!</a><br />
<br /></div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-87641148951804110292018-02-22T20:28:00.001-05:002018-02-22T20:28:42.711-05:00How to Identify a LinkedIn Phishing Email and What to Do<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/FnED25FqMM0" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-84398166644231596122018-02-18T18:58:00.001-05:002018-02-18T22:01:35.798-05:00Launching FoxDot IDE After Installation on Windows 10<div dir="ltr" style="text-align: left;" trbidi="on">
After the FoxDot installation steps are complete, launching the FoxDot IDE is very simple. The installation steps are shown here: <a href="https://stevemannspath.blogspot.com/2018/02/installing-foxdot-on-windows-10.html">https://stevemannspath.blogspot.com/2018/02/installing-foxdot-on-windows-10.html</a><br />
<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/4wCMXxWAfIk" width="480"></iframe></div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-23246728936780810882018-02-18T18:57:00.001-05:002018-02-18T22:01:49.854-05:00Installing FoxDot on Windows 10 Including Python, Git, and SuperCollider<div dir="ltr" style="text-align: left;" trbidi="on">
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/sfwTC1e05yc" width="480"></iframe><br />
<br />
After the installation is complete you may launch FoxDot by following this: <a href="https://stevemannspath.blogspot.com/2018/02/launching-foxdot-ide-after-installation.html">https://stevemannspath.blogspot.com/2018/02/launching-foxdot-ide-after-installation.html</a><br />
<br /></div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com1tag:blogger.com,1999:blog-3323891144353318207.post-84789585211794141472018-02-16T15:44:00.001-05:002018-02-16T15:44:52.195-05:00Creating a Windows 2016 Server VM with VMWare Workstation<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/lqtZ76L2D1M" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-79135098530290333342018-02-15T18:33:00.001-05:002018-02-15T19:05:11.888-05:00SharePoint 2016: Exploring SharePoint Databases<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><iframe frameborder="0" marginheight="0" marginwidth="0" scrolling="no" src="//ws-na.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=US&source=ac&ref=qf_sp_asin_til&ad_type=product_link&tracking_id=stevemaspath-20&marketplace=amazon&region=US&placement=B079SLK647&asins=B079SLK647&linkId=593b112d4f40d050f483b489f8158f97&show_border=true&link_opens_in_new_window=true&price_color=333333&title_color=0066c0&bg_color=ffffff" style="height: 240px; width: 120px;">
</iframe>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><br />
<h2 style="text-align: left;">
<span style="line-height: 107%;"><b><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: x-large;">Introduction</span></b></span></h2>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12.0pt;">This post introduces the various types of databases within a
SharePoint farm and explores each type and instance.</span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 107%; mso-bidi-font-size: 11.0pt;"><br /></span></div>
<h2 style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: x-large;">Types of SharePoint Databases</span></h2>
<h2>
<o:p></o:p></h2>
<div class="HEADFIRST">
<div style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12pt;">The databases </span><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12pt;">that are created for use
of SharePoint 2016 are categorized as one of three types:</span></div>
<br />
<ul style="text-align: left;">
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Configuration</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Content</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Service Application</span></li>
</ul>
</div>
<div class="HEADFIRST" style="text-align: left;">
<br /></div>
<div class="HEADFIRST">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_KsXCa-LBbc2RQAjyT0PtwbWOQdOivJ6ZLa2x8R2UfmV7_Q1Nx6kavaJmhVglGcxJYa2BBwsi31d7MROqaf5A6JYU6S_nGOfp7LqX-RzjuhvqDz3YZGKL9B2tpzsCfgRiuX_wxKutUq4/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="157" data-original-width="584" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_KsXCa-LBbc2RQAjyT0PtwbWOQdOivJ6ZLa2x8R2UfmV7_Q1Nx6kavaJmhVglGcxJYa2BBwsi31d7MROqaf5A6JYU6S_nGOfp7LqX-RzjuhvqDz3YZGKL9B2tpzsCfgRiuX_wxKutUq4/s640/1.png" width="640" /></a><a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<br />
<br /></div>
<div class="HEADFIRST">
<div class="separator" style="clear: both; text-align: center;">
</div>
<br /></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12.0pt;">The configuration database is created
when you install the first instance of SharePoint and create a new farm. There
is only one configuration database and it is essentially your “farm” from a SQL
Server perspective. When you attach servers to your farm you select the
configuration database accordingly. The Central Administration content database
may also be considered a configuration database as the content it stores deals
with the configuration of the farm. More details about the configuration
database are explained in the next section.<o:p></o:p></span></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12.0pt;">Not to sound smart but the content
databases store all of the content within the SharePoint sites. Each Web
Application that is created on the farm may have one or more content databases
associated. This is where all of the pages, list items, documents, etc. are
physically stored. The smallest block of content in a content database is a
site collection. Therefore, a content database stores one or more site
collections. A site collection can only “live” in one content database.<o:p></o:p></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12.0pt;"><br /></span></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12.0pt;">It is a good idea to have multiple
content databases to help partition the SharePoint sites and provide
flexibility in backup and restoring. It is much easier to maintain a 40GB
database than a 400GB database for example. This book will explain more details
and functions that may be performed with content databases.<o:p></o:p></span></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12.0pt;">Finally, the DBA’s nightmare, are the
service application databases. For each service application in SharePoint, one
or more databases are created to maintain the settings and configurations of the
particular service application. <o:p></o:p></span></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12.0pt;">Previously in SharePoint 2007 (MOSS
2007), several of these services (Search, User Profiles, Business Data Catalog,
and Excel Services) were combined into the Shared Service Provider (SSP)
service of SharePoint. Usually this meant only one SSP database although you
could have more than one SSP and thus multiple databases.<o:p></o:p></span></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="HEADFIRST">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12.0pt;">SharePoint 2010 changed the
architecture of the SSP and split out each service into its own service
application. This provided more flexibility and scalability; however, it also
created more databases.<o:p></o:p></span><br />
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12pt;"><br /></span>
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12pt;">The same architecture model exists in
SharePoint 2016 and there are several new service applications - which again
means more databases. So that’s why I say these are the DBA’s nightmares because
now there can be 10-20 databases just for the service applications (Enterprise
search creates and uses four itself). </span></div>
<div class="HEADFIRST">
<br />
<h3 style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">
Configuration Database</span></h3>
<h2>
<o:p></o:p></h2>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV6R1kgDrHa-kTfTuwvQhOhoa0HOK7HgiTwFOm37-yLXAYaoYqGgyCOGRf60vOtMBnCCrJ5EoRRkaZxWEaqwbRQJeCaUrauiL00hr3IR2VFNP5Atg-Yfi1bleWg5NJXWYSdiEcuP9ZVEI/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="196" data-original-width="449" height="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV6R1kgDrHa-kTfTuwvQhOhoa0HOK7HgiTwFOm37-yLXAYaoYqGgyCOGRf60vOtMBnCCrJ5EoRRkaZxWEaqwbRQJeCaUrauiL00hr3IR2VFNP5Atg-Yfi1bleWg5NJXWYSdiEcuP9ZVEI/s640/2.png" width="640" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 107%; mso-bidi-font-size: 11.0pt;"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600"
o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f"
stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:324pt;
height:140.25pt' o:bordertopcolor="this" o:borderleftcolor="this"
o:borderbottomcolor="this" o:borderrightcolor="this">
<v:imagedata src="file:///C:\Users\Steve\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title=""/>
<w:bordertop type="single" width="4"/>
<w:borderleft type="single" width="4"/>
<w:borderbottom type="single" width="4"/>
<w:borderright type="single" width="4"/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;">The configuration database, as explained
previously, is essentially the “farm” from a SQL Server perspective. This
database is generally small and should maintain with less than 1GB of space. <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;">The configuration database stores data
about the following:<o:p></o:p></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span></div>
<ul style="margin-top: 0in;" type="disc">
<li class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; mso-fareast-font-family: SimSun; mso-font-kerning: 0pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">All of the other SharePoint databases<o:p></o:p></span></span></li>
<li class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; mso-fareast-font-family: SimSun; mso-font-kerning: 0pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">IIS Web Sites<o:p></o:p></span></span></li>
<li class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; mso-fareast-font-family: SimSun; mso-font-kerning: 0pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Site Templates<o:p></o:p></span></span></li>
<li class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; mso-fareast-font-family: SimSun; mso-font-kerning: 0pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Specific Farm Settings - Quotas, Blocked File Types<o:p></o:p></span></span></li>
<li class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; mso-fareast-font-family: SimSun; mso-font-kerning: 0pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Trusted Solutions<o:p></o:p></span></span></li>
<li class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; mso-fareast-font-family: SimSun; mso-font-kerning: 0pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Web Applications<o:p></o:p></span></span></li>
<li class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; mso-fareast-font-family: SimSun; mso-font-kerning: 0pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Web Part Packages<o:p></o:p></span></span></li>
</ul>
<br />
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;">This database is very read intensive,
however, as modifications and deployments are executed, the transaction logs
can get bloated. Therefore if you keep the recovery model in the default Full
state, it is recommended to backup the transaction log regularly for truncation
purposes. Otherwise, it is recommended to switch the recovery model of the
configuration database to Simple.</span></span></div>
<span style="font-family: "calibri" , sans-serif; font-size: 12.0pt;"><br /></span>
<br />
<h3 style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">
Central Administration Content Database</span></h3>
</div>
</div>
</div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 107%; mso-bidi-font-size: 11.0pt;"></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxCw9XeMfiyvdNKLqIfeuJ0dWP1D1ROOTwgfm0Vj0l68BEHwspY3Y1FtGWlN8yvi3IXSvqA4x49Z10UPNp_1cdfs1JPSGgyLwduy0XFjPk1OSAqWmRmlCNm94Wn26794oqxD54aDD-FEE/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="105" data-original-width="493" height="134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxCw9XeMfiyvdNKLqIfeuJ0dWP1D1ROOTwgfm0Vj0l68BEHwspY3Y1FtGWlN8yvi3IXSvqA4x49Z10UPNp_1cdfs1JPSGgyLwduy0XFjPk1OSAqWmRmlCNm94Wn26794oqxD54aDD-FEE/s640/3.png" width="640" /></a></div>
<br />
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 107%; mso-bidi-font-size: 11.0pt;"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600"
o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f"
stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:324pt;
height:68.25pt' o:bordertopcolor="this" o:borderleftcolor="this"
o:borderbottomcolor="this" o:borderrightcolor="this">
<v:imagedata src="file:///C:\Users\Steve\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title=""/>
<w:bordertop type="single" width="4"/>
<w:borderleft type="single" width="4"/>
<w:borderbottom type="single" width="4"/>
<w:borderright type="single" width="4"/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12pt;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12pt;">The Central Administration (Central
Admin) Content Database is used to store the content of the Central Admin web
application which is used to administer and configure farm wide systems and
services. This database also is generally small and should maintain at less
than 1GB of disk space (just like the configuration database). </span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;">The recovery
model defaults to Full it is fine to keep it that way. There shouldn’t be too
much read/writes as it is usually just the SharePoint Administrator(s) who is/are
making modifications and generally content such as documents is not uploaded to
Central Admin like a normal content database. </span></span><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12pt;">However, it could increase in size if
PowerPivot is installed and deployed within the SharePoint farm. All of the
Excel worksheets and Power Pivot data files used in the Power Pivot Management
Dashboard are stored within the Central Admin content database.</span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12pt;"><br /></span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 12.0pt;">
</span><br />
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;">The default database name is
SharePoint_AdminContent_<guid>. DBA’s tend to hate the GUID in the database
name because a) it is not “clean” and b)
backup programs tend to have issues with the GUID involved. Therefore it is
recommended to create the Central Admin site via PowerShell as explained in Chapter 2 of my DBA Guide.</span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<h3 style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">
Content Databases</span></h3>
<h2>
<o:p></o:p></h2>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFyOC_rzIi8Xl2o-LvmAD4-sgFV2xreNwhboxVNLPZ1bhkoUrmldGFKmS37ttwhkEUdA3X09FMn8lnMR3xJn_NWEihp154joR-wYCghpDZVUX4hE6ckKVCmvgIj78k_a3S937AKxmVJUQ/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="147" data-original-width="472" height="198" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFyOC_rzIi8Xl2o-LvmAD4-sgFV2xreNwhboxVNLPZ1bhkoUrmldGFKmS37ttwhkEUdA3X09FMn8lnMR3xJn_NWEihp154joR-wYCghpDZVUX4hE6ckKVCmvgIj78k_a3S937AKxmVJUQ/s640/4.png" width="640" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="HEADFIRST">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;">The Content Databases store all of the
content for all of the site collections on the farm within a given web
application. This includes list items, documents, web part settings, user
information, and other site related configurations. <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Each web application must have at
least one content database but may have multiple. A site collection can only
live in one content database. While the recommended max size is 200GB (although
up to 1TB is supported), I personally like smaller 40-50GB content databases.
It is easier to backup and restore smaller databases as well as copying the
backup files around to different servers. </span><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 107%;">
</span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6CmSrJQF4wFUfjAgFlWNbfssYlKLXboEP7UKxqwb77WjAYqDN6r5hlGq-iLUVJoILev6vRdFAv9fDr22E8THRgK6banhfbQbk_lZTWTcO9RM5oiXczUOLRy9bA7uZD_kuouUZPce1yCs/s1600/5.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="323" data-original-width="379" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6CmSrJQF4wFUfjAgFlWNbfssYlKLXboEP7UKxqwb77WjAYqDN6r5hlGq-iLUVJoILev6vRdFAv9fDr22E8THRgK6banhfbQbk_lZTWTcO9RM5oiXczUOLRy9bA7uZD_kuouUZPce1yCs/s320/5.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><i>A web application may have multiple content databases which house multiple site collections</i></td></tr>
</tbody></table>
<div style="margin-left: 1em; margin-right: 1em; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6CmSrJQF4wFUfjAgFlWNbfssYlKLXboEP7UKxqwb77WjAYqDN6r5hlGq-iLUVJoILev6vRdFAv9fDr22E8THRgK6banhfbQbk_lZTWTcO9RM5oiXczUOLRy9bA7uZD_kuouUZPce1yCs/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div style="margin-left: 1em; margin-right: 1em; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><br /></div>
<div style="margin-left: 1em; margin-right: 1em; text-align: left;">
<br /></div>
<div class="HEADFIRST">
<b><span style="font-family: "calibri" , sans-serif; mso-bidi-font-family: "Times New Roman";"><!--[if gte vml 1]><v:shape id="_x0000_i1026" type="#_x0000_t75"
style='width:234.75pt;height:199.5pt'>
<v:imagedata src="file:///C:\Users\Steve\AppData\Local\Temp\msohtmlclip1\01\clip_image003.png"
o:title=""/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--><o:p></o:p></span></b></div>
<div class="MsoNormal">
<h3 style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">
Service Application Databases</span></h3>
<div style="text-align: left;">
<div style="text-align: left;">
<br />
<div class="MsoNormal">
<span style="line-height: 107%;"><span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;">The service application databases are created when their
respective service applications are created. If not all service applications
are needed or created, then obviously the databases are not needed or created.<o:p></o:p></span></span></span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /><span style="line-height: 107%;">The details of each service application database are explained in my DBA guide book.</span></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a></div>
<div class="MsoNormal" style="text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></span></div>
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a></div>
<div class="MsoNormal" style="text-align: left;">
</div>
<div class="MsoNormal">
<h2 style="text-align: left;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: x-large;">Conclusion</span></b></h2>
<div style="text-align: left;">
<span style="font-size: 12pt; line-height: 107%;"><span style="font-family: "arial" , "helvetica" , sans-serif;">There are many databases involved in a SharePoint farm. Understanding each database and how to manage them is essential for SQL Server administrators. My DBA guide attempts to enlighten those that manage SQL Server but do not understand SharePoint.</span></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<a href="https://www.blogger.com/blogger.g?blogID=3323891144353318207" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
</div>
<br />
<iframe frameborder="0" marginheight="0" marginwidth="0" scrolling="no" src="//ws-na.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=US&source=ac&ref=qf_sp_asin_til&ad_type=product_link&tracking_id=stevemaspath-20&marketplace=amazon&region=US&placement=B079SLK647&asins=B079SLK647&linkId=593b112d4f40d050f483b489f8158f97&show_border=true&link_opens_in_new_window=true&price_color=333333&title_color=0066c0&bg_color=ffffff" style="height: 240px; width: 120px;">
</iframe>
</div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-56012263455330165382018-02-06T20:02:00.001-05:002018-02-06T20:02:13.098-05:00Installing VMware Workstation Player on Windows 10<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/OhXogiEZawA" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-20108644283830965282018-01-28T22:52:00.001-05:002018-01-28T22:52:54.234-05:00CORTANA Math Jokes - English (Austraila)<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/hM9Am7Zg2JI" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-17431840298116436122018-01-28T16:54:00.001-05:002018-01-28T22:53:13.311-05:00CORTANA Science Jokes - English (Austraila)<div dir="ltr" style="text-align: left;" trbidi="on">
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/9qByG60Nl4Y" width="480"></iframe></div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-52017986439364551692018-01-22T20:54:00.001-05:002018-01-22T20:54:17.273-05:00CORTANA Animal Facts<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/w4uvqZl-C-A" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-6652157757579560162018-01-22T18:17:00.003-05:002018-01-22T18:17:38.232-05:00Installing Stellar Phoenix SQL Database Repair<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/Hj_wZkSVPVY" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-2374975911532236652018-01-22T18:17:00.001-05:002018-01-22T18:17:11.560-05:00Video of Repairing a Corrupt MDF File with Stellar Phoenix SQL Database Repair<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/57kAX3GE62Q" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-29860087593474547152018-01-22T18:07:00.000-05:002018-01-22T18:13:52.749-05:00Repairing a Corrupt MDF File with Stellar Phoenix Database Repair<div dir="ltr" style="text-align: left;" trbidi="on">
No matter what you do to prevent issues, there will be times when one of your SQL Server databases will become corrupt. Whether it is a live database or a copy, having a busted MDF file is not fun. The usual process to recovery involves restoring the database from a full backup, restoring incremental backups, and then rolling the logs forward from the last incremental backup. This standard process is warranted but can be time consuming and nerve racking.<br />
<div>
<br /></div>
<div>
I have found an easier way to repair my databases without worrying about backups and logs. Stellar Data Recovery has produced a SQL Database Repair application that will quickly scan and repair corrupted SQL Server databases.</div>
<div>
<br /></div>
<div>
While it is possible to run the repair process on a live database, my scenario involved an MDF file that I wanted to attach to my database server. </div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgENUIEY0G1zf_tcJE6hVqjMlL9ITzH784bSbnwxG5v1Nv6QHtgaEcWZbLf433CSC4X6D1sv8BXCNFveHAsq7jCoEJUfGoqs7q5ZiudPXDgUeQE-3otQ32B5VrvSoMtaCcLJ9t06sgwn_g/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="475" data-original-width="632" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgENUIEY0G1zf_tcJE6hVqjMlL9ITzH784bSbnwxG5v1Nv6QHtgaEcWZbLf433CSC4X6D1sv8BXCNFveHAsq7jCoEJUfGoqs7q5ZiudPXDgUeQE-3otQ32B5VrvSoMtaCcLJ9t06sgwn_g/s400/1.png" width="400" /></a></div>
<div>
<br /></div>
<div>
My MDF file was obviously bruised as SQL Server Management Studio did not recognize it as a primary database file; even though it was supposed to be.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0B-9s-4edS5YSZ7hJQfsiR94pHu7zKxFbO5BjgZiJHIZzTSR7Ijm45Bp4MfQAhxgkSuETkfzaapCiLfVZCvBTqACbasdKXc8Hx1RbGq42wnV-4G0reRHxZFkGrFT6Ja1n5YtZ0IUuLbQ/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="202" data-original-width="610" height="130" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0B-9s-4edS5YSZ7hJQfsiR94pHu7zKxFbO5BjgZiJHIZzTSR7Ijm45Bp4MfQAhxgkSuETkfzaapCiLfVZCvBTqACbasdKXc8Hx1RbGq42wnV-4G0reRHxZFkGrFT6Ja1n5YtZ0IUuLbQ/s400/2.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Luckily, I had Stellar Phoenix Database Repair installed. The software can run on your local machine or on a server. I recommend installing it on your local machine as the software can connect to your SQL Server instances and doesn't need to be local to the database(s).</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHLcbr0H4NMX1JszcCiUkDop9eCTa-8a6yCeJsiZZapPfrQz1M34madx7IsgnODurV2hT3tKflHi0Rryf-_U_Y6YFHMR6xk8GCAn3301YundPdTpzDNuo8TDY3K4L-s6XIt7gcvt1ucrA/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="215" data-original-width="383" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHLcbr0H4NMX1JszcCiUkDop9eCTa-8a6yCeJsiZZapPfrQz1M34madx7IsgnODurV2hT3tKflHi0Rryf-_U_Y6YFHMR6xk8GCAn3301YundPdTpzDNuo8TDY3K4L-s6XIt7gcvt1ucrA/s320/3.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Upon launching the repair app, the Select Database dialog automatically appears which saves the step of clicking on the Select Database top ribbon button:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiNHmhdgxLVG4CFyNQRwAZdNyvQ8V9-6Dnd_QcCdpJJN9_haINPUaGGmIsBgGertzTAiRxcq83xB9u2o84kS3damWysujgN-RVa_I43NKqmDGj0R3SmhNLe7QbV8_pzoDLx0tXS0r6IEY/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="568" data-original-width="516" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiNHmhdgxLVG4CFyNQRwAZdNyvQ8V9-6Dnd_QcCdpJJN9_haINPUaGGmIsBgGertzTAiRxcq83xB9u2o84kS3damWysujgN-RVa_I43NKqmDGj0R3SmhNLe7QbV8_pzoDLx0tXS0r6IEY/s400/5.png" width="362" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
All you need to do is select the database file using the Select Database button and then click the larger Repair button. The software will process and repair the database. It did not seem to take too long in my case. Once complete, you will receive a success message as follows:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijXr3xmYzFO8VPIBA1mEeSm7PBrGN2v4NCUiijjmwA920Nx2Jd86F7Sv6yGfyw6yoxWuyjaN1PnQ82Zf5zSIP18FhygqCJDDQjcaVquznoPQ9-nlvlx4AlIYGjw30THDI2hk5zwd5mhVE/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="155" data-original-width="468" height="131" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijXr3xmYzFO8VPIBA1mEeSm7PBrGN2v4NCUiijjmwA920Nx2Jd86F7Sv6yGfyw6yoxWuyjaN1PnQ82Zf5zSIP18FhygqCJDDQjcaVquznoPQ9-nlvlx4AlIYGjw30THDI2hk5zwd5mhVE/s400/6.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJhmx2VoJyFPlCh5tFHDHUhid1vQCMa6aj30WhcSJaUW-fsO0ZYEjYDGbfA16B58rkbLHO6_JJ3uVW4P2oCUsX8hUXzR-bRh_cgWawxowVxw9vwn373GuoYmB5yGKl2bmsK-YJQwdpExU/s1600/7.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" data-original-height="410" data-original-width="351" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJhmx2VoJyFPlCh5tFHDHUhid1vQCMa6aj30WhcSJaUW-fsO0ZYEjYDGbfA16B58rkbLHO6_JJ3uVW4P2oCUsX8hUXzR-bRh_cgWawxowVxw9vwn373GuoYmB5yGKl2bmsK-YJQwdpExU/s320/7.png" width="273" /></a>Originally I thought that this process fixed the MDF and that I could now use the original file. This is not the case. The Stellar Phoenix Database Repair application has brought all of the database structures and data into its system; your database is technically repaired in memory. You can review the table structures and data right within the app itself.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="" style="clear: both; text-align: left;">
Therefore you need to save to healed version in some fashion. </div>
<div class="" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTm_1yZIE6NBSVGtSEKUOFDBU-cKlBeopXoabmWU3y1fMvPtmRAu9P-IyYTpGnUbLD6XEyNmDWn6CbD1Xj72CgVrNx6I1kRIoQZMPSQJW9xaaC5oPExarB1DywMkeabi_8xlyKaRpPgwc/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="194" data-original-width="368" height="168" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTm_1yZIE6NBSVGtSEKUOFDBU-cKlBeopXoabmWU3y1fMvPtmRAu9P-IyYTpGnUbLD6XEyNmDWn6CbD1Xj72CgVrNx6I1kRIoQZMPSQJW9xaaC5oPExarB1DywMkeabi_8xlyKaRpPgwc/s320/8.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-3083496477765301" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="3392027289" style="display: block; text-align: center;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<div class="" style="clear: both;">
While the software provides several options, I chose the MSSQL default option:</div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipqlwD8Va5-ttsA-vd4sJPmvkJgz4trjwQuxU7R4IxwfKB04-u4Sv011715Q39p_EDzHxIN8Yt86iw1dAGLUgNM3WGGFgbUT32bSb1w75Dm0LTi6LDbfOn6Zwqwsw5bxNzfTJN1_xzdRA/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="220" data-original-width="496" height="141" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipqlwD8Va5-ttsA-vd4sJPmvkJgz4trjwQuxU7R4IxwfKB04-u4Sv011715Q39p_EDzHxIN8Yt86iw1dAGLUgNM3WGGFgbUT32bSb1w75Dm0LTi6LDbfOn6Zwqwsw5bxNzfTJN1_xzdRA/s320/9.png" width="320" /></a></div>
<br />
This option connects directly to your SQL Server and recreates the damaged database including the data itself. There is an option to create a new database or run the process live on an existing database. In my case I just needed a new database.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi86fDx5hshe7QqlxtBKdEXEUCZCRxk6081F9A7Mu2SvWTDHT4-aPpVeAQIFcs1upJfjoMWv1p-XtactrjCRmmhTxxwJU64t_Gk6HkueohN1zPJATqtsJ36uIbWUI9nL7iSrMzKJ_JHFjQ/s1600/Repair+Dialog.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="408" data-original-width="523" height="249" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi86fDx5hshe7QqlxtBKdEXEUCZCRxk6081F9A7Mu2SvWTDHT4-aPpVeAQIFcs1upJfjoMWv1p-XtactrjCRmmhTxxwJU64t_Gk6HkueohN1zPJATqtsJ36uIbWUI9nL7iSrMzKJ_JHFjQ/s320/Repair+Dialog.png" width="320" /></a></div>
<br />
It may be a good practice to create a new database to isolate things and not disrupt a live database, however, if the live database is corrupt it probably does not make a difference anyway.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2QzzENAB2kZ-iRBCRC-B38MieGn5sEAkCXHTL5OLXFZroO2xnxMP7l4pdFRU1Rf6Oh3gyr7GJHuCJIwVEV1Cehi1fBv-VQdb4t_52bs4tnGnp3Bv5byEXEykBkFYb1BqgaBAV6w4q1mo/s1600/10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="314" data-original-width="464" height="216" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2QzzENAB2kZ-iRBCRC-B38MieGn5sEAkCXHTL5OLXFZroO2xnxMP7l4pdFRU1Rf6Oh3gyr7GJHuCJIwVEV1Cehi1fBv-VQdb4t_52bs4tnGnp3Bv5byEXEykBkFYb1BqgaBAV6w4q1mo/s320/10.png" width="320" /></a></div>
<br />
As the save process runs, the Log Report window displays the progress of the database recreation which mainly involves the tables and their data. This process can be time consuming and is dependent on how much data is in the database. I noticed that the amount of columns in the table determined the performance of the recreation.<br />
<br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-3083496477765301" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="3392027289" style="display: block; text-align: center;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
Overall, I experienced the processing of 1000 rows in anywhere between 2-4 seconds. Tables with less than 10 columns were closer to the 2 seconds per thousand rows and tables with over 10 or 20 columns were processing closer to 4 seconds per thousand rows. Therefore, for average and planning sake, I would comfortably state that 3 seconds per 1000 rows is a good bet.<br />
<br />
Nonetheless, I would attempt to calculate an estimated time as it could elapse anywhere from 5 minutes to 50 minutes depending on your data. Users, help desk, management, etc. always like to understand how long things will take to correct and be brought back online.<br />
<br />
Once the save process is complete, a message box appears accordingly:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSdqdA-SjqRI70zmOCxS4NObWedIhqMuutug-byuF08aWAZtrq2_lN1IEmeGfNL0MKn4kcO-91a9jOFYCb06JGaVeJTJD4aUO0zC88YJEIKaenMxjOQ7Mm0UYdHn980yJdfOEQ7G161KU/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="176" data-original-width="422" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSdqdA-SjqRI70zmOCxS4NObWedIhqMuutug-byuF08aWAZtrq2_lN1IEmeGfNL0MKn4kcO-91a9jOFYCb06JGaVeJTJD4aUO0zC88YJEIKaenMxjOQ7Mm0UYdHn980yJdfOEQ7G161KU/s400/11.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="" style="clear: both; text-align: left;">
Navigating to the database server in SQL Management Studio yields a recovered database:</div>
<div class="" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1HYLMolPdMhU_DqMYIGNklAb-4XXmn8hl1z1Rk6Ae11KbYJ9YpmvXUAs-vEH0tpNEzhmhFvuyS4mYgexXomVXK6LGRWkjWVph4uIPkEpt2jB-2A5rpGEkuZ8SmF6TTg-ufX0_5M9O74A/s1600/12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="516" data-original-width="579" height="285" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1HYLMolPdMhU_DqMYIGNklAb-4XXmn8hl1z1Rk6Ae11KbYJ9YpmvXUAs-vEH0tpNEzhmhFvuyS4mYgexXomVXK6LGRWkjWVph4uIPkEpt2jB-2A5rpGEkuZ8SmF6TTg-ufX0_5M9O74A/s320/12.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
Overall I felt very confident in the repair of my MDF file using Stellar Phoenix Database Repair. I did not experience a live database corruption although it would be a similar scenario as the recommendation is to take the database offline and copy the MDF file to a different file system location.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Using a third-party tool such as Stellar Phoenix Database Repair streamlines a SQL Server disaster recovery scenario and takes the headaches of restoring backups and logs out of the mix. While there is always a chance of lost data or incomplete records, you need to do what's right and attempt for a 100% recovery; using Stellar Phoenix Database Repair will give you an edge!</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Here are my overall impressions (and witty words) of the software:</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<ul style="text-align: left;">
<li>Easy to use</li>
<li>Click and fix</li>
<li>Save/Recover like a charm</li>
<li>No-brainer compared to backup/restore processes</li>
<li>Easy peasy</li>
<li>Could save your day</li>
</ul>
<br />
<div>
<a href="https://www.stellarinfo.com/sql-recovery.php">A free download of this amazing repair software is available here.</a><br />
<br />
I have two videos that compliment this post as follows:<br />
<br />
<br /></div>
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/Hj_wZkSVPVY" width="480"></iframe>
<br />
<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/57kAX3GE62Q" width="480"></iframe>
</div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-31948578831090189932018-01-19T19:58:00.001-05:002018-01-19T20:01:17.987-05:00SQL Server: Error Attaching a Database - At Least One File Is Needed - RESOLVED<div dir="ltr" style="text-align: left;" trbidi="on">
If you receive an error as shown below:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQINOr1FPApKDyApWUWXpiu4ucDsKR5-WSYZbe5_y4kvfqLTzMNRC6BDYi9tR0gpCDoUdQ6nUJXxYfYqXfI3ArBDSiuFoVE-uS7JzN1cxq4VFT8xpInLd8fH4CHSz-ViNvOMME3gvb7J4/s1600/Screenshot+2018-01-19+18.25.39.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1366" height="356" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQINOr1FPApKDyApWUWXpiu4ucDsKR5-WSYZbe5_y4kvfqLTzMNRC6BDYi9tR0gpCDoUdQ6nUJXxYfYqXfI3ArBDSiuFoVE-uS7JzN1cxq4VFT8xpInLd8fH4CHSz-ViNvOMME3gvb7J4/s640/Screenshot+2018-01-19+18.25.39.png" width="640" /></a></div>
<br />
<br />
<br />
Watch this video to resolve. Essentially the file name must match the database name.<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/hmJdOjmAqQ8" width="480"></iframe></div>
Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-48599942233814536462018-01-18T21:44:00.001-05:002018-01-18T21:44:45.062-05:00CORTANA Weird Facts<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/B0jaPqPPerc" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-74402509854565956122018-01-18T21:35:00.001-05:002018-01-18T21:35:29.883-05:00Downloading and Installing 7Zip on Windows 10<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/INIocew4Vd0" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-44104919910593522492018-01-18T20:55:00.001-05:002018-01-18T20:55:53.713-05:00Downloading and Installing SQL Server 2017 Developer Edition w/Managemen...<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/MHqZs_aEM6g" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-52683051042057049862018-01-17T23:00:00.001-05:002018-01-17T23:00:40.082-05:00CORTANA Disgusting Facts<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/Dc3SfHCEqA4" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0tag:blogger.com,1999:blog-3323891144353318207.post-86753331245304410762018-01-17T08:14:00.001-05:002018-01-17T08:14:40.960-05:00Keeping Your Samsung Galaxy Device Optimized<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/tKGxtXi0Vi4" width="480"></iframe>Steve Mannhttp://www.blogger.com/profile/07380496759963407882noreply@blogger.com0