.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

copy folder from one server to the next using xp_cmdshell

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
Hello, I have to copy a folder from one server to another. I would like to use xp_cmdshell to accomplish this, but I am not sure if I have to create a batch file, or if I can just embed the commands right in xp_cmdshell. My DOS knowledge is limited, so I always dread these types of tasks. Any help would be appreciated and that you all in advance :)   DaveDave SQL Developer

View Complete Post

More Related Resource Links

Copy reports to a different folder on Report Server


My report server has 2 folders: ProductionReports - about 50 reports AND TestReports - 0 reports

I want to copy all the reports from Production to Test. One method is to save each Prodcution .rdl then upload each one to Test and then change its datasource. This will take a long time!!!! Is there a way and can copy them all together and then go change their data source? I am hesitant to deploy the reports from VS because I don't know if the project has the correct report versions (it is not my server).

Is there an easier way to do this? Thanks!!!! Linda




Bulk Copy From Datatable To SQL Server Table


 I have read the data of a excle file and captured the data into the dataset to a datatable, now that data is to be inserted into a SQL Server table using bulk copy option. I am using -

 public bool BulkEnterData(DataTable dt, string tblName)
        SqlBulkCopy bulk = new SqlBulkCopy(con);
        bulk.DestinationTableName = tblName;

        return true;

ERROR Getting-
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) 

How to resolve the above problem or any other solution is available.


Copying files to a folder on web server



I have few files in FolderA on the web server.

I want the users to select a fews files from FolderA and copy them to FolderB on the same web server.

I want to list all the files in FolderA and allow the user to select a few files and copy.

I want to copy the files programatically when the user selects a few files and click on Copy button.

How to copy the files quickly from folderA to FolderB?




SQL Server to SQL Server Compact Edition Database Copy

I recently switched from XP to Win 7 and am getting an error when using the SQL Server to SQL Server Compact Edition Database Copy wizard from johnnycantcode.com (link). I suspect that the problem is with the configuration of the path for the DQL CE dll. 1) Does anyone know where the configuration is set? It isn't in the GLT.SqlCopy.exe.config file in the local directory. 2) Has anyone got the program to run under Win 7? Thanks marc  

SQL-Server 2005 x64 / windows server 2003 x64 crashes during file copy

Hi We are running: Microsoft SQL Server 2005 Standard - 9.00.4294.00 (X64) Microsoft Windows Server 2003 R2 Enterprise x64 We have gigabit interface. Today we copied a file (using robocopy) from our databaseserver to another server (backup-server). The copy was started from the backup-server and source were specified using UNC. The copy were using about 20% of the bandwith (about 200Mbit). During the copy, sql-server reported several errors, for example: AppDomain 15 (mp.dbo[runtime].14) is marked for unload due to memory pressure. The client was unable to reuse a session with SPID 75, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. ***Stack Dump being sent to [PATH\SQLDump0005.txt Resource Monitor (0x1384) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 0 KB. Approx CPU Used: kernel 15 ms, user 218 ms, Interval: 428541. So to me it appears that sql-server crashed during a file copy. We have 27 GB ram. With 24.5 GB dedicated to SQL-Server. The files we copied were quite large, some over 50GB. I found a similar issue about this: http://support.microsoft.com/kb/920739/ Do you think the issue above could be the cause of the sql-server crash? ///Patrik

Moving a Copy of SQL Report Server 2005 and Upgrade to 2008

Hello, We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose. My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database. If we are successful with this, we might also want to upgrade to SQL 2008. Thanks for your help,   Elizabeth K.

Saving Image File in a Folder on Sever from Client Machine using Sql Server

  Hi EveryOne... Can anyone help me Saving an Image file in a Server folder from a client machine using Sql server 2005....   

Copy sharepoint 2007 folder (with sub folders) with all the security permissions

I am looking to copy a common sharepoint folder(sub folders) in 2007 with all the security permissions intact, to a different location in the same site, Does anyone know how to do this?

Upload a FOLDER To Server

Hello,I have to create a web page and give access to my visitors to upload their folders into the Web Server, can anyone help me on this issue!?Please send your Codes in VB.NET .Thank You,

Copy files from one folder to another

hi  I am able to create a folder but is not able to copy files from the source to the newly created folder. Is there something that i missed out? Thanks  Dim sitename As String = "~/site/" & txtUsername.Text Directory.CreateDirectory(Server.MapPath(sitename))            Try                Dim f() As String = Directory.GetFiles("/site/source/")                For i As Integer = 0 To UBound(f)                    File.Copy(f(i), Server.MapPath(sitename) & "\" & (f(i)))                Next            Catch ex As ExceptionEnd Try  

xp_cmdshell not executing for fixed server role.

Hi all, i hope you can help me. i am logon into sql server 2005 using my windows account. i am trying to execute xp_cmdshell from my account as i am member of fixed server role (sysadmin acouunt). when i am executing xp_cmdshell , its running under ##xp_cmdshell_proxy_account## "Proxy acoount".  please help me to run under sysadmin account .

Copy sharepoint 2007 folder (with sub folders) with all the security permissions

I am looking to copy a common sharepoint folder(sub folders) in 2007 with all the security permissions intact, to a different location in the same site, Does anyone know how to do this?

Folders or folder like equivalent in SQL Server 2008 ? for packages & stored procedures ?

Hi,      Currently running SQL-Server 2000.  We have hundreds of stored procedures and DTS packages. We have so many it's becoming a serious challenge for names and such.  We were wondering if SQL Server 2008 has a way to 'nest' both the equivalent of DTS packages (SSIS) and stored procedures in something akin to 'folders'.  We know we have to upgrade one of these days but a version that would handle these would be much more attractive. Just getting this functionality would be worth whatever effort would be required to upgrade.   Thanks in advance for any help on this.

Copy files through batch program on Windows Server 2003

I have a VB6 program running on windows server 2003. When I try to open a file in a SharePoint Document library it will not traverse folders. If I run the application on Windows 7 (maybe Vista too), it can. I assume that there is some operating system helping hand here. In order to get around this problem, we have to output our files to a network share and then copy the files over to the document library manually. My question is, how can I write a batch program that will copy all of the files on a network share to the document library using the individual's credentials? I am unable to map a drive letter to a document library in Windows server 2003 (it works on 7). Any suggestions and tips would be much appreciated. Thanks.

Running a copy of Central Administration on a second server, how do you do this?

According to Microsoft's details on capacity management and planning below - you can have a copy of Central administration running on a second server, I always though you could only have CA running on one server. How do you have a copy running on a second server? http://technet.microsoft.com/en-us/library/ff607864.aspx Quote from site - "App-2 is a dedicated Search query server. It also contains a copy of Central Administration and For high availability, Central Administration is also installed on a front-end Web server on another host." Obviously you don't run the installation software as you have multiple copies of the CA database and config databases but you couldn't have a restored site collection either as this would be out of date as soon as you installed it so how do they propose you do the above, they actually state having two copies and the original in the link above?

Making a copy of WSS3.00 from Production server to Development.

Dear All, I have a WSS3.0 production server which use MSSQL2008 database on Same box.Now I am planning to install a new server for developement purpose with same settings as production.Is it possibile to make a copy of production WSS on new Development server? It would be a great help if somebody can explain me the steps how to configure a copy of datas from Productin to Development incase if this option works!   Thanks to all in advance Regards Jo

Restrict folder access in Report Server

Hi There, I am creating folders each of our end users in Report Server, who upload their reports to their respective folder. I want to allow users to see and access only their folders and they should not be able to see others folders available on the Report Server, it is possible? If Yes, how do I do it? Thanks for your help. Regards, Suresh
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