How to Shrink LDF File Size using SQL Management Studio

If the transaction log file (.ldf) in Microsoft SQL is too big, it can cause performance issues, eat up valuable disk space and consume resources when you back up. Therefore it’s imperative to periodically maintain the database to keep the .ldf file under control. To reduce the .ldf file, you must do threethings: Backup the… Continue reading How to Shrink LDF File Size using SQL Management Studio

Migrating Service Applications from SharePoint 2010 to 2013

Migrating and upgrading our service applications and web applications to SharePoint 2013 is to restore the databases from the SharePoint 2010 environment to our SharePoint 2013 environment. This can be accomplished with the SQL Server Management Studio using the UI tools or a SQL query. To restore a database with the UI tools: Right-click Databases… Continue reading Migrating Service Applications from SharePoint 2010 to 2013

Migration SharePoint 2010 to 2013 with RBS content database

1.     Live SharePoint 2010 environment with SQL 2008 R2 a.    Take back up from 2010 live server. i.      Open management studio on SQL server. ii.      Take back up of content database of live application. 2.    QA SharePoint 2010 environment with SQL 2008 R2 a.    Restore SQL backup i.      Open management studio on SQL… Continue reading Migration SharePoint 2010 to 2013 with RBS content database

Disabling RBS in Sharepoint 2010 and migrate RBS Filestrem files into the database

I found all the steps just as difficult to figure out as for installing. Below are my findings on how I managed to disable R?BS and remove it completely of my sharepoint (I had 1 content db using it). Backup 1st: Backup site collection with stsadm, backup SQL db, backup RBS blob storage (NTFS –… Continue reading Disabling RBS in Sharepoint 2010 and migrate RBS Filestrem files into the database

Database doesn’t show when creating a data source for Performance Point Dashboard Designer

I wasn’t here for some time that I was busy coding some SQL and JavaScript so there was no problems that acctualy I could write off here. In last days I have to do some maintenance jobs for our cilent so few interesting problems shows up. If you using Performance Point Dashboard Designer and you trying… Continue reading Database doesn’t show when creating a data source for Performance Point Dashboard Designer

Resolving could not open a connection to SQL Server errors

Problem Sometimes you may have issues connecting to SQL Server and you may get messages such as the following: ERROR: (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error:) An error has occurred while establishing a connection to the server. (provider: Named Pipes Provider, error:… Continue reading Resolving could not open a connection to SQL Server errors

SharePoint 2013 : Cannot open backup device ‘[filename and path]’. Operating system error 3(The system cannot find the path specified.). BACKUP DATABASE is terminating abnormally.

Problem Your SharePoint Server 2010 or 2013 system employs a SQL Server 2008 or 2012 farm database server. SharePoint 2010 SP1 may or may not have been installed. Both SharePoint 2010 and SQL Server are hosted on Windows Server 2008 platforms.  The MSSQLSERVER service is run under the NETWORK or other domain account. You attempt… Continue reading SharePoint 2013 : Cannot open backup device ‘[filename and path]’. Operating system error 3(The system cannot find the path specified.). BACKUP DATABASE is terminating abnormally.