Tuesday 24 September 2013

CREATE DATABASE failed with clustered Microsoft SQL Server 2008 instance : resolved

Trying to create a database on a clustered SQL 2008 instance? Getting the following error message?
Cannot use file
'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\myDatabase.mdf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
If so, you forgot to configure the disk dependency in Failover Cluster Manager! SQL prevents you from creating databases on volumes which aren't a dependency of the SQL Server resource. This is to prevent situations where SQL Server comes online before the disk containing the database which would lead to a "I can't see the database!" error from SQL.
To remediate this, simply add the dependency.
  1. Open Failover Cluster Manager
  2. Select your clustered application
  3. Right-click the SQL Server resource, and then bring the resource into an Offline state by clicking Bring Offline.   
  4. Right-click on your SQL Server resource then click Properties.
  5. Click on the Dependencies tab.
  6. Click the Insert button to add an additional row, then select the shared disk that contains your SQL databases.
  7. Ensure that all resources are required (there is an AND next to subsequent resources) then click OK.

Monday 23 September 2013

Mobile Operating Systems - Clearing Cache and Cookies

Clearing Cache and Cookies on Mobile Phones
Mobile Operating Systems
Operating System
Document Link

Android

iOS

webOS

Windows Phone

Sunday 22 September 2013

Clearing Browser Cache and Cookies

Clearing Windows Browser Cache and Cookies
This document explains where to find instructions on how to clear cache and cookies in your web browser.
Windows

Browser
Document Link

Internet Explorer 6

Internet Explorer 7

Internet Explorer 8

Internet Explorer 9 & 10

Firefox 3.5

Firefox

Chrome

Opera

Safari

Opera (Win) - Clearing Cache and Cookies

Opera (Win) - Clearing Cache and Cookies
This document explains how to clear the cache and cookies in Opera 9 through 11.
Opera 10.50, 11, and Newer
  1. Click on the Opera button in the top left corner > Settings > Delete Private Data...
  1. Click on Detailed Options to show the rest of the options. Make sure only the following are checked:
    • Delete temporary cookies
    • Delete all cookies
    • Delete entire cache
Click on the Delete button.
Opera 9 and Opera 10
  1. Click on Tools > Delete Private Data....
  1. Click on Detailed Options to show the rest of the options. Make sure only the following are checked:
    • Delete temporary cookies
    • Delete all cookies
    • Delete entire cache
Click on the Delete button.

Safari (Win) - Clearing Cache and Cookies

Safari (Win) - Clearing Cache and Cookies
This document explains how to clear the cache and cookies in Safari.
Safari 5
  1. Click on Tools (the gear icon) > Reset Safari....
  1. Check Empty the cache and Remove all cookies, then click on Reset.
Safari 4
  1. Click on Tools (the gear icon) > Reset Safari....
  1. Check Empty the cache and Remove all cookies, then click on Reset.
See Also:

Chrome (Win) - Clearing Cache and Cookies

Safari (Win) - Clearing Cache and Cookies
This document explains how to clear the cache and cookies in Safari.
Safari 5
  1. Click on Tools (the gear icon) > Reset Safari....
  1. Check Empty the cache and Remove all cookies, then click on Reset.
Safari 4
  1. Click on Tools (the gear icon) > Reset Safari....
  1. Check Empty the cache and Remove all cookies, then click on Reset.
See Also:

Firefox 4+ (Win) - Clearing Cache and Cookies

Firefox 4+ (Win) - Clearing Cache and Cookies
This document explains how to clear the cache and cookies in Mozilla Firefox 4+.
  1. Click the Firefox menu and go to History, then Clear Recent History....
  1. Click on the drop down box to the right of Time range to clear: and select Everything. Then, click on Details and check both Cookies and Cache. Click on Clear Now.

Firefox 3.5 (Win) - Clearing Cache and Cookies

Firefox 3.5 (Win) - Clearing Cache and Cookies
This document explains how to clear the cache and cookies in Mozilla Firefox 3.5.
NOTE: As of April 28th, 2011 Firefox 3.5 is no longer the current version of the Firefox browser. The Mozilla team has stopped releasing updates for this version and continuing to run it may pose a security risk. If you are still running Firefox 3.5, it is strongly recommended that you upgrade to a more recent version of the browser. You can visit http://www.mozilla.org/en-US/firefox/new/ to download the most recent version.
  1. Click on Tools > Clear Recent History....

  1. Click on the drop down box to the right of Time range to clear and select Everything. Then, click on Details and check both Cookies and Cache. Click on Clear Now.

  1. Click on Clear Now button.