Fastest Method To Copy A File Across Network?
Jul 23, 2005
I work with databases and some of my backup files are 30-100 gigs in
size. I currently use the FastCopy utility to copy files from one
server to another. (This is needed when I need to transfer a DB to a
different server). FastCopy says its 30 to 50% faster than Windows
file copy. I read somewhere that the windows kernel defaults to
4mb/sec throughput for copying.
Is this true? Is there a faster way or some utility to copy files?
I'm aware of RoboCopy but the documentation didn't mention anything
about faster performance. All my servers are windows 2000 NTFS.
Thanks
View 3 Replies
ADVERTISEMENT
Nov 17, 2006
I am trying to find some info on the fastest connection transport for an app that is running on the same box as a SQL 2005 instance. The app does a large number of updates (high volume of data).. win32 using native ODBC. I am trying to find info on which connection mechanism is best... socket, pipes, etc. I read somewhere that there is a file mapped method available but i cannot find info on that either. Also, is there any performance difference between the old SQL OCBD drive and the new SQL Native Client OCBD drive?
Thanks.
View 2 Replies
View Related
Dec 8, 2006
Hi,
We have SAN for our SQL server and all of DB backup copy pointing to one the SAN volume(ex. T). We are moving the bkp copy from this SAN volume into remoteserver for restoring the backup. We are getting a lot of Time out during this time.
Is that copy process affect production time out?.
Thanks,
View 1 Replies
View Related
May 22, 2007
I've got a view that is driven from a 80 million record table in a data warehouse. I am trying to populate an aggregate table in a datamart, but am running into preformance problems. The datamart table needs to be updated daily. I understand there are many factors that effect performance, but in general would the fastest approach be:
1) Truncate the datamart table
2) Perform a bcp of the view to a text file
3) Bulk Insert to the datamart table
If you need more information to answer this please let me know.
Thanks,
Matt
View 7 Replies
View Related
Nov 13, 2006
The DTS Task Copy Server Objects is PAINFULLY slow.
The Copy Table Wizard is fast but generates an unmanagable DTS and does not bring over the indexes.
Any tips or tricks to copy tables, data and indexes and a reasonable speed?
Thanks,
Carl
View 1 Replies
View Related
Aug 9, 2004
I need to create some sort of method to copy the schema and data from an existing database and recreate that database schema and data at another location i.e. customer site. I would like to be able to start the rendered script from a command line. I will be very appreciative of anyone who can get me started in the right direction.
Thank you,
iRead
View 1 Replies
View Related
Mar 7, 2007
Hi, The attached code gives the error "One or more errors occured during processing of command"
What I am trying to do is simply copy a table ("inventry") to a new table name ("bob"). Eventually I want to create a new table based on a filter (as i would using the SELECT INTO command in sql)
Note that this is for a foxpro table
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=VFPOLEDB.1;Data Source=C:\test\Inventry.dbf;Password=''";
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "USE Inventry";
cmd.ExecuteNonQuery();
cmd.CommandText = "COPY TO bob";
cmd.ExecuteNonQuery(); // ERRORS HERE!!!!
ive tried a similar thing in VB and get the same error:
Dim cn As New ADODB.Connection
cn.ConnectionString = "Provider=VFPOLEDB.1;Collating Sequence=MACHINE;Data Source=C: est"
cn.Open
cn.Execute ("set null off")
cn.Execute ("USE C: estInventry.dbf")
cn.Execute ("COPY TO C: estBOB WITH CDX") // ERRORS HERE!!!
Any help would be greatley appreciated
Regards,
Shaun
View 5 Replies
View Related
Jul 21, 2015
I was wondering if there is a way to copy files from a network to an ip site where you would need to log in at. What I am trying to do is make a SP that would take all .csv files from the network drive and place them in the other ip address folder however you would need to use the login information.
View 5 Replies
View Related
Jan 8, 2008
Hi,
I have a number of large tables (50,000,000 + rows and 30+ columns) that are refreshed once per month with data from another system. Data is first loaded into a staging table, that has an indentical strcuture to the final table, cleansed and then copy to the final table.
The current copy process is simple but inefficient:
Truncate Table <final-table>
Insert Into <final-table>
Select * from <staging-table>
If possible I don't want to use DTS for this and I'd like to use a batch size of around 10,000 rows to help reduce the size of the log file because I have 3 of these types of Inserts running concurrently.
What is the fatest way to copy data from one table to another, within a stored procedure using SQL 2000 on a large, clustered server that uses logging?
Thanks,
Jason
View 5 Replies
View Related
Nov 4, 2006
Hello,
if i have a given database (a model) and i want to copy this database in the same database instance. Is it ok to copy the mdf and ldf file and attach the files with a new database name in the same instance.
Or is the datebase name part of the .mdf file?
Regards
Markus
View 6 Replies
View Related
Jun 8, 2007
I am able to run SSIS packages as SQL Server Agent jobs with a Control Flow items "File system task", if I move a file (test.txt) from a drive (c on the server (where SQL Agent jobs run) to a subdirectory on the same drive. But, if I try to move a file on a network drive, the package fail.
What I can do to solve this issue.
Bye!
Daniel
View 1 Replies
View Related
Apr 6, 2015
I am running my package in sql server 2012, in which i am giving network path for flat file destination. And its working fine. But if i give m local path, its giving me error " cannot open data file" ...
Nothing is wrong with package.
View 10 Replies
View Related
Jul 3, 2007
HI,
I am creating a custom control flow component in SSIS. The work flow of this component is to connect to File conection manager and after selecting the file it set properties of the file to variables. When i am runnning this component in SSIS , one method is calling i.e SAVETOXML. Here i am saving selected properties of the file to XMLby using XMLELEMent attribute. Its running fine. Here my question is where i can get that XML file. Where it is saving that XML file. From where i can Load that XML file. What is the use of LOADXML method.
Thanks in advance
ashok mohanty
View 4 Replies
View Related
Jun 19, 2015
Historically I've always written a VB script to copy a file from a sharepoint library. I don't like this method because I have to input a username & password in the script and maintain a config file.
Yesterday I was playing around with using a file system task. The sharepoint file has a UNC path so why not? I created a simple test package with a single file system task that copies the sharepoint file (addressed via UNC) to another network location. Package runs fine locally.
I try running on our utility server but am getting a "The file name [SHAREPOINT UNC PATH] specified in the connection was not valid" error. Package is running with a proxy on the server and the proxy account has the same permissions to the sharepoint site (so far as I can tell) as me.
View 0 Replies
View Related
Apr 13, 2007
I have made a small asp.net project which uses a local database file as a part of the project. The project is running fine om my local machine, but when I upload it to the remote server, the login fails for the server.
I suspect this is can be solved by using sqlserver authentication. But I have now spent a lot of time trying to configure the database file to use this authentication mode. As I see it there are three possible solutions to the problem.
use management studio express to configure the local mdf file (Ecxept that I cant find out how to connect to the mdf-file) and from here change the authentication method to sqlserver authentication.
use Visual Web developer to change the authentication method (but how???)
make the windows authentication work on the server (this would probably require that mannamgement studio express connects to the remote database. (Same problem as no 1)
Help will be higly appreciated.
Bjarke
View 3 Replies
View Related
Jul 24, 2015
I have a XML file (download XML File below at URL) stored in a SQL Column of XML type. The column with the XML file is named CurrentPackageXML in a table called dbo.
View 19 Replies
View Related
Jun 4, 2008
Not sure this is the correct forum, but I'll give it a go. I am in the process of deploying a series of databases from a development environment to a production environment. I've done some searching around best practices, but haven't found anything specifically calls out what is best. I am looking to find out the best approach for moving the code/tables/views/SP's, well everything from my dev environment to the production environment. Due to the complexity and large number of objects to be created, would a backup/restore to the production server be more prudent than creating a batch file type thing that creates all the objects through a series of scripts?
View 3 Replies
View Related
May 10, 2007
Hi,I am trying to write a method which needs to call a stored procedure and then needs to get the response of the stored procedure back to the variable i declared in the method. private string GetFromCode(string strWebVersionFromCode, string strWebVersionString) { //call stored procedure } strWebVersionFromCode = GetFromCode(strFromCode, "web_version"); // is the var which will store the response.how should I do this?Please assist.
View 3 Replies
View Related
Jan 5, 2005
The Sql Server database can only see the local drive.
I would like to set up a batch file that will copy a SQL Server
backup file from the local drive to the network drive. I would
like to append the file date to the end of the copied file. I
assume a batch file can accomplish this but I am new to batch
file writing. Does anyone have code that they already created
for this sort of task??
Thank you!
View 13 Replies
View Related
Sep 27, 2007
Hi,
I have installed SQL server 2005 in my machine. Now when we restore the database, I have check the size of database file .mdf/.ldf is very large. So now I wants to place these two files in any other machine in network.
But when I try to do the same, I am getting "Error 5110: network device not supported for database files.".
Please anyone guide me about the process. So that I can place these 2 files in another machine in network or any sharepoint.
Thanks
Regards,
Nipun
View 4 Replies
View Related
Apr 23, 2007
Hi,
I need to set up create a package so that I could check the date of the files posted in a folder, e.g. H:source. If there is no file created later than one day exists, then continue to check again one hour later. If files do exists, then copy then to c:dest and then upzip the files. Once this is done, sent an notification email to user@mydomain.com.
Thanks,
View 4 Replies
View Related
Mar 27, 2006
According to the help for SSIS, one method of deploying an SSIS package
to a SQL Server,
http://msdn2.microsoft.com/en-us/library/ms137565.aspx, is to use the
File...Save a Copy of <package file> as... menu option.
I don't have that menu option at all. And yes, the package is in
focus. My save menu options are simply; Save Selected, Save
<package file> As... and Save All.
I am using Version 9.00.1399.00 of the SSIS Designer.
At one time I did have the Management Studio's CTP installed.
However it was uninstalled before installing the tools from the
Standard Edition. (it would seem like not completely however)
Your help would be greatly appreciated. Thanx much.
p.s. Almost forgot to mention... I am already aware of using the
DTSInstall utility as a workaround. It should be noted, however,
that despite enabling the "CreateDeploymentUtility" property, the
DTSInstall.exe is not copied to the binDeployment directory.
View 11 Replies
View Related
May 2, 2008
Hi,
can I assign a NAS(Network Attached Storage) server to store the database file(readable and writable) and assign other several MS SQL database servers which will use the same database file in NAS to achieve the objective of high availability?
If it can, how can I set it up in MS SQL Server or it requires another 3rd patry software to set it up?
Thanks.
View 4 Replies
View Related
Aug 25, 2006
Is there an INF file or a registry entry for the client network utility that I can move from machine to machine? I hate having to re-enter all of my SQL servers and alias' every time I install Tools on a new machine...Any help is greatly appreciated!!
View 1 Replies
View Related
Oct 25, 2006
Hi,
How can I read a file placed in a shared folder on a network from MS SQL Server Stored Procedure.
Thanks.
View 1 Replies
View Related
Oct 25, 2006
Hi,
How can I read a file placed in a shared folder on a network from MS SQL Server Stored Procedure. Is there any kind of set-up I have to do. Can someone please help I am very new SQL Server stuff.
Thanks.
View 4 Replies
View Related
Apr 25, 2007
Hello,
I have Sql Server in one pc and I want to attach one databse that is in another computer that doesnt have SQL Server. Sql Server doesnt permit UNC path when attaching database files. Is there anyway to workarounf this. Is Trace Flag 1807 of any use?
Thanks
View 3 Replies
View Related
Jul 20, 2005
Hi All,I have a requirement to create the database with data and log files ina different machine on the network.Googling, I got a link which said Mapped drives do not work but UNC pathswork. However in my case, both are failing.Any advices or links on net will be highly useful.Thanks and Regards,Chandra Mohan
View 5 Replies
View Related
Nov 29, 2007
I know , it is not going to work , just wondering if anyone could give any reasons for that. Whether it was intentional constraint or just internally compact edition was designed in particular way which makes such a usage not possible. It is a pity that it doesn't work that way as it would be much easier transitional path for many Visual Foxpro , MS Access applications.
In my case I just want READ-ONLY database either for multi-user access via shared drive or stand-alone on local drive.
View 1 Replies
View Related
Oct 12, 2015
We have 1 tb of dbsize of 3 different db which include ,mdf and log and mdf file and also how some sql jobs ile daily and weeklybackup jobs .what is the best option to copy these db and sql jobs . Is there any tool tools available which can copy these file over the network .How much time will it take
1) If we go in for fullback and restore option ?
2) make the sql server db offfine and copy and paste these mdf ,ldf,log file to different location ?
3) what would happen to the will database login accounts , cross database ownership chaining ? etc
View 2 Replies
View Related
Jan 29, 2008
Hi,
I just have a Dataset with my tables and thats it
I have a grid view with several datas on it
no problem to get the data or insert but as soon as I try to delete or update some records the local machine through the same error
Unable to find nongeneric method...
I've try to create an Update query into my table adapters but still not working with this one
Also, try to remove the original_{0} and got the same error...
Please help if anyone has a solution
Thanks
View 7 Replies
View Related
Jul 11, 2007
Good Morning,
I'm hoping that someone can help me. I have a SQL 2005 SSIS package that will run Friday mornings to empty/load a table with data from another database. On Friday evenings I'll need to run another package, but want to make sure the table load completed prior to launch. For this I planned to use a file watcher task, however I cannot for the life of me figure out how to output a 'done' semaphore, from the morning job, to a networked drive.
A file system task will not work because there is not a 'create file' option. I do not have an existing file that I can rename either.
I tried an execute process task running cmd.exe with the following argument:
Code Snippetecho Done> \NetworkedServerftprootLoad.Done
This fails because UNC paths are not recognized. (The package executes from another server so I cannot use a local path, nor am I allowed to set-up a local share.)
Can someone offer an alternative suggestion? I'm really hoping this is easier than I'm making it.
Thank you in advance,
Roger
View 3 Replies
View Related
May 9, 2006
Hello,
I've been looking around in several SQL-Forums and in SQL Books Online but haven't found clear suggestions how to tackle my problem:
Our company has to fill a database with documentation for our contractor. Our subcontractors have to supply information from their branch/craft into this database, too.
Replication (without determining a type at this time) would do fine for data-exchange between us and our subcontractors.
But for working in different companies the networks are not connected
and in some companies/departments connection to the Internet is prohibited at all.
This would result in data-exchange based on files - which wont be a problem as data needs to be updated/exchanged only once a week and is usually done at meetings using DVD-Rs.
scenario in short:
- two-way exchange of data between SQL servers being not connected
- update needed once a week
- our server: SQL Server 2005 Standard (preferred)
- servers of our subcontractors: SQL Server Express 2005 (preferred)
That's the point where I dont know how to proceed:
Is two-way replication based on files possible at all?
I read about Snapshots, but to my understanding this replaces the "whole database" without caring about changes made to it and that's why it wont work for two-way exchange.
I would appreciate your hints how to solve this problem in general or whether I should look out for other solutions - MS Access might work with restrictions - but I would prefer SQL Server.
Thanks for reading until here and in advance for your answers.
Regards,
Michael__H
View 6 Replies
View Related
