.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Backing to mapped drive No GO

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server


When I use the UNC to the share drive I get access denied.  I gather this is because it is running under the Sql Agent Account and not me.  How do I tell the Agent to run under myself?  The other problem is, if i run the backup as myself in the Query Editor it still fails, even though at the bottom it gives my domain\username as who the query is running under. 

10.50 RTM Sql Server 2008


View Complete Post

More Related Resource Links

Word save file on SharePoint via mapped drive


Hi, I have a Document Library mapped to a drive letter. I am able to browse the drive through Windows Explorer. However when I try to save a document to the drive Word returns, 'Unable to connect to the Web server.' .  I have been unable to find any information regarding this error message. If I try to create a document in the Document Library through Windows Explorer and the mapped drive, I get a different error message: 'Unable to create the file 'New Microsoft Office Word Document.docx' There is no user session key for the specified logon session.' After I click OKand refresh the directory, a 0 KB New Microsoft Word Document.docx file has been created. When that file is opened, it is in Read-Only mode.


Windows Server 2003 R2
Webclient service started
Signed into the Microsoft Online Services Sign in Application
IE configured through the sign in application
site added to the trusted sites in IE

Thank you again for your input.

regasm 4.0 generates error for DLL on a mapped network drive

Calling regasm from .NET Framework 4.0 generates an error for a DLL that is on a mapped network share.  This occurs during our debug builds on developer machines (we actually call a utility that wraps around regasm to perform COM-based registration).  The error is: RegAsm : error RA0000 : Could not load file or assembly 'file:///m:\<file being regasmed>' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515) I can work around this issue by modifying regasm.exe.config to include the loadFromRemoteSources element.  This seems like an annoying change for something that seems like a fairly common task. Is there some better way to enable this? Thanks, -Kevin

Getting UNC Path from Mapped drive

Hi All,

I am developing a ASP.NET application using VB.NET in 2.0 framework.

I need help in finding a solution to get UNC path from a mapped drive path.


1.)  \\DaytonServer  network server is mapped to a drive(Z:) 

2.)  if the user selects a file from a mapped drive (Z:)   then its appearing as Z:\FileName.txt  .  Once I retrieve this, I would like to get the UNC path for the mapped drive ( eg:  \\DaytonServer\FileName.txt   )   and store it in the database.  

Please help, I need to implement this immediately.

Send SSRS report to a Sharepoint mapped drive

On The Sharepoint server i have a mapped drive for a sharepoint doc library. Now i want to send a ssrs report (another server) using "Window File Share" to this mapped drive, but the mapped drive is not sharable. What do i do??

Why does .NET Framework require 841 MB hard drive space on C:

Just downloaded .NET Framework 4 from Microsoft website. Installation says it requires 841 MB space on my C: drive. Why so much? I am presuming that this is in addition to the space for the other versions of .net installed. This is not going to be installed without a very good reason for this much space required. Can anybody enlighten me on this? Any way to lighten the space requirement load?  

Backing Up & Restoring Data.

Hello, I'n new to the SQL Server Management Studio 2008, What i have done so far: I have opened my file Datebase Selected a subfolder inside the Database called "World00" I have backed up my World00 into my Hard Drive file called World00.bak But when i open my SQL Server Management Studio 2008, my World00 is "(Restoring) i seen some videos something about a Log that i also need to restore but where can i find that log? how do i make my file come back so i can go in it and use it? and also: http://img827.imageshack.us/img827/7172/problem2.jpg Can somebody please explain to me what do these options mean? Restore Options like (WITH REPLACE), (WITH KEEP_REPLICATION), Prompt and (WITH RESTRICTED_USER) Recovery State (RESTORE WITH RECOVERY), (RESTORE WITH NORECOVERY), (RESTORE WITH STANDBY) When i clicked on my World00 I selected (WITH REPLACE), and now i think i messed it up..is there a way to recover myfile back? so i can use it? because its still on "Restoring" please help! Also i did it all the way through like Manualy i didn't put any codes SQL's Query thing because i dont know how to use them if your going to give me a Query please tell me what to do, sorry i'm new to this coding ;o All i would like to know is how to backup ~ well i know this just right click on file select full backup and job done, but restoring is kinda confusing me because i

How to restore a database to the d drive

I have a 2008 database I need to restore, but my C drive is almost full.  How do I telll it to restore my database to the D drive?  

Autodelete log files on L: drive

Is there a way to automatically delete sharepoint logs on the server L: drive when space fills up?  I keep getting mom alerts on this drive.

C#: How to add a row to a child table with a DataSet backing?

On the back end I am using XML files, xsd schemas a DataSet(dsThingPrograms) and DataTables. I have a parent ->child table relationship defined through the DataSet designer as such:   things[RFID(pkey), name] programs[ID(pkey/autogen), name, path, thing_RFID(FK references things->RFID)]   In my code I have:   dsThingPrograms.things.AddthingsRow("lala" , "00ffe4" ); dsThingPrograms.things.WriteXml("path\to\things.xml" , System.Data.XmlWriteMode.WriteSchema);   which works fine. However the problem comes when I try to add a row to the Programs table. When I do:   dsThingPrograms.programs.AddprogramsRow("someprog" , "some\path" , <???>);   VS wants me to add a "dsThingPrograms.thingsRow parentthingsRowByFK_things_programs" where the <???> is. I've tried a bunch of things but I could not satisfy that requirement and can't even get the code to compile. What is supposed to go in there to satisfy the FK property?

VisualtTotals and group "others" drive me crazy!

Hi all, My problem can be modeled in ADVwork as follow: I’m trying to create a query that for each category member show the Top 2 Products members and member ‘other’ that sum the rest.   As far as I know Visualtotals is the function to be used but all my tests doesn’t works! Here below there is the code that for each category display ‘All’  value and Top 2 items.  I have to substitute ‘All’ value with ‘All Other’ (Visualtotals should do exactly this) Note: In my example Product and Category are dimension attributes not related in a hierarchy Again, in my various test with Visualtotals I found that if TopN is greater than the numbers of attribute members (es top 999) then  my ‘Other’ return ‘All’ instead of null! select {[Measures].[Sales Amount] } on columns, generate  (  [Product].[Category].[Category].members  ,  {topcount([Product].[Category].currentmember *[Product].[Product].members, 3, [Measures].[Order Count])   }  ) on rows from [Adventure Works]

Create database at network drive?

Is it possible to create a SqlServer database at a network drive? Thanks, Ben

How do I get the "Device Instance Id" of USB flash drive?

Hello, How do I get the "Device Instance Id" of USB flash drive? WPF C# code to accomplish this will be greatly appreciated. I'm trying again to get an answer to the above question.  It appears that some do not know what I mean by "Device Instance Id".  Here is how you find it on a computer with the XP operating system: If you go to it the wrong way you will not find it.  You have to follow these steps (on XP): 1) Make sure you have a USB flash drive inserted into one of the USB ports. 2) Click "Start" then right click "MyComputer" then click "Manage". 3) In the "Computer Management" window click "Device Manager". 4) In the right pane expand the "Disk drives". 5) Right click on "USB Flash Disk USB Device" (Will NOT be there if no USB Flash drive inserted). 6) Click "Properties". 7) Click the "Details" tab. 8) The drop down should already have "Device Instance Id" showing, if not, select it. 9) The contents of the text box below contain the information I want. Again, if you get to this window a different way, the "Details" tab may not appear. Again, if you do not have a USB flash drive plugged into your computer, the "USB Flash Disk USB Device" will not appear. This is what has been suggested before, but does not w

copy the image from table to disk drive

i have 2000  image he saved in the table "Employee" and i want to copy this pictures from table to diskdrive and save file name by the ID

Moving sharepoint database from one drive to other

I am having the sharepoint installed on c drive which doesn't have much space. Is it possible to move the content database to some other drive on the machine. If yes, then what is the procedure and do i have to make changes anywhere related to these changes? Also is there any possibility of something going wrong somewhere during this process? thanks in advance!

Create a Database to other drive in windows 7 and can not use it?

Hi, When I create a database in (for example) Drive E and Detach it and moving it to drive F and attached it gave me an error(Pic 4).When I copy it to Drive Windows(C),gave a message(Pic 2). in Drive C I can Attach database success fully,but in this time the database was ReadOnly And I can't change any things of database(Pic 3). when I change readonly from properties again give an error(Pic 5). This link of Pictures http://rapidshare.com/files/417610898/My_Problems.rar thanx.

Drive setup

I recently purchased two additional drives after doing with some testing, with some help from many people on this forum ... <a href="http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/066b423b-62bf-471c-97b2-629d7b5ccbceurl">Prev Post</a> What would be the optimal setup of mdf, ldf, and  tempdb ? should I leave the tempdb and give the ldf, mdf dedicated drives ? should I put the tempdb on the drive with the mdf on a logical partition ? Thanks in advance for the help   right now everything is on one drive ahhh !!!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend