tag:blogger.com,1999:blog-83556069380366632172024-02-19T18:08:35.655-08:00Database Recovery Software | Database Diasaster Recovery SolutionsDatabase recovery for SQL, MySQL, Oracle, Access, SharePoint & FileMakerSam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.comBlogger74125tag:blogger.com,1999:blog-8355606938036663217.post-15498397534082265782015-04-21T23:54:00.001-07:002015-04-23T19:56:48.420-07:00Power of Compact & Repair <div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 115%;">In this blog we will see,
how “<b>Compact and Repair</b>” Command can
help to prevent and correct the problems that sometimes affect a database file.<o:p></o:p></span></div>
<div class="MsoNormal">
<b><span style="font-size: 12pt; line-height: 115%;">Why we use compact and repair command?</span></b></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 115%;">When we create a database
then, it occupies a certain amount of space in the memory. In this image
suppose blue circle is the full memory and red part shows the occupied memory by database.<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbI8suibhsq7RB1RfPes3GsvGbRqpDAES8Q4D8X_pRicJUAkYZdKTUsPx7gkk8uT_buU1vCEUKhk8sYpj8ezmiVsqK7RDL8kQIR7tKqvQKu48wduuI74H-qgm0JNtUahfp5mUNrrM3JGup/s1600/Picture1.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbI8suibhsq7RB1RfPes3GsvGbRqpDAES8Q4D8X_pRicJUAkYZdKTUsPx7gkk8uT_buU1vCEUKhk8sYpj8ezmiVsqK7RDL8kQIR7tKqvQKu48wduuI74H-qgm0JNtUahfp5mUNrrM3JGup/s1600/Picture1.gif" height="100" width="200" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">When we remove an object from the database then some amount of
memory occupied by the database will be free and when we add any new object in
the database then, the size of database file will be increase.Sometimes the
empty space cannot be accessed by the computer as shown in below image.<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQAE46qdqyOI3q3qFVFntzrNrsTJ3UXjWXQGKWsey-9ZCSFTG6TOnHs0CuSa5cjcc9PnMZuPf4bHy9XyepmxMIf8PeOD64e-wQi4_dekZ8pFWK0qujZEJZyudQn4Aqa3cLojCx7sztxfwJ/s1600/Picture2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQAE46qdqyOI3q3qFVFntzrNrsTJ3UXjWXQGKWsey-9ZCSFTG6TOnHs0CuSa5cjcc9PnMZuPf4bHy9XyepmxMIf8PeOD64e-wQi4_dekZ8pFWK0qujZEJZyudQn4Aqa3cLojCx7sztxfwJ/s1600/Picture2.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">In other words you can say the other applications cannot use
this memory space for their uses.To overcome from this situation we compact the
database. As you can see, space occupied by database is now lesser than
previously.<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKL3pvrFySUjm-UoEvF_XWvK0Clz9mwFBiUe5LTBl0-gD_2b8gT_mF5oL8y_2K_X3udyNRngvfL4sCrpepUO1nmvyei_37uBx4f5ehtsnS7_LPxnra0pditW0ObkCh__IAPXJF9LYnTcgV/s1600/Picture3.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKL3pvrFySUjm-UoEvF_XWvK0Clz9mwFBiUe5LTBl0-gD_2b8gT_mF5oL8y_2K_X3udyNRngvfL4sCrpepUO1nmvyei_37uBx4f5ehtsnS7_LPxnra0pditW0ObkCh__IAPXJF9LYnTcgV/s1600/Picture3.gif" height="100" width="200" /></a></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">After the execution of
this command the memory will be free for other resources.<o:p></o:p></span></div>
<div class="MsoNormal">
<!--EndFragment--></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Before
using this command, do these important things: </span></b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">If you are
going to use <b style="mso-bidi-font-weight: normal;">compact and repair command</b>
then you have to take care of the following things.<o:p></o:p></span></div>
<div class="MsoNormal">
</div>
<ol style="text-align: left;">
<li><b style="text-indent: -0.25in;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Take Backup:
</span></b><span style="font-size: 12pt; line-height: 115%; text-indent: -0.25in;">During repair process, MS Access may truncate some damaged data from the
table. Sometimes it is possible to recover this data from the updated backup.
If you use the database on the daily basis then, you should take the backup of
database according to your schedule. You can go on the <b>File</b> tab, click <b>Save & Publish </b>then
under <b>Advanced </b>option you will get
the option for <b>Back Up Database.</b></span></li>
<li><span style="line-height: 18.3999996185303px; text-indent: -0.25in;"><b>Automatically:</b> If your database is shared by other users on the network then you should set your database to automatically compact and repair.For this first go on <b>File </b>tab then, click on the <b>Options</b>. In the <b>Access Options </b>dialog box, click <b>Current Databas</b>e. Under the <b>Application Options</b>, select <b>Compact on Close</b> check box.</span></li>
<li><b style="line-height: 18.3999996185303px; text-indent: -0.25in;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Need to
know about system recovery errors table: </span></b><span style="font-size: 12pt; line-height: 115%; text-indent: -0.25in;">Any objects that cannot be
recovered in Access database repair process are noted in a table named <b>MSysCompactErrors. </b>We can see the
datasheet view of this table and determine which object you want to import from
the database backup into required database.</span></li>
<li><b style="font-size: 12pt; line-height: 115%; text-indent: -0.25in;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-font-size: 11.0pt; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><span style="font-size: 7pt; font-stretch: normal; font-weight: normal; line-height: normal;"> </span></span></b><b style="font-size: 12pt; line-height: 115%; text-indent: -0.25in;">Permission
to run this command: </b><span style="text-indent: -0.25in;"><span style="font-size: 12pt; line-height: 115%;">If you are using the earlier version of MS Access then,
you might be unable to compact and repair the database on your own. If you need
the sufficient permission for compact and repair your database. You can contact
your </span><span style="line-height: 18.3999996185303px;">work-group</span><span style="font-size: 12pt; line-height: 115%;"> administrator for assistance.</span></span></li>
</ol>
<div style="text-indent: -24px;">
<span style="line-height: 18.3999996185303px;"><br /></span></div>
<div class="MsoNormal">
From the second point it is clear that, we can also use the command <b>Compact & Repair</b> automatically. Now we will see how it works manually. you can run this command when your database is open or close. A shortcut for compact & repair command can also be created for a particular database.</div>
<div class="MsoNormal">
</div>
<ul style="text-align: left;">
<li><b style="text-indent: -0.25in;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">If database
is open: </span></b><span style="font-size: 12pt; line-height: 115%; text-indent: -0.25in;">In the following figure you can see the option of Compact
& Repair. If database is open then you can directly use this option.</span></li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEib6Q0oX7hQrF4P1Vfd10HbsVTN0g7ZWdyXH4M2xwCsdM_6k-MR3nnWG-6xYLetJB39ZeYx9nBMHbRZAdJi91SnApWD1TCKOc7lcAqJ-b7wZWf893xBYXi_BoNbsYlVzvuBK6TMZJ9o8eKj/s1600/Picture4.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEib6Q0oX7hQrF4P1Vfd10HbsVTN0g7ZWdyXH4M2xwCsdM_6k-MR3nnWG-6xYLetJB39ZeYx9nBMHbRZAdJi91SnApWD1TCKOc7lcAqJ-b7wZWf893xBYXi_BoNbsYlVzvuBK6TMZJ9o8eKj/s1600/Picture4.gif" height="385" width="640" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal">
</div>
<ul style="text-align: left;">
<li><b style="text-indent: -0.25in;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">If database
is close:</span></b><span style="font-size: 12pt; line-height: 115%; text-indent: -0.25in;">Start Access but do not open your database. Go to the <b>Info</b> option then, click on the Compact
& Repair. After this you will see the following dialog box and you can
select the database according to your choice</span><span style="font-size: 10pt; line-height: 115%; text-indent: -0.25in;">.</span></li>
</ul>
<span style="font-size: 13.3333330154419px; line-height: 15.3333320617676px;"></span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: 13.3333330154419px; line-height: 15.3333320617676px;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjijIBtvbVmyzKYy_v80yTPAJW_PGzvJ6fAMWPTpa7HivBzNoBs899XRhV6ST_5clEo1yV-kUfrr5hevLB6d8Jlwpeh6p-5EtO7qJdAtMZb2-7guLp69-C6Zt_mEH5P1kgWt_NN5IXQiZHD/s1600/Picture5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjijIBtvbVmyzKYy_v80yTPAJW_PGzvJ6fAMWPTpa7HivBzNoBs899XRhV6ST_5clEo1yV-kUfrr5hevLB6d8Jlwpeh6p-5EtO7qJdAtMZb2-7guLp69-C6Zt_mEH5P1kgWt_NN5IXQiZHD/s1600/Picture5.png" height="392" width="640" /></a></span></div>
<span style="font-size: 13.3333330154419px; line-height: 15.3333320617676px;">
</span></div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com2tag:blogger.com,1999:blog-8355606938036663217.post-59867857182556610562013-05-15T19:44:00.000-07:002013-05-15T19:45:22.121-07:00What is Guest Link feature in SharePoint Online 2013?<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
The Guest Link feature of SharePoint 2013 allows you to share individual documents, files and folders with out side users. You can invite people from outside your organization to collaborate and share documents. There are two ways to share documents, with or without creating user account. When you want to share individual document then you don't need to create an account but if you want to share a whole site then creation of account is necessary.<br />
<br />
Before sharing a document you need to know who are external or outside users. External user is that user to whom you grant access to your SharePoint Online site and who is not a member of your organization. Here I am describing External user rights:<br />
<br />
<b>What an external user can do?</b><br />
<ol style="text-align: left;">
<li>External users can can view and edit documents using Office Web Apps.</li>
<li>External users can see the contents of subsites also for which they are invited.</li>
<li>External users can use the rights of SharePoint Online customers who has invited them to collaborate on a site.</li>
</ol>
<b>What an external user can't do?</b><br />
<ol style="text-align: left;">
<li>External users are not allowed to create ID on MySite and SkyDrive Pro.</li>
<li>External users are not allowed to edit their own profiles.</li>
<li>External users are not allowed to see the company news feeds.</li>
<li>External users can't use Search service of SharePoint.</li>
<li>External users can't be an admin.</li>
</ol>
<b>How to share a site?</b><br />
To share a site you first need to send an invitation to the external user with whom you want to share your site. When that user accept your invitation, he can log in by using either Office 365 user ID or Microsoft account. You can also decide what type of permission you want to assign to the eternal user. For security purpose, create another site that you will use only for external sharing and also assign unique permission to this site. To share a site you need to have full permission of it. Follow below step to share a site:<br />
<ol style="text-align: left;">
<li>First make sure external sharing feature is turned on.</li>
<li>Now go to the site that you want to share and click Share.</li>
<li>Type the email id of the external user in the Share dialog box.</li>
<li>Type an invitation message.</li>
<li>You can also assign a group to the external user, for that click Show options and select the group.</li>
<li>Click Share.</li>
</ol>
Note: The invitation that you send to an external user is valid only for 7 days, after that it will expire. You need to resend the invitation if the user does not accept in 7 days.<br />
<br />
<b>How to share a document?</b><br />
There are two methods of sharing a document with external user one is by requiring a sign in and another by sending a guest link. To share a document you must have full permission of the site.<br />
<ol style="text-align: left;">
<li>Select the document that you want to share with external user.</li>
<li>Click the ellipses...and then go to Property dialog box and click Share.</li>
<li>Type the email ids of external user or users in share box.</li>
<li>Now assign the permission to external users. For example if you want the user to only view the document then select Can View.</li>
<li>Type an invitation message.</li>
</ol>
Perform one of the following task:<br />
<ul style="text-align: left;">
<li>If you want to invite user by sign in method to view or edit the document then select the Require sing-in checkbox.</li>
<li>If you want to invite user by sending a guest link to view or edit the document the clear the Require sign-in checkbox.</li>
</ul>
7. Click Share.<br />
<br />
<b>Best practices for sharing documents and sites</b><br />
<br />
When you share your whole site with external user then that user will become the member of the site. He will be able to view or edit the documents. If you share your team site with external user then he will be able to view the contents of team site including subsites. To prevent external user from gaining access to your confidential data you can create a subsite of your team site and create unique permission for external user.<br />
<br />
Be careful while sharing your documents using anonymous guest link because external user to whom you have send the invitation might share the link with others. So avoid sharing confidential data using links instead use sign in method.<br />
<br />
Although this is a great feature but you should also consider security requirement and sensitivity of information before sharing.</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-62327403171605773892013-05-09T01:40:00.000-07:002013-11-14T20:28:52.536-08:00How to repair damaged MyISAM tables?<div dir="ltr" style="text-align: left;" trbidi="on">
<title></title>
<style type="text/css">
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
A:link { so-language: zxx }
</style>
</div>
-->
<div lang="en-US" style="margin-bottom: 0cm;">
MyISAM tables in MySQL
becomes corrupted due to various reasons like hardware fault, sudden
system shutdown or server crash. Due to corruption you may lose all
your hard earned data. So it is important to deal with corruption
properly. First consider the symptoms of corrupt table:</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div lang="en-US" style="margin-bottom: 0cm;">
When MyISAM tables got
damaged its queries abort unexpectedly and following errors occur:</div>
<ol>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Can't find
table_name. MYI</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Record file is
crashed</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
table_name .frm is
locked against changes</div>
</li>
</ol>
<div style="margin-bottom: 0cm;">
<span lang="en-US">There are four steps
</span><span lang="en-US">to </span><a href="http://www.repair-mysql-database.com/" rel="nofollow" target="_blank"><span lang="en-US"><span style="font-weight: normal;">repaircorrupt MyISAM tables</span></span></a><span lang="en-US">. </span>
</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Note</b></span><span lang="en-US">:
Stop the MySQL server (mysqld) before repairing the tables.</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Step 1: Check
table: </b></span><span lang="en-US">Execute below command to check
table for corruption</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
myisamchk *.MYI</div>
<div lang="en-US" style="margin-bottom: 0cm;">
Or</div>
<div lang="en-US" style="margin-bottom: 0cm;">
myisamchk -e *.MYI
</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US">If above command
shows error then go to next step. </span><span lang="en-US">In case
myisamchk crashes while checking errors then go to step 3.</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Step 2: Easy safe
repair: </b></span><span lang="en-US">Execute below command to repair
the index file. This command will be able to repair your table only
if your data file is in working condition. </span>
</div>
<div lang="en-US" style="background: none repeat scroll 0% 0% rgb(192, 192, 192); margin-bottom: 0cm;">
Myisamchk
-r -q table_name</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div lang="en-US" style="margin-bottom: 0cm;">
If it fails to repair your
table then follows below steps</div>
<ol>
<li><div lang="en-US" style="margin-bottom: 0cm;">
First backup your
datafile.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Run below command to
remove incorrect and deleted rows from the datafile. This command
will also reconstruct the indexes.</div>
</li>
</ol>
<div lang="en-US" style="background: none repeat scroll 0% 0% rgb(192, 192, 192); margin-bottom: 0cm;">
Myisamchk
-r table_name</div>
<ol start="3">
<li><div lang="en-US" style="margin-bottom: 0cm;">
If command does not
repair your table then run below command. It uses safe recovery
mode.</div>
</li>
</ol>
<div lang="en-US" style="background: none repeat scroll 0% 0% rgb(192, 192, 192); margin-bottom: 0cm;">
Myisamchk
–safe -recover table_name</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Step 3: Difficult
repair: </b></span><span lang="en-US">Try this step only if your
index file contain wrong information or destroyed (16 KB block) or
index file is missing. You need to create a new index file. Follow
below steps:</span></div>
<ol>
<li><div lang="en-US" style="margin-bottom: 0cm;">
First move the data
file to a safe location.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Create new data and
index file. Here is how:</div>
</li>
</ol>
<div lang="en-US" style="margin-bottom: 0cm;">
shell> mysql
database_name</div>
<div lang="en-US" style="margin-bottom: 0cm;">
mysql> Set
autocommit=1;</div>
<div lang="en-US" style="margin-bottom: 0cm;">
mysql> TRUNCATE TABLE
table_name;</div>
<div lang="en-US" style="margin-bottom: 0cm;">
mysql> quit</div>
<div lang="en-US" style="margin-bottom: 0cm;">
Now copy the old data file
back into new datafile. Again try myisamchk -r -q command. It should
work now. You can also use REPAIR TABLE command.</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Step 4: Very
difficult repair: </b></span><span lang="en-US">Try this step only if
.frm description file has also got crashed. Usually this doesn't
happen. Follow below steps:</span></div>
<ol>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Restore your
description file from backup and go to step 3.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
If backup is not
available then create a copy of your corrupt table in another
database. Now move the .MYI index file and .frm description file to
crashed or corrupt database and also remove the new datafile. Now go
to step 2 and try to reconstruct index file.</div>
</li>
</ol>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-63491859801428992012013-04-24T21:15:00.000-07:002013-11-14T20:29:17.238-08:00How to recover SharePoint database when STSADM MergeContentDBs cause corruption<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
STSADM MergeContentDBs command allows users to move a site collection from one content database to another. You have to specify the source and destination parameter properly. In some situations, STSADM MergeContentDBs command fails to work properly and cause database corruption. Due to failure of this command both source and destination database may also got damaged. STSADM MergeContentDBs command fails when there is high load on SQL Server or high user traffic. When you run this command on database whose size is larger than 10GB then also there are high chances of database corruption.<br />
<br />
<b>Solution:</b><br />
To resolve the issue, keep following points in mind while using STSADM MergeContentDBs command:<br />
<ol style="text-align: left;">
<li>Make sure to backup the source and destination database before using the STSADM MergeContentDBs command</li>
<li>Do not cancel the operation in middle of server that is running SQL Server.</li>
<li>Since STSADM MergeContentDBs command put extra load on server that is running SQL Server so using it during non production hours.</li>
</ol>
The above steps are basically prevention steps that will help you in avoiding corruption when next time you use this command but if your database already got corrupted due to failure of STSADM MergeContentDBs command then you can try a good third party <a href="http://www.sharepointserverrecovery.com/" rel="nofollow" target="_blank">SharePoint recovery software</a>. There are many professional third party tools available online that can easily repair damaged SharePoint database and also provides free demo version.<br />
<div>
<br /></div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-21655704670167897682013-04-22T20:11:00.000-07:002013-04-22T20:11:14.440-07:00How to improve SharePoint performance?<div dir="ltr" style="text-align: left;" trbidi="on">
MS SharePoint has become the most popular product of Microsoft because so many organizations are adopting it. But the point of concern is that SharePoint performance is not that good because of heavy use of SQL Server database. There are many reasons behind SharePoint slow performance like incorrect configuration, BLOB storage issue, large media files and many more. Here are some tips on improving SharePoint performance.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJCAXsvxf4RT7f1JsITFy2ekeX4QXipC72yyH5Vhf06J-Rq9v75yXxba8aYHuUNEgVKAKoILcdYLJ-Q_jclQwT1iQWZA8Ie4Os8EGK4TzpzAsuYSPmLF3ef7raXGw7-xTOo9BGxfG4o907/s1600/images.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJCAXsvxf4RT7f1JsITFy2ekeX4QXipC72yyH5Vhf06J-Rq9v75yXxba8aYHuUNEgVKAKoILcdYLJ-Q_jclQwT1iQWZA8Ie4Os8EGK4TzpzAsuYSPmLF3ef7raXGw7-xTOo9BGxfG4o907/s1600/images.jpg" /></a></div>
<br />
<ol style="text-align: left;">
<li><b>Use different networks:</b> Since SharePoint require SQL Server for performing most of its job, this increases load on server. So you should use different physical network for SQL and front end server to separate the user and database traffic.</li>
<li><b>Reduce server load:</b> A server farm basically consists of front end server, index application and SQL Server. Index server is responsible for processing both search and user queries. It also increases load on index server. You should add one more server for retrieving the search queries.</li>
<li><b>SQL Server maintenance: </b>In order to improve the efficiency of read/write operations SQL server maintain its own indexes. Gradually these indexes got fragmented and degrade SharePoint performance. So it is important to perform SQL maintenance operations including index fragmentation.</li>
<li><b>Optimize server performance: </b>If there is heavy load on server then it will affect the performance of SharePoint. Make sure to follow the best practices for server as recommended by SharePoint engineering team.</li>
<li><b>Page customization: </b>Although SharePoint Designer is a great tool for administrators but page customization can decrease the performance of SharePoint. In page customization, every time a page request occurs, entire content including inline code is retrieved. So with thousands of page request, this back and forth of database degrade SharePoint performance. So to avoid this problem, it is administrator duty to use page customization only when it is necessary.</li>
<li><b>IIS compression:</b> You can reduce the payload of HTTP response by using IIS compression. This will reduce the data size that is send to the client, resulting shorter load time.</li>
</ol>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-73392580760877600992013-04-09T19:59:00.001-07:002013-04-09T19:59:50.123-07:00How Search has improved in SharePoint 2013?<div dir="ltr" style="text-align: left;" trbidi="on">
<title></title>
<style type="text/css">
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<br />
<div style="margin-bottom: 0cm;">
<span lang="en-US"><span style="font-weight: normal;">Search
feature has</span></span><span lang="en-US"> improved a lot in
SharePoint 2013. With people exploring tones of information daily, it
is critical to have a very fast search system. In previous version of
SharePoint, users struggled to find the desired information. To
overcome this issue some organizations even purchased </span><span lang="en-US"><b>Fast
Search application</b></span><span lang="en-US"> but this required
significant cost. Now you don't need to buy the expensive custom
search applications because Microsoft has improved search feature in
SharePoint 2013.</span></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9NYPiDTLrdxFP8U1rjmiAyEVrv9dfe2HRzaQyrs4Ls5SM_KfBj8guKsZo7xRCkytTPO3ZYUtOqwQvavCRI7POixHaC7Se3qUpvw_IHcJplR5DjO-Syk5sWPCVQRLTFxsFXnag_gyiNciW/s1600/images.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9NYPiDTLrdxFP8U1rjmiAyEVrv9dfe2HRzaQyrs4Ls5SM_KfBj8guKsZo7xRCkytTPO3ZYUtOqwQvavCRI7POixHaC7Se3qUpvw_IHcJplR5DjO-Syk5sWPCVQRLTFxsFXnag_gyiNciW/s1600/images.jpg" /></a></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><br /></span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Preview of
document:</b></span><span lang="en-US"> You can now see the preview
of your document by just putting the mouse over a search result
without opening the document. User can also scroll the entire
document in preview pane only. While in previous version of
SharePoint, to see the preview third party add-ons are required.
Users can also see how many times their document has been viewed. The
drawback is that only MS Office documents can be previewed. Still it
is an amazing feature for search users.</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Improved
refinements</b></span><span lang="en-US">: Refiner is like a filter
that helps user in filtering the result by certain criteria. Although
this feature is available in previous versions also but in SharePoint
2013 it is vastly improved. Microsoft has improved its usability by
providing a visual interface on the top of it. For example you can
set the criteria for date range using a slider instead of selecting
static option like “10-20 days”.</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Searching focused
on user:</b></span><span lang="en-US"> In SharePoint 2013 you can set
your own search preferences. SharePoint also provides you search
suggestion based on your behavior, favorite and previous search. User
can also see system generated search suggestions or choose to see
their searched query result. When you searched for a query Search
preference option also show you the previous document that you had
searched for. You can also delete your history and set the language
in which you want to see the result.</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Improved search
result: </b></span><span lang="en-US">Search result in SharePoint
2013 has improved drastically. New ranking models are introduced in
SharePoint 2013 which are used to determine which items in what
orders has displayed in search result. It also determines how
frequently an item appears in search result, which items are most
frequently searched in SharePoint. The main motive is to improve the
overall relevancy of search result.</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Search
availability: </b></span><span lang="en-US">This feature is added to
provide you with continuous availability of information. It will
also show any newly added item or document in search query as soon as
it is added in SharePoint.</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Build in search
options: </b></span><span lang="en-US">All the Fast search options
are build in SharePoint 2013 or you can say it has best of both
world’s i.e. SharePoint 2010 and FAST search. It improves the user
experience by providing faster search result.</span></div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-55253043529645376852013-04-04T21:23:00.000-07:002013-04-04T21:23:48.419-07:00Go Yammer with MS SharePoint 2013<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Microsoft has brought some great social networking features along with new SharePoint 2013 and now there will be one more update in social feature of SP 13 i.e Yammer. Recently Microsoft has reveled the news of integration of Yammer (enterprise social network service) with SP 13. Yammer was bought by Microsoft for $ 1.2 billion in June 2012. Microsoft has said that it will update the SharePoint newsfeed link feature with Yammer soon. Most of you might not know about Yammer. Here you will find some help about Yammer.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWTfunrJ1751mouPAVc5SJ8eWce6v8A9z0oY8SaFAEZWuI2ldaGgR4UtfxOqmpHQJxFcFd8hOx7bOeeb56fJr1idtWdemNlBHi5q8hPdwQqTj4ienrromYSRiWxmFmSIKu9BFEBPefzjSU/s1600/Sharepoint-und-Yammer.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWTfunrJ1751mouPAVc5SJ8eWce6v8A9z0oY8SaFAEZWuI2ldaGgR4UtfxOqmpHQJxFcFd8hOx7bOeeb56fJr1idtWdemNlBHi5q8hPdwQqTj4ienrromYSRiWxmFmSIKu9BFEBPefzjSU/s320/Sharepoint-und-Yammer.png" width="320" /></a></div>
<br />
<b>What is Yammer?</b><br />
Yammer is used for social networking purpose just like Facebook and Twitter but it is specially designed for company collaboration, knowledge exchange etc. The main difference between Yammer and other social networking sites is that in Yammer only those people that are in your network can see and take part in any activity that is going on in your network. You can access Yammer from anywhere and stay connected with your team member and exchange data.<br />
<br />
<b>Confusion: Yammer or Newsfeed?</b><br />
Almost every SP 13 user is asking this question, “What should I use for social networking now, Newsfeed or Yammer? The Microsoft expert has answered this question by saying “Go Yammer”. Consider some of the benefits that Yammer has brought:<br />
<ol style="text-align: left;">
<li>Yammer works really well on mobiles as it supports apps for iOS, Window devices and Android.</li>
<li>Provides great social experience.</li>
<li>Very fast in searching information.</li>
<li>Company wide collaboration.</li>
<li>It has anywhere access be it mobile, tablet, SharePoint apps or tablets.</li>
</ol>
Microsoft will also provide the proper guide for replacing the newsfeed with Yammer. Yammer is the future and it will provide you the best user experience ever said by SharePoint team.<br />
<br />
<b>Freedom of choosing</b><br />
Not everybody wants to go for Yammer. There are organizations who might not feel comfortable working with Yammer. Therefore Microsoft will be giving the option of choosing which tool they want to use.</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-11538018221855272292013-03-17T20:57:00.002-07:002013-03-18T23:08:49.047-07:00How to backup content database in SharePoint 2010?<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<title></title>
Regular backup of content database reduces the chance of data loss that might happen in case of disaster. Backup also ensure that all the data will be available for recovery in the event of disaster. There are three ways to backup a content database. Here I am describing all the three methods.<br />
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Note:</b> Only one content database can be backed up at a time.</div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Before backup, create a folder for storing the backup on your local computer and then move it to network folder.</div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Backup using Windows PowerShell</b></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
</div>
<ol>
<li>Go to Start-> All Programs-> MS SharePoint 2010 Products.</li>
<li>Now click Sharepoint 2010 Management Shell.</li>
<li>Type below command on Windows PowerShell command prompt</li>
</ol>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Backup-SPFarm -Directory <backup folder=""> -BackupMethod {Full | Differential} -Item <content database="" name=""> [-Verbose]</content></backup></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Backup using Central Administration</b></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
</div>
<ol>
<li>On the home page of Central Administration, go to Backup and Restore-> Perform a backup.</li>
<li>Now select Component to backup page and choose the database that you want to backup.</li>
<li>Click Next.</li>
<li>Go to Backup Type section-> Backup Option page-> Full or Differential backup (choose one).</li>
<li>Go to Backup File location section, give the path of backup folder and click Start Backup.</li>
</ol>
<br />
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Backup using SQL Server tools</b></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
</div>
<ol>
<li>Only the member of SQL Server db_backupoperator can perform this backup operation.</li>
<li>First open SQL Server Management Studio and connect it with server.</li>
<li>Go to Object Explorer-> expand Databases.</li>
<li>Right click your database (that you want to backup)-> Task-> Backup.</li>
<li>Now in the Backup database, go to Source Area and select which type of backup operation you want to perform.</li>
<li>Go to Backup Component-> Database.</li>
<li>Give the name for the backup.</li>
<li>You can also set expiration date for your backup. By default it is set to 0.</li>
<li>In the Destination, specify the location where you want to store the backup and click Ok.</li>
</ol>
<br /></div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-35292328746101094592013-03-14T03:24:00.000-07:002013-03-14T03:24:45.801-07:006 Things that you might not be aware about SharePoint <div dir="ltr" style="text-align: left;" trbidi="on">
<title></title>
<style type="text/css">
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<br />
<div lang="en-US" style="margin-bottom: 0cm;">
MS SharePoint is a complex
piece of software that has thousands of amazing features and it is
almost impossible to know each and every bit of it. So here are some
aspects of SharePoint that you may not be aware about:</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVOh-02VAWzMyAzR99mEkmURdVaxZ8Fb_qMCjhco-3TVNQwtzPDTna5kKptqzn3mOJXyyTarXuTh7e54gOrGIulghFJACcxeFQXw0cneymiKiMd8lZb5z8czem9ia48l8ktVF-vSj4stws/s1600/microsoft-sharepoint-logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="155" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVOh-02VAWzMyAzR99mEkmURdVaxZ8Fb_qMCjhco-3TVNQwtzPDTna5kKptqzn3mOJXyyTarXuTh7e54gOrGIulghFJACcxeFQXw0cneymiKiMd8lZb5z8czem9ia48l8ktVF-vSj4stws/s200/microsoft-sharepoint-logo.png" width="200" /></a></div>
<ol>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>SharePoint
is free: </b></span><span lang="en-US">Everybody out there might not
be aware of this fact that MS SharePoint Foundation version comes
free. Yes you heard it Right! It is absolutely free. No doubt free
versions have some limitations but it is good for beginners. It is
also good for IT companies with small budget. Low budget companies
should try their hands at it. Once they mastered the free version
then they can go for the paid one that has more advanced features.</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Work
offline:</b></span><span lang="en-US"> You can access your
SharePoint documents and files even also when you are offline. This
is possible with the help of SharePoint Workspace. It is a client
side application that helps in synchronizing offline and online
contents.</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Access
SharePoint with your smart phone: </b></span><span lang="en-US">In
today’s environment user want quick access of his information.
Therefore Microsoft has provided SharePoint facility on smart phone
also. User can now access his SharePoint information on his smart
phone by just typing web site url directly. Moreover Sharepoint
pages are now optimized for mobiles.</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>SharePoint
is easy to use:</b></span><span lang="en-US"> SharePoint has
integration with familiar Word, Excel, PowerPoint and other products
of Microsoft. So no training is required in using SharePoint.
Software should be easy to use even for a novice user otherwise no
one will buy it regardless of its amazing features.</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Alerts:</b></span><span lang="en-US">
Most users do not pay attention to alert feature of SharePoint.
Alert messages are used to notify or update a user about the latest
activity on SharePoint. User can easily subscribe to email or text
alerts to get the latest updates.</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Collaboration:</b></span><span lang="en-US">
One of the amazing features of SharePoint is that it allow user to
work simultaneously on Presentation or Word document. It saves lot
of time.</span></div>
</li>
</ol>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-20692721462979410632013-03-10T19:47:00.000-07:002013-03-10T19:47:58.988-07:00How social networking has improved in SharePoint 2013?<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Microsoft has done a brilliant job by enhancing SharePoint social networking features. SharePoint 2013 is completely a social animal. There are other features also that have improved in SharePoint 13 but major changes are in social networking. So today I am going to highlight new and improved social features of SharePoint 2013.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwxGa5JRp2CdPNJN6DLJBpENRXf4PveezHHg2ei_5jINAmc4g3oJLGqkCHnw1E76bfG3pQ7hrTaJoocg8pePgjBLxGpVhS-8fMhWuAkkZ-QbeKz7ZfKrc0pNS_XtpnfhREYxIlpW3BnpMc/s1600/images.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwxGa5JRp2CdPNJN6DLJBpENRXf4PveezHHg2ei_5jINAmc4g3oJLGqkCHnw1E76bfG3pQ7hrTaJoocg8pePgjBLxGpVhS-8fMhWuAkkZ-QbeKz7ZfKrc0pNS_XtpnfhREYxIlpW3BnpMc/s1600/images.jpg" /></a></div>
<br />
<b>Improvement in MySite: </b>The one standard feature in SharePoint is MySite which is just like Facebook. In this user can create his profile and also share any information publicly. In SharePoint 2013 this MySite feature has been improved. Following features of MySite are improved:<br />
<br />
<ul style="text-align: left;">
<li>Newsfeed: Using this feature you can stay upto date by following people, sites, document etc. You can see the activities of the people that you are following. Also you can like other people profiles and activities. Just like Facebook you can set your newsfeed status and one major improvement is that you can connect with people via tags like '@' and '#'.</li>
<li>SkyDrive Pro: SkyDrive Pro is a new feature of SharePoint 2013, earlier it was SkyDrive in SP 10. With SkyDrive Pro it becomes much easier to share documents. You can also sync your documents to your desktop so that even if you are in some remote location you still can access your documents with just one click.</li>
<li>Tasks: The Task feature is much improved in SP 13 because now all the tasks that are assigned to you are stored at one single place.</li>
<li>About Me: This feature is much simpler in SP 13. It contains user information.</li>
<li>Architecture: In SP 13 all the activities of user is controlled by privacy settings of user profile.</li>
<li>User Profile: User profile settings become much simpler in SP 13. You can easily set your profile visibility to 'Only Me' and 'Everyone' without doing complex visibility changes as in SP 10.</li>
</ul>
<br />
<b>Community Site:</b> Community site is just like forums where people can discuss topics of common interest. It is also there is SP 10 but in SP 13 this feature is improved. Firstly there is improvement in site template, second there is addition of category that allow you to choose category of discussion. Two more additions are also there one is Community members and another is Badges. Using this feature people can post questions, video, images, specify category, use hash tag, chooses best reply etc.<br />
<br />
<b>Workflow:</b> Workflow is much more improved in SharePoint 13. There is lot of improvement in terms of scalability and stability in Workflow. In SP 13 Workflow use 'Windows Azure Workflows', whereas in SP 10 it works on 'Windows Workflow Foundation 3.5'. Workflow feature enhancement includes Elastic scale, tracking and monitoring, managed service reliability and many more.<br />
<div>
<br /></div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-49153044919518511582013-03-07T19:05:00.000-08:002013-11-14T20:30:22.342-08:00InnoDB database: Backup & Recovery<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
The best way to prevent data loss in case of disaster is to maintain regular backups. You can choose your <a href="http://database-recovery-software.blogspot.in/2012/12/top-5-ways-to-backup-and-restore-mysql.html" rel="nofollow" target="_blank">backup strategy</a> depending upon database workload, business requirement and data volume. Here is some backup strategies for MySQL innodb database, you can choose any one that suits your business need.<br />
<br />
<b>Mysqlbackup command:</b> This command is a part of MySQL Enterprise Backup and allows you to backup innodb and myisam tables. It also provides a snapshot of database. You can perform read, write operation while performing backup of innodb tables. Using this command you can also perform online backup of innodb tables.<br />
<br />
<b>Cold Backup</b>: To perform cold backup you need to shutdown the MySQL Server. This is used to backup all the files of innodb. Follow below steps to perform backup:<br />
1.First shutdown your MySQL Server.<br />
2.Now copy all the innodb data files such as ibdata and ibd files to some safe location.<br />
3.Copy all the .frm to a safe location.<br />
4.Copy all the innodb log files to a safe location.<br />
5.Copy your configuration file i.e my.cnf to a safe location.<br />
<br />
<b>Mysqldump command: </b>Mysqldump is an effective backup tool to backup mysql database. It is used to dump a single database or multiple databases for backup. Mysqldump uses *.sql file to store all SQL statements. Using this command you can perform backup of local database and restore it on a remote database simultaneously.<br />
<br />
<b>To backup a single database:</b><br />
<span class="Apple-style-span" style="background-color: #999999;">mysqldump -u root -p[password] [database_name] > dumpfilename.sql</span><br />
<br />
<b>To backup multiple databases:</b><br />
<span class="Apple-style-span" style="background-color: #999999;">mysqldump -u root -p[password] - - databases [database_name1,database_name2] > dumpfilename.sql</span><br />
<br />
<b>To backup all the databases</b><br />
<span class="Apple-style-span" style="background-color: #999999;">mysqldump -u root -p[password] - - all- databases> /tmp/all-databasename.sql</span><br />
<br />
<b>Forcing innodb recovery:</b> Sometimes innodb background operations or Select statement got crashed due to corruption. In this case you can use innodb force recovery. This option will start innodb storage engine and also prevent background processes from running. In the meanwhile you can dump MySQL tables. Here is the syntax of command:<br />
[mysqldd] innodb_force_recovery = 4<br />
By default its value is 0. In case of 4 there is minimal data loss in case of corruption.<br />
<div>
<br /></div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-61824925854792061422013-02-27T00:46:00.000-08:002013-02-27T00:46:09.170-08:00How to Resolve SQL server error 5120: Access is Denied?<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div lang="en-US" style="margin-bottom: 0cm;">
At some situation, when a
database administrator tries to attach the SQL server database files
(.mdf, .ndf or .ldf) to the SQL server, he might get below error
message:</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<i>Unable to open physical
file "E:\BackEnd-accounts\GlDataSQL.mdf". Operating system
error 5: "5(access is denied.)". (Microsoft SQL Server:
Error 5120)</i></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<i><br /></i></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiF2klF0llr3rxrqxy-iiB_5boIjDTVrebEC40FXwDYyuBGylvyMmzcwRHuPXPsXNHrvtz1ZMBdt36AJwNq3FjJLLHiBQs7vm_j991y_etqV2JbeO8_9eobY56KdU5z5uNfqxm5i0TkLVO-/s1600/error-sql.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="107" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiF2klF0llr3rxrqxy-iiB_5boIjDTVrebEC40FXwDYyuBGylvyMmzcwRHuPXPsXNHrvtz1ZMBdt36AJwNq3FjJLLHiBQs7vm_j991y_etqV2JbeO8_9eobY56KdU5z5uNfqxm5i0TkLVO-/s320/error-sql.png" width="320" /></a></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Reason
behind above Error message</b></span><span lang="en-US">:
The main reason behind above error message is that the account from
which you are trying to attach the database files does not have
enough privilege for the specific files (.mdf, .ndf or .ldf).</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Troubleshoot
above Error message</b></span><span lang="en-US">:
You can troubleshoot above error message by providing the privilege
to the account from which your are trying to attach the files. You
can give the permission to the account by following:</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div lang="en-US" style="margin-bottom: 0cm;">
Run
below script to get service account.</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div lang="en-US" style="margin-bottom: 0cm;">
</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<span style="color: blue;">Code
Snippet</span></div>
<div style="margin-bottom: 0cm;">
<span style="color: blue;"><span lang="en-US">declare
@sqlser varchar</span></span><span style="color: black;"><span lang="en-US">(</span></span><span style="color: blue;"><span lang="en-US">20</span></span><span style="color: black;"><span lang="en-US">)</span></span></div>
<div style="margin-bottom: 0cm;">
<span style="color: blue;"><span lang="en-US">EXEC
master..xp_regread @rootkey</span></span><span style="color: black;"><span lang="en-US">=</span></span><span style="color: red;"><span lang="en-US">'HKEY_LOCAL_MACHINE'</span></span><span style="color: black;"><span lang="en-US">,</span></span><span style="color: blue;"><span lang="en-US">
@key</span></span><span style="color: black;"><span lang="en-US">='</span></span><span style="color: red;"><span lang="en-US">SYSTEM\CurrentControlSet\Services\MSSQLSERVER'</span></span><span style="color: black;"><span lang="en-US">,</span></span></div>
<div style="margin-bottom: 0cm;">
<span style="color: blue;"><span lang="en-US">@value_name</span></span><span style="color: black;"><span lang="en-US">=</span></span><span style="color: red;"><span lang="en-US">'objectname'</span></span><span style="color: black;"><span lang="en-US">,</span></span><span style="color: blue;"><span lang="en-US">
@value</span></span><span style="color: black;"><span lang="en-US">=</span></span><span style="color: blue;"><span lang="en-US">@sqlser
OUTPUT</span></span></div>
<div style="margin-bottom: 0cm;">
<span style="color: blue;"><span lang="en-US">PRINT
</span></span><span style="color: red;"><span lang="en-US">'Account
Starting SQL Server Service:'</span></span><span style="color: blue;"><span lang="en-US">
</span></span><span style="color: magenta;"><span lang="en-US">+convert</span></span><span style="color: blue;"><span lang="en-US">(varchar(30),@sqlser)</span></span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div lang="en-US" style="margin-bottom: 0cm;">
Now
you can provide privilege to the account by following steps:</div>
<ol>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US">Press
</span><span lang="en-US"><b>right
</b></span><span lang="en-US">button
of your mouse on the folder </span><span lang="en-US"><b>E:\BackEnd-accounts</b></span><span lang="en-US">.
</span>
</div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US">Now
click on </span><span lang="en-US"><b>properties</b></span><span lang="en-US">
section and select </span><span lang="en-US"><b>security</b></span><span lang="en-US">
tab.</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US">Now
click on </span><span lang="en-US"><b>Add</b></span><span lang="en-US">
button to add a SQL service account.</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Modify</b></span><span lang="en-US">
privilege setting and click </span><span lang="en-US"><b>OK</b></span><span lang="en-US">
button</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US">Make
sure all the files have </span><span lang="en-US"><b>modify
privilege</b></span><span lang="en-US">.</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US">Now
try to </span><span lang="en-US"><b>attach</b></span><span lang="en-US">
the database files.</span></div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Done</div>
</li>
</ol>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>For
Example</b></span><span lang="en-US">:
In my case, I have given the right to the local administrator and
problem was solved. For your reference I am attaching an image
below.</span></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-mO27QPUlTczJlSI7RiojkABdz2lePAE5KT-SRbC0WZdGY_Ghb2LGltB8Fe97CzRmKtcyos0iUE69QGfIfXP3HKWH4miFy3RH5RV_5hZEoUYEuHfE_tTSQfQNDmGj1AzHaAEkdqHA0dew/s1600/security+permission.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-mO27QPUlTczJlSI7RiojkABdz2lePAE5KT-SRbC0WZdGY_Ghb2LGltB8Fe97CzRmKtcyos0iUE69QGfIfXP3HKWH4miFy3RH5RV_5hZEoUYEuHfE_tTSQfQNDmGj1AzHaAEkdqHA0dew/s1600/security+permission.png" /></a></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><br /></span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div lang="en-US" style="margin-bottom: 0cm;">
</div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com1tag:blogger.com,1999:blog-8355606938036663217.post-86059083262921715192013-02-26T21:52:00.001-08:002013-02-26T21:52:34.927-08:00How secure your SharePoint is?<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Today more and more organizations are adopting MS SharePoint to manage and share their sensitive business data, to collaborate among employees and to satisfy their business needs. With so much confidential information moving to SharePoint, security of that information is also very important. If your information or data is not even safe in SharePoint then what is the point of using it. Read this article to know how you can make SharePoint a safer place for your data.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjv9LlYVBL7yOyvgLBllulkC8ZLzOSnpcJ3t6yC8dT1PpInj3RGJpJgc6_JPNCbodUAFEgOnlKHPIh6N_sLYSBi2-PDGGw2HMaOD0_dLZVEjUUsjsNP-BrWGd2qv0EYPv10Q4Z5fPTYSRTO/s1600/microsoft-sharepoint-logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjv9LlYVBL7yOyvgLBllulkC8ZLzOSnpcJ3t6yC8dT1PpInj3RGJpJgc6_JPNCbodUAFEgOnlKHPIh6N_sLYSBi2-PDGGw2HMaOD0_dLZVEjUUsjsNP-BrWGd2qv0EYPv10Q4Z5fPTYSRTO/s320/microsoft-sharepoint-logo.png" width="320" /></a></div>
<br />
<ol style="text-align: left;">
<li><b>SharePoint access right: </b>Do you keep track of who all are accessing your confidential data? It is very important to know which user and group are accessing what data. Some organizations have assigned administrator authority to too many people and this creates security threat. Assign administrative authority only to responsible people who can handle SharePoint infrastructure. Permission and access right should be assigned properly to each user. Without a clear indication of how permission management works in your organization, it would be quite difficult for you to secure your data.</li>
<li><b>Farm security:</b> A SharePoint farm contains all type of server like database server, application server that works together to provide services to user. So the security of SharePoint farm should be your top priority. Since farm admin has all the rights to manage web applications, backing and restoring farm so be very careful while granting such level of authority.</li>
<li><b>Sharing policy:</b> A recent survey has shown that 45 % users regularly copy the confidential data of company from SharePoint to their pen drive, hard disk or to mail. And this data is being shared with people who don't have access rights to SharePoint data. So strict policies should be made to clearly define how and with whom information can be shared.</li>
<li><b>Server security:</b> SharePoint is a complex piece of software; consist of Windows, IIS, AD and SQL Server. Security issue with any of them can be disastrous for your SharePoint. Similarly security of SharePoint server is also very important and so unavoidable. Patching is important tool for the security of SQL Server but make sure it won't affect SharePoint performance. Also install server antivirus and firewall to protect server from attackers.</li>
<li><b>Anonymous access:</b> Don't allow anonymous access as it allows non authenticated user to access a SharePoint web application.</li>
<li><b>Keep an eye on employee’s activity:</b> Keep record of every information that is being accessed and shared through SharePoint. Sometime employees share confidential information with your competitors which is the biggest security threat for your organization.</li>
</ol>
<br />
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-2376157640620673212013-02-21T19:12:00.000-08:002013-02-21T19:13:39.926-08:00How to perform Granular backup & restore in SharePoint 2010<div dir="ltr" style="text-align: left;" trbidi="on">
<span lang="en-US">In SharePoint 2007
you can perform granular backup through stsadm command </span><span lang="en-US">only
while in SharePoint 2010 it can be performed through stsadm command,
Central Administrator and PowerShell. </span><br />
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Perform Granular
</b></span><span lang="en-US"><b>Backup of site collection using
stsadm command</b></span><span lang="en-US"> </span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<span style="background: #808080;">stsadm
-o backup -url < url of site collection> filename <backp file="" name=""></backp></span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Restore Granular
</b></span><span lang="en-US"><b>Backup of site collection using
stsadm command</b></span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<b><span style="background: #808080;">stsadm
-o restore -url < url of site collection> filename <backp file="" name=""></backp></span></b></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Perform Granular
</b></span><span lang="en-US"><b>Backup of site collection using
Central Administrator </b></span></div>
<ol>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Go to Central
Administrator-> Backup & Restore-> Granular Backup.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Click on Perform a
site collection backup.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Select the desired
site collection and give the destination where you want to save your
backup file.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Now click on 'Start
Backup'.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
You can see the
status of the current backup operation on the Granular Backup Job
Status screen. </div>
</li>
</ol>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Restore Granular
</b></span><span lang="en-US"><b>Backup of site collection using
Central Administrator </b></span></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US">You can't perform
granular restore of site collection because </span><span lang="en-US">there
is no such option in Central Administrator.</span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Perform Granular
</b></span><span lang="en-US"><b>Backup of site collection using
Windows PowerShell</b></span></div>
<ol>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Go to Start-> All
Programs-> MS SharePoint 2010 Products.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Now click SharePoint
2010 Management Shell.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Type the below
command on Windows PowerShell command prompt</div>
</li>
</ol>
<div lang="en-US" style="margin-bottom: 0cm;">
Backup -SPSite -Identity
<site collection="" name=""> -Path <backup file=""> [-Force]
[-NoSiteLock] [-UseSqlSnapshot] [-Verbose]</backup></site></div>
<div lang="en-US" style="margin-bottom: 0cm;">
-Force: It is used to
overwrite a backup</div>
<div lang="en-US" style="margin-bottom: 0cm;">
-NoSiteLock: It is used to
prevent site collection from going in to read only mode.</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Restore Granular
</b></span><span lang="en-US"><b>Backup of site collection using
Windows PowerShell</b></span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<span style="color: black;"><span style="background: #808080;">restore
-spsite -Path <backup file=""> [-Force]</backup></span></span></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div lang="en-US" style="margin-bottom: 0cm;">
<span style="background: #ffffff;">
</span></div>
<br />
<div>
<br /></div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-17553705433379048922013-02-20T22:10:00.000-08:002013-02-20T22:11:11.338-08:00How to troubleshoot “Access Denied” error in MS SharePoint Server 2007?<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
Recently my
friend had faced a very strange problem while working on SharePoint.
Whenever he tried to access his site an “Access Denied” error
message pop ups on his computer screen. Let's discuss the cause and
solution of this error. This error might occurs if a user does not
have required permission to access a site, blog, list, document etc.
To resolve this error a user needs to check the permission in
following way.</div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Solution:</b> Check
all the permission in the following manner:</div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Check direct
permissions: </b>There are two ways of granting permission to user one is
direct permission and another is group permission.</div>
<ol>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
In the
homepage, go to Site Actions-> Site Settings.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Now go to
Advanced Permissions and check if you have permission here.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
If you
don't have permission then go to next step.</div>
</li>
</ol>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Check group
permissions: </b>You can create groups with permission by adding other
users and granting the same permission to them.</div>
<ol>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
In the
homepage, go to Site Actions-> Site Settings.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Go to
People and Groups.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
You can
check all groups on the top left of site.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Now check
each group to find who all are member of this site.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
If you are
also listed in the group then you have permission, if not then you
don't have permission.</div>
</li>
</ol>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Add permissions</b></div>
<ol>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Go to Site
Settings-> Advanced Permissions-> Site permissions</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Click the
group name-> New-> Add User.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
This will
allow administrator to add user to a group or create a new group.</div>
</li>
</ol>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Remove
permissions</b></div>
<ol>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Go to Site
Settings-> Advanced Permissions-> Site Permissions</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Click
select a user(s)-> Actions-> Remove User Permissions.</div>
</li>
</ol>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Check group
permissions:</b> If you are a part of some group but still can't access
site that means you don't have permission to access the site.</div>
<ol>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
In the
homepage, go to Site Actions-> Site Settings.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Go to
Users and Permissions-> People and Groups.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Select the
group which you are member of.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Go to
Settings -> Group Settings.</div>
</li>
</ol>
<div align="LEFT" style="margin-bottom: 0cm;">
<br /></div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<br />
<div style="font-weight: bold;">
<br /></div>
<div style="font-weight: bold;">
<br /></div>
<br /></div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-86326736382171225212013-02-20T22:05:00.000-08:002013-11-14T20:31:01.766-08:00SharePoint 2010 Backup & Recovery Best Practices<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
It is important to backup
your data to prevent data loss in case of disaster. <a href="http://database-recovery-software.blogspot.in/2013/02/how-to-perform-granular-backup-restore.html" rel="nofollow" target="_blank">Backup and recovery </a>process consumes system resources and sometime slow down the
performance of database. In order to prevent database from slowing
down and to reduce usage of resources you just need to follow some
simple tips. Here are the best practices for SharePoint 2010 backup
and recovery.</div>
<div lang="en-US" style="margin-bottom: 0cm;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA_6UJ0abBkYeB0Gwz343SPtHa85QmCmwJapebxTaoQG09i31i4_7dBI5cJUIMAN6lMUKAm3ehPJagxSOPSdHt9x7GsOm-6hhrG0aE17gd5XXdDu_lWPftXmwk80hqOkfd8VRFL5_ve3Zd/s1600/backup.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA_6UJ0abBkYeB0Gwz343SPtHa85QmCmwJapebxTaoQG09i31i4_7dBI5cJUIMAN6lMUKAm3ehPJagxSOPSdHt9x7GsOm-6hhrG0aE17gd5XXdDu_lWPftXmwk80hqOkfd8VRFL5_ve3Zd/s1600/backup.png" /></a></div>
<ol>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Always backup your
data on a local disk and then copy it to network folder.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Don't perform backup
operation on the same disk on which MS SQL Server 2008 SP1 is
running.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Perform backup when
database is in offline mode.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Instead of having one
large database, keep two or more smaller databases. It will speed up
the backup and recovery process.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
If you have very
large and complex database then use incremental backup. Incremental
backups are much faster than full backups.
</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
You can also reduce
the size of your large backup using backup compression technique.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
To increase the
performance of backup and restore you can change configuration
settings in Windows PowerShell and Central Administration.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
By default SP 2010
compress files while exporting site collections, document libraries
or lists. File compression consume more resources and slow down the
performance of Sharepoint. So you can set the NoFileCompression
parameter in Windows PowerShell. </div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
In SharePoint 2010,
by default a log file is created whenever you export contents. You
can use NoLogFile parameter to save resources.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
If you are using both
database level backup and farm level backup then choose the tool
according to the size of site collection:</div>
</li>
</ol>
<ul>
<ul>
<li><div lang="en-US" style="margin-bottom: 0cm;">
If site collection
size is less than 15 GB then use Backup -SPSite of Windows
PowerShell.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
If site collection
size is 15-100 GB then use either a SQL Server tool or any database
backup tool.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
If site collection
size is larger than 100 GB then use differential backup.</div>
</li>
</ul>
</ul>
<ol start="11">
<li><div lang="en-US" style="margin-bottom: 0cm;">
Make sure you have
enough disk space to store the backup.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Test consistency of
backups regularly.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
To prevent data loss
in case of natural calamities, store the duplicate copy of backup at
some different location from server.</div>
</li>
</ol>
<br /></div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-77195142614943543862013-02-14T20:15:00.000-08:002013-02-14T20:15:04.687-08:00Top 5 best practices for MySQL users<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
MySQL is very complex and vast piece of software, so it is quite difficult to know every thing about it. But as a MySQL user you should be aware about the best practices that can help in the security, performance and maintenance of database. Here I am describing the top 5 practices that every user should know.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1_eSlngfbO-kWrFT3aWBRqsDCuu528sCN4SfyWO6oO1jOdxK6NPIEm5_El0UzgAlvxCJoQMv4q5fZ5cv_VTZsYgIQSGYAok9-LTG6A3mF2tEt-cNrEsbZWUDpeahnm3C_q6b5A1FxFnbz/s1600/mysql.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1_eSlngfbO-kWrFT3aWBRqsDCuu528sCN4SfyWO6oO1jOdxK6NPIEm5_El0UzgAlvxCJoQMv4q5fZ5cv_VTZsYgIQSGYAok9-LTG6A3mF2tEt-cNrEsbZWUDpeahnm3C_q6b5A1FxFnbz/s320/mysql.gif" width="320" /></a></div>
<br />
<ol>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Set
Password: </b></span><span lang="en-US">At the time of installation
of MySQL you need to set the username for the user as 'root'. Most
users don't change the username even after installation of MySQL and
this creates security threat. So the first thing that you should do
to prevent your data from hackers is to rename the username and give
a complex password.</span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Security
guidelines: </b></span><span lang="en-US">Keep in mind following
basic security guidelines:</span></div>
</li>
</ol>
<ul>
<ul>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Since the passwords
of all the users are stored in mysql user table, so never grant its
access to any administrative account.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
PROCESS or SUPER
privilege should be given only to administrative users.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Similarly FILE
privilege should also be given only to administrative users. With
FILE privilege user can read any file that is readable from the
database and this is a big security threat.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Lower the permission
given to other mysql users like developer, tester, sysadmin etc.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Make sure that only
the 'root' and 'mysql' user can access the /var/lib/mysql
directory.</div>
</li>
</ul>
</ul>
<ol start="3">
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Server
Security: </b></span><span lang="en-US">Anybody can hack your server
if given physical access of system. Therefore it is recommended that
your application and database server should be on different machine.
Consider following security measures:</span></div>
</li>
</ol>
<ul>
<ul>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Antivirus and
antispam should be installed on your system.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Protect your OS with
firewall.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Server physical
location must also be safe.</div>
</li>
<li><div lang="en-US" style="margin-bottom: 0cm;">
Disable the services
that are not required.</div>
</li>
</ul>
</ul>
<ol start="4">
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Protect
MySQL installation directory: </b></span><span lang="en-US">MySQL
data directory should be accessible only to MySQL. Even DBA is not
allowed in a 'mysql' group. </span></div>
</li>
<li><div style="margin-bottom: 0cm;">
<span lang="en-US"><b>Disable
remote access: </b></span><span lang="en-US">If your database is
accessed remotely then make sure that only defined hosts are able to
access your server. To restrict remote access you can TCP wrappers,
firewall or other software’s available in market.</span></div>
</li>
</ol>
<div align="CENTER" lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div style="margin-bottom: 0cm;">
<br />
</div>
<br />
<div>
<br /></div>
<br />
<br />
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-34564276609653426332013-02-07T18:43:00.000-08:002013-02-07T19:18:11.352-08:00Is it worth upgrading to SharePoint 2013?<div dir="ltr" style="text-align: left;" trbidi="on">
There is so much confusing among SharePoint users about whether they should upgrade to the latest version or not. It is obvious to get confused when a newer version comes with so many new and enhanced features. Most people rush to upgrade Technology without even considering the benefits and limitation of it. Before you upgrade to new technology always ask yourself “Does it help my business?” Because at the end of the day the ultimate goal of you business is to increase the productivity. So here I have listed SharePoint 2013 features that will help in improving the productivity of your business.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXQcGIW77vg6OzR4WGDImCsYupqGhcNRsj9S1VtYYDMD8XQ4bwSSuejcV0UCocCH8In5OTIyxE847dp98J2_-YYZ1vyXgUpFxpjuy67f7Z1aIfsnz0b-splmACOR2ibtlMlR2GoWelL9f4/s1600/sharepoint+2013.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXQcGIW77vg6OzR4WGDImCsYupqGhcNRsj9S1VtYYDMD8XQ4bwSSuejcV0UCocCH8In5OTIyxE847dp98J2_-YYZ1vyXgUpFxpjuy67f7Z1aIfsnz0b-splmACOR2ibtlMlR2GoWelL9f4/s1600/sharepoint+2013.jpg" /></a></div>
<br />
<b>Social Enhancements: </b>There is so much improvement in social features of SharePoint. Some of the awesome features are micro blogs, news feed, community sites, Likes, Follow etc. Now you can follow people, documents, sites and stay updated about activities of your colleagues. SharePoint has also added forums, where you can discuss any topic with other people of your organization.<br />
<br />
<b>Designer Manager: </b>SharePoint has added an entirely new feature that allows you to easily design your website. You can create different master page for each channel. Using designer manager you can easily manage master pages, templates, Composed Looks etc. You can even create your page in Dreamviewer and upload it to SharePoint. Designer Manager also allows you to create master pages for different channels like iphone, ipad etc.<br />
<br />
<b>Document Management:</b> Sharepoint 2013 has provided many features to reduce the complexity of managing documents. You can easily perform any task by just drag & drop. Some of its features include:<br />
<br />
<ul style="text-align: left;">
<li>You can simply drag and drop your files into document library.</li>
<li>It allows sharing of documents much easier by identifying with whom the document is being shared.</li>
<li>Show preview of Office documents.</li>
</ul>
<br />
<b>Simplified storage of documents:</b> In SharePoint all the documents are stored in MySite instead of any local storage area. So it is easy to share document with other people. Although this feature is also available in previous version of SharePoint but in SharePoint 2013 it is much easier to save documents in MySite. In fact MySite is the default location for storing documents in SP 13. And the best part is that you can access your documents from MySite, even when the server is unavailable.<br />
<br />
<b>Fast Search: </b>Search is the most important part of Sharepoint. In SP 13, Microsoft has incorporated the fastest search engines. Some of the features include:<br />
<br />
<ul style="text-align: left;">
<li>You can easily search newsfeeds and videos.</li>
<li>Your contents get update continuously because of fast crawlers.</li>
<li>PDF support on indexing.</li>
</ul>
So now I hope you can easily decide that whether you should upgrade to SharePoint 2013 or not.<br />
<br /></div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-55697184043982713012013-01-30T02:04:00.000-08:002013-02-07T19:35:07.844-08:00Oracle: Recovery Types<div dir="ltr" style="text-align: left;" trbidi="on">
Oracle recovery refers to the process of restoring a physical backup with all the changes that have been made to the database since the last backup. The main purpose of recovery is to prevent data loss after corruption or any other disaster. There are four types of recovery in Oracle:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqmU2RaHabkuGlcxaZPZ0DMGOhuDnd72IPWy3RIOtkWElfPdOOgBemP7rvs3kxiXXQiKsM8Qr4JVhXMGH68ULQkAZbJGgbLikBt40lgYirXvVVbxzZ9sC0zINKRw4T2IrSIvwCNLbc5b9T/s1600/oracle+recovery.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqmU2RaHabkuGlcxaZPZ0DMGOhuDnd72IPWy3RIOtkWElfPdOOgBemP7rvs3kxiXXQiKsM8Qr4JVhXMGH68ULQkAZbJGgbLikBt40lgYirXvVVbxzZ9sC0zINKRw4T2IrSIvwCNLbc5b9T/s1600/oracle+recovery.jpg" /></a></div>
<br />
<b>Instance Recovery:</b> Instance recovery is performed in Oracle Real Application when database server crashes. The two most common reasons of database crash is power failure or abnormal termination of system. Instance recovery is an automatic process performed by surviving instance to recover data that was lost due to database server instance failure. Instance recovery is performed in the case of failure of single instance.<br />
<b>Crash Recovery:</b> It is performed when Oracle database is started first time after the crash. The main motive of crash recovery is to bring the database back to its consistent state by preserving the committed transactions. Online datafile and redo log files are used to save the changes upto the moment of failure.<br />
<b>Media recovery:</b> It is performed in response to media failure. It recovers damaged tablespaces, datafiles and control files. Database should be in offline mode while performing media recovery. You cannot open a datafile before the completion of media recovery. There are two types of media recovery:<br />
<br />
1. Complete Recovery: In complete recovery whole database is recovered without any loss of data. It recovers database to the recent point in time. There is no loss of committed transactions.<br />
2. Incomplete Recovery: It is also known as point-in-time recovery. It has following recovery options:<br />
<br />
<ul style="text-align: left;">
<li> Tablespace point-in-time recovery: It allows user to recover any number of tablespaces to point-in-time.</li>
<li>Point-in-time recovery: It allows user to recover database upto a specified point-in-time.</li>
<li>Cancel-based Recovery: It stops recovery as soon as you issue Cancel command.</li>
</ul>
<br />
<b>Block Media Recovery: </b>It is performed to recover one or more damaged data block. Whole database remain online during recovery except the affected blocks. Perform block media recovery only for those blocks that have been marked corrupted.</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-75065483954824519772013-01-29T02:32:00.000-08:002013-02-07T19:24:32.634-08:00Recover data from corrupt SharePoint databse with Stellar Phoenix SharePoint Recovery<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
If you are using SharePoint for storing and sharing your data then I hope that you must be aware of the importance of data. What will you do if your SharePoint database suddenly got corrupt? Most probably, you will try to restore your data from backup. But wait, what if the backup is also not available? Don't stress there is still a way out. You can repair & restore your data by using an ultimate third party tool named Stellar Phoenix SharePoint Server Recovery. It repairs corrupt database and create a new mdf file.<br />
<br />
<b>Features:</b><br />
<ul style="text-align: left;">
<li>Repairs damaged SQL database:<b> </b>Since SharePoint store all the documents, lists and site collection in SQL database so if it got damaged, your website may become inaccessible. Stellar Phoenix Server recovery software fixes all the corruption and create a new mdf file. You can then incorporate repaired mdf file in to SharePoint server.</li>
<li>Search option: If you forgot the location of your damaged mdf file then you can search for it in all the folders and drives using software 'Search' option.</li>
<li>Complete Recovery: This option is use to repair damaged database. It scan the database for damaged tables and then repair them. The repaired table will be saved in a new mdf file.</li>
<li>Document Recovery: Using this option you can recover all your website contents like wiki, blogs, documents etc. </li>
<li>Display Preview: After scanning, you can see the preview of all the recoverable items.</li>
<li>Generate Log Report: This software create log of all the activities performed during repair process. You can save the log report for future reference.</li>
<li>Attach file option: After the completion of recovery process you can attach your repair database file back to server.</li>
<li>SharePoint software support<b>:</b> Supports recovery of SharePoint 2010 & 2007.</li>
</ul>
<br />
<b>Steps to repair corrupt SharePoint database:</b><br />
<b><br /></b>
1. After installing the software click on '<b>Complete Repair</b>' option.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ7oVRzkS1zHYMliqEqSAKwK64QBSx0FDpIMUvCiOvq99lhilPCe2A59DTIPfY7lFveH203V83Nzp9d1zL2PupZKOIel75gTI5I0jJcrPdWetT0OVy0RvdnjPH5HBEBpuQxgz1VbcOUPYe/s1600/1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ7oVRzkS1zHYMliqEqSAKwK64QBSx0FDpIMUvCiOvq99lhilPCe2A59DTIPfY7lFveH203V83Nzp9d1zL2PupZKOIel75gTI5I0jJcrPdWetT0OVy0RvdnjPH5HBEBpuQxgz1VbcOUPYe/s320/1.bmp" width="320" /></a></div>
<br />
2. Click on '<b>Select File</b>' button to select corrupt mdf file.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbL3RuMsC4mYJ3_sHVOznRFXJOwROtRLAxsbL-0AAMAnEznUOWi2lv3Vt22K2SkPUhn8UL8C9qoA6cxwkdIv0cHx-X29s8RQDRXwf6X7Og8hnjFQInq0blP6xoVGSqrhV_DprTbVBDTTg6/s1600/2.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbL3RuMsC4mYJ3_sHVOznRFXJOwROtRLAxsbL-0AAMAnEznUOWi2lv3Vt22K2SkPUhn8UL8C9qoA6cxwkdIv0cHx-X29s8RQDRXwf6X7Og8hnjFQInq0blP6xoVGSqrhV_DprTbVBDTTg6/s320/2.bmp" width="320" /></a></div>
<br />
3. Now scan the file by clicking on '<b>Scan File</b>' button.<br />
4. After scanning, you can <b>see the preview</b> of all repairable objects.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQW1-cZb5FfXNRSxNFaSOigP6VE1oEMWFHgRIKk2tIKiQdXtak7dDSFiYWybGTGoMW0t-vBvP5MXyBaLUB-DXOWccbgk8t8bzZqwc0x0GQ3vmljgs6prxMMhPXUWGgNJUqFC6Ep_SiSvhX/s1600/3-1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="237" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQW1-cZb5FfXNRSxNFaSOigP6VE1oEMWFHgRIKk2tIKiQdXtak7dDSFiYWybGTGoMW0t-vBvP5MXyBaLUB-DXOWccbgk8t8bzZqwc0x0GQ3vmljgs6prxMMhPXUWGgNJUqFC6Ep_SiSvhX/s320/3-1.bmp" width="320" /></a></div>
<br />
5. Repair the file by clicking on '<b>Repair</b>' button.<br />
6. After successful repair '<b>Recovery process successfully completed</b>' message will appear, click <b>Ok</b>.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJH5S6UXoW3EzDeXJKrNmECwUDkeoJtDsZTQn9Fy2B6jlNXhwIvvEPFDNwELahK84VkRJl42J8Y6gZM1mhDeg-yebChUpdcWOXZ2Sb0H-vNhyphenhyphenLi4HjFB8D3SZRMLvM4xy9JXadc0MduEBB/s1600/5.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="145" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJH5S6UXoW3EzDeXJKrNmECwUDkeoJtDsZTQn9Fy2B6jlNXhwIvvEPFDNwELahK84VkRJl42J8Y6gZM1mhDeg-yebChUpdcWOXZ2Sb0H-vNhyphenhyphenLi4HjFB8D3SZRMLvM4xy9JXadc0MduEBB/s320/5.bmp" width="320" /></a></div>
<br />
7. Again 'Do you want to add...' message appear, click <b>Yes</b> if you want to attach new mdf file to SharePoint Server.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMCr-Azb3vq5zvTnFGOJjSWRT0wR0aZBn6bMlz3KioUkNkrM3h5dEDxIPlnYZrKh-kCTo6SSzjfDO9xdR63gC4lza0mZUmyhS7_0G0XShl6zbhPZtqnflWJRo746NHkQdDYbCZxRdAYYuI/s1600/6.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="130" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMCr-Azb3vq5zvTnFGOJjSWRT0wR0aZBn6bMlz3KioUkNkrM3h5dEDxIPlnYZrKh-kCTo6SSzjfDO9xdR63gC4lza0mZUmyhS7_0G0XShl6zbhPZtqnflWJRo746NHkQdDYbCZxRdAYYuI/s320/6.bmp" width="320" /></a></div>
<br /></div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-33896016893774050232013-01-22T00:20:00.000-08:002013-02-07T19:32:17.079-08:00SharePoint 2010: Disaster Recovery Planning<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
There is a great saying “An ounce of prevention is worth a pound of cure”. We all know that prevention is always better than cure. So instead of waiting for the disaster to happen and then planning for the recovery of data is not at all a good idea. Disaster recovery planning should be the first priority for any organization. Similarly if you have been using SharePoint for storing all your crucial information then I hope you must be aware that how critical a data is for any organization. With timely planning you can easily prevent data loss situation from any type of disaster. Now I am going to discuss what factors you should take in to consideration in your Disaster Recovery Plan.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaibWqh77Tlun011qbKopcuwY8WvaJfjKyq_bLDt5bKUMa3YDcm5bKMbSJ5v93oXLDr6qraGa4KOYAF-6ysI5yYsRygt0wCD_mRBNr9WpCjf45wwwD7xpeRB7EfrJRP11NhGFdF1NvKDCt/s1600/disaster+recovery.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="201" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaibWqh77Tlun011qbKopcuwY8WvaJfjKyq_bLDt5bKUMa3YDcm5bKMbSJ5v93oXLDr6qraGa4KOYAF-6ysI5yYsRygt0wCD_mRBNr9WpCjf45wwwD7xpeRB7EfrJRP11NhGFdF1NvKDCt/s320/disaster+recovery.jpg" width="320" /></a></div>
<br />
<b>DR:</b> First you need to understand the meaning of disaster recovery. Disaster is that point in the life span of a product when there is unplanned downtime or data loss. So now you know that disaster can also be unnatural in nature like human error. DR is the process of bringing the database back to its normal state in the event of disaster.<br />
<br />
<b>Downtime:</b> In DRP you first need to specify that for how long your organization can cope up with unplanned downtime.<br />
<br />
<b>Define RTO:</b> Recovery Time Objective(RTO) is define as that duration of time within which a system is brought back in the operational state after a disaster.<br />
<br />
<b>Define RPO:</b> Recovery Point Objective(RPO) is define as the acceptable amount of data loss in case of disaster. In simple words it is the time between your most recent(last) backup and disaster.<br />
<br />
<b>Prioritize your data:</b> Since DRP is an expensive process therefore you need to decide which data is most important for your organization and which one you can afford to lose. This way you just need to make the DRP only for the data that matters to you. It will save time and money.<br />
<br />
<b>Keep your database small: </b>Large size database always create problem as they impact the log size and also take very long time in backup and restore. So keep it small.<br />
<br />
<b>DRM:</b> DRM is Disaster Recovery Manager. It is that person who is responsible for bringing the database back to its original state in case of disaster. You should assign a person as DRM according to his skills.<br />
<br />
<b>Documentation:</b> It is very important that all your resources should be properly named and well documented otherwise the backup process will become complicated.<br />
<br />
<b>Backup strategy:</b> Decide which data you really need to backup and which one you can rebuild manually. The most important things that you should backup in SharePoint 2010 are Content databases, Custom code, Search databases, Configuration databases and Content databases.<br />
<br />
<b>Design and test: </b>After knowing all your requirement design your Disaster recovery model. Once model is complete don't leave it like that. Test it properly and redesign it, if required.<br />
<br /></div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com1tag:blogger.com,1999:blog-8355606938036663217.post-37278575895184843152013-01-20T22:08:00.000-08:002013-02-07T19:41:57.177-08:00Oracle: RMAN Backup types<div dir="ltr" style="text-align: left;" trbidi="on">
Recently one of my client asked this question “ What are the benefits of using RMAN backup and what type of backup it supports.” Here I have explained the answer in detail.<br />
<br />
Recovery Manager(RMAN) is an Oracle inbuilt utility that efficiently backup and restore the database. It optimizes database performance and free you from running long SQL * Plus scripts. Recovery manager provides a command line interface that directs Oracle server to take backup of database it is connected to. The RMAN utility is different from normal OS backups because it store the backup in its own backup catalog.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgd-ap8Ji7-1joki3CgvuNFLTXDBCw7V4Q5HKdq_EBBuc5h48Twbu-EvAYbqenEgyiounXuzqUmyV8ve65nDz2jmweLpSb6nW4S7DwX3QG6PJB5_TDUrtNVAhZT-JSgwXfFSKDhCsbqwIMf/s1600/Backup.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgd-ap8Ji7-1joki3CgvuNFLTXDBCw7V4Q5HKdq_EBBuc5h48Twbu-EvAYbqenEgyiounXuzqUmyV8ve65nDz2jmweLpSb6nW4S7DwX3QG6PJB5_TDUrtNVAhZT-JSgwXfFSKDhCsbqwIMf/s1600/Backup.jpg" /></a></div>
<br />
<b>Benefits of using RMAN backup:</b><br />
<br />
1. Simplifies administrative tasks.<br />
2. Simple command line interface.<br />
3. Reduce human errors.<br />
4. It keeps track of all the backup.<br />
5. Supports incremental backups.<br />
6. RMAN can very work very well with third party media management product like Veritas Netbackup.<br />
7. Using RMAN you can test the backups even without restoring them.<br />
8. It automatically detects new tablespaces and datafile.<br />
9. During recovery it also detects errors.<br />
<br />
<b>RMAN backup types:</b><br />
<b><br /></b>
<b>Full database backup:</b> It is the backup of every allocated block in database file. In full backup an image copy of every data block is being created. You can store these image copies only on disk. Full database can be taken in ARCHIVELOG or NONARCHIVELOG mode.<br />
<br />
<b>Incremental database backup:</b> An incremental backup can be of two types. One is level 0 backup and another is level 1 backup. Level 0 backup includes only those blocks that have been changed since the last “parent backup”. Level 1 backup include all data blocks in the file except empty blocks and it is similar to full backup.<br />
<br />
<b>Consistent database backup:</b> The consistent backup is taken when database is in consistent state. To take the consistent backup of whole database you first need to close the database with the NORMAL, IMMEDIATE or TRANSACTIONAL commands.<br />
<br />
<b>Inconsistent database backup:</b> The inconsistent backup is taken when database is in consistent state. It is usually taken after a failure, abort and shutdown command.<br />
<br />
<b>Open database backup:</b> Open backup is taken when the database is running or in online mode.<br />
<br />
<b>Closed database backup:</b> Closed backup is taken when the database is shutdown or in offline mode.<span class="Apple-tab-span" style="white-space: pre;"> </span></div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-34996369365527620282013-01-15T02:40:00.002-08:002013-11-14T20:32:24.637-08:00MySQL: Know your backup needs<div dir="ltr" style="text-align: left;" trbidi="on">
Backups are the backbone of your data and having a bad strategy may lead you in big trouble. So it is important to have a <a href="http://database-recovery-software.blogspot.in/2012/12/top-5-ways-to-backup-and-restore-mysql.html" rel="nofollow" target="_blank">good backup strategy</a> in place according to your business needs. Every business has different backup needs. Some customers can't afford any downtime in their business while for some a little downtime is OK. That is why you should choose a reliable backup strategy that can work for your business. While developing a backup solution, keep following things in mind:<br />
<ol style="text-align: left;">
<li>For how long can you afford the downtime?</li>
<li>What type of failures are the most common in your systems?</li>
<li>How fast MySQL recovery process should be?</li>
<li>How much can you spend on backup?</li>
<li>What will be the impact of backup and recovery process on your application?</li>
<li>Will it be ok for your business if the backup require shutting down MySQL?</li>
<li>Will you able to handle the backed up data?</li>
<li>Does the backup use any interrupting process that can slow down your system?</li>
</ol>
<div style="text-align: left;">
These are the most common things that you should know before choosing a good backup strategy for your business. <br />
<br />
<b>Which backup strategy should I choose?</b><br />
<b>Mysqldump: </b>Backup your data with mysqldump command if your data is small. It can backup whole or partial database.<br />
<br />
<b>LVM snapshot:</b> If your data is large then you can take snapshot of your data. This technique allow administrator to create an exact image of logical volume. <br />
<br />
<b>Cold backup: </b>It is used when you want to backup only tables.<br />
<br />
<b>Know your backup needs:</b></div>
<ol style="text-align: left;">
<li>Know the importance of data, its availability and requirement.</li>
<li>Plan your backup strategy according to above factors.</li>
<li>Weekly backup your data.</li>
<li>Test backup and restores. </li>
</ol>
<div style="text-align: left;">
</div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-19218762932379566422013-01-14T02:28:00.000-08:002013-01-14T02:28:07.926-08:00How to optimize MySQL performance?<div dir="ltr" style="text-align: left;" trbidi="on">
<title></title>
<style type="text/css">
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<br />
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Optimization is
a difficult task because to optimize a system you must know the in
and out of it. You can optimize your system easily if have knowledge
or understanding of your system. In MySQL the main performance
booster is query optimization. Although other factors are also
important in improving performance but by optimizing query you will
see drastic impact on execution time. So here I am discussing some
quick tips for improving MySQL performance.</div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Tips: For
MySQL OS & hardware</b></div>
<ol>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Avoid
reading data from disk as it is very slow process.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Use SAS
instead of SATA.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Avoid
using lower versions of RAID.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Never try
to kill a MysQL process forcefully otherwise you will loose your
data.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Use
smaller disks as they are much faster than larger disks.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Your
server should be dedicated to MySQL only.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Make sure
your OS and data partitions are physically seperated.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Avoid
using software RAIDS.</div>
</li>
</ol>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Tips: For
MySQL schema optimization</b></div>
<ol>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Use
indexes to speed things up but don't overdo it.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Instead of
adding new indexes, always try to extend the existing ones.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Use
triggers.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Use
storage engine according to your data requirements.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Optimize
tables.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
If you are
storing variable length strings use VARCHAR instead of CHAR.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Use more
linking tables.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Try to use
the smallest data type.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
If your
database has auditing tables then use ARCHIVE storage engine.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Try to
avoid using NULL because when it indexed it take an extra byte per
entry.</div>
</li>
</ol>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Tips: For
MySQL backups</b></div>
<ol>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
When
taking backup of database make sure MySQL is closed.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Optimize
all the table before backup.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Don't use
replication during backup as it can make data inconsistent.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
If you
backup data using mysqldump then use it with -opt.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Check the
size of tables, indexes and database after backup to monitor growth.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Test your
backups weekly to make sure they are working properly.
</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Avoid
using LVM snapshot for backup as it can make your data inconsistent.</div>
</li>
</ol>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<b>Tips: For
MySQL query optimization</b></div>
<ol>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Normalize
all the tables.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Use
'OPTIMIZE TABLE' and 'REPAIR TABLE COMMAND' to improve the loading
speed of your database.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Find out
the slow queries in your database using Slow Query Log.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
After
identify the slow queries, use commands like EXPLAIN, SHOWPROCESS
LIST to check the functionality of queries and their side effects on
database.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Avoid
using HAVING clause.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Use
TRUNCATE command instead of DELETE for removing entire table.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Try to use
GROUP BY rather than DISTINCT when required.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Count (*)
can lock the entire table, so avoid using it.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Avoid MAX
command instead use ORDER BY.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
Use UNION
in sub queries.</div>
</li>
<li><div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
To remove
table use DROP TABLE command instead of DELETE FROM.</div>
</li>
</ol>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
These are the
basic things that you can do to optimize MySQL. I hope it will help you.
If you too want to share some tips, please go ahead.</div>
<div align="LEFT" lang="en-US" style="margin-bottom: 0cm;">
<br />
</div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0tag:blogger.com,1999:blog-8355606938036663217.post-12608987831827379592012-12-27T19:17:00.000-08:002012-12-27T19:17:39.023-08:00Understanding SQL Server restore phases<div dir="ltr" style="text-align: left;" trbidi="on">
Restore means copying data from backup files. Using restore command you can restore part or whole database. The restore process contains multiple phases. So today I am going to explore all of them.<br />
<b><br />Data Copy Phase:</b> This is the first phase of restore process. In Data Copy Phase following operations are performed:<br />
<ol style="text-align: left;">
<li>In this phase all the data including index pages, log is being copied from the backup to database.</li>
<li>It also initializes the contents of files and databases.</li>
<li>This phase, restore data using full or differential backups.</li>
<li>Restore file, restore database and restore page operations are used to perform restore in this phase.</li>
</ol>
<div style="text-align: left;">
<b>Redo Phase: </b>This phase is also known as Roll Forward. It will redo all the changes that occur before the crash so that database remains in same state as it was before the crash. In other words, this phase we try to bring database forward in time by applying logged changes. To perform this operation SQL Database Engine use full backup. Redo operation is performed only when it is required. <br />
<br />
<b>For example</b>, if data remains read only throughout backup process then there is no need to perform it. The main motive of this phase is to bring the database back to its original state and this original state is also known as recovery point.<br />
<b><br />Undo Phase: </b>This phase is also known as Roll Back. The database becomes inconsistent after performing redo operation because it contains changes made by uncommitted transactions at the recovery point. So the recovery processes first identifies the uncommitted transaction and then undo them. The main goal of this phase is to maintain the integrity of database. The undo phase is skipped if database is already in consistent state.<br />
<br />
<b>Restore phase’s options:</b> WITH RECOVERY or WITH NORECOVERY <br />
<br />
<b>WITH RECOVERY:</b> The RESTORE statement with WITH RECOVERY option contains both undo and redo phase. This command is used to bring database in online state.<br />
<br />
<b>WITH NORECOVERY:</b> Undo phase is skipped with WITH RECOVERY option to preserve those transactions that are not committed.<br />
<br />
<b>Fast Recovery Phase: </b>This phase is available in SQL Server 2005 and later versions. The fast recovery allows user to access the database during the undo phase or we can say it make database available for user. </div>
</div>
Sam Josephhttp://www.blogger.com/profile/00479606573887239885noreply@blogger.com0