How do I move SQL Server database files

you don’t mind stop the database from working, then you can DETACH it, move the files and then ATTACH it. Right click on the name of the database Select Properties Go to the Files tab Make a note of the Path and FileName of MDF and LDF files. This step is important in case you…

Read More

The format of the specified network name is invalid

if you are un-able to start Websites in the IIS and receiving fallowing errors “The format of the specified network name is invalid” couple quick things you can look into remedy to problem. First on the server drilldown to this Reg key. HKEY_LOCAL_MACHINE SYSTEM CurrentControlSet Services HTTP Parameters ListenOnlyList Make sure, the IP Address listed…

Read More

SQL Backup Maintenance Plan

Open management studio >>connect to SQL Server>>Expand Management>>Right Click Maintenance plan>>Select New Maintenance Plan Give name as you like ( FullBackupDaily) it will open designer window.Left side you can see ToolBox tab. Select Backup Database task and double click or drag and drop it to designer pane. Edit the Task for options>> connection as local,Backup…

Read More

Error SharePoint Server “Device is not ready” – Event 6482

Stop the Windows SharePoint Services Timer service (Found in Windows Services) Navigate to the cache folder In Windows Server 2008, the configuration cache is in the following location: Drive:\ProgramData\Microsoft\SharePoint\Config In Windows Server 2003, the configuration cache is in the following location: Drive:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config Locate the folder that has the file “Cache.ini” (Note:…

Read More

Date Format

You can create calculated column instead. For example: 1.      you have the date column like “Created” 2.      Create new calculated column, type the formula like “TEXT(Created, “dd-mmm-yyyy”)” Now you can use this column displayed in your view. The date format is dictated by Locale. This is effected by what locale the site is created is….

Read More

Logo Redirect to Root Site Collection

<SharePoint:SPLinkButton NavigateUrl=”//” CssClass=”ms-siteicon-a” runat=”server” id=”onetidProjectPropertyTitleGraphic” > <SharePoint:SiteLogoImage CssClass=”ms-siteicon-img” name=”onetidHeadbnnr0″ id=”onetidHeadbnnr2″ LogoImageUrl=”/_layouts/15/images/siteIcon.png?rev=23″ runat=”server”/> </SharePoint:SPLinkButton >

Read More

SQL Server 2012 for SharePoint 2013 checklist

  Use multiple: SQL Aliases (separate 1 for search). Dedicate SQL Server for SharePoint. Set max degree of parallelism (MAXDOP) to 1 for instances of SQL (SP will do this when SP is installed).  Number of processes for each SQL statement. Mixed mode authentication – Don’t install SQL 2012 for SP in mixed mode auth…

Read More

I deleted the entire configuration cache directory. Now What?

a)     To recreate the directory, you need to know the directory name (which is a GUID). You can find this GUID in the registry entry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14\Secure\ConfigDB. Copy the GUID from Id attribute and create the new directory: C:\ProgramData\Microsoft\SharePoint\Config\GUID. b)     In the directory you just created, create another file called cache.INI. Open the…

Read More