Browsing articles from "October, 2013"
Oct
9
2013

How to restore SQL database on network share (UNC path) – SQL Server 2005

100913_1118_Howtorestor1.png

As it is known fact that by default SQL Server 2008 and below does not support database files on network shared path \\<sharepath>\<databaseFileName>.<mdf /ldf>, this is done because of certain performance and stability factor (read more about this in links present in reference section of this article). But in case if there is requirement to do a temporary restore on a network share then the below tip will come handy.   Note: SQL Server 2008R2 […]

Oct
7
2013

Fix: Operating System Error 5 (failed to retrieve text for this error. Reason: 15105). (Microsoft.SQLServer.Smo)

100713_1042_FixOperatin4.png

When trying to take Microsoft SQL Server database backup to a network shared disk then receiving following error,     Error text: Cannot open backup device “\\xxxxxxxx\xxxx.bak” . Operating System Error 5 (failed to retrieve text for this error. Reason: 15105). (Microsoft.SQLServer.Smo)   The error may vary, you may also receive Operating system error 5(Access denied) and that too for local disk instead of network disk. But symptom is same.   Solution to fix this […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 446 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

October 2013
M T W T F S S
« Sep   Jan »
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: