I need to make a backup copy of a file on a remote server. The backup will remain in the same directory on that server. The problem I am having is that the file is large and it appears to be copying it back to the server the code is running on and is taking too much time. Is there a way to make a copy of the file in place without it being sent across the network?
View 4 Replies
SQL Server Express 2005 MS Visual Studio 2005 Using ASP.NET with VB code behind. Requirements: Click a button on an ASPX page to disconnect temporarily all DB connections when not in use to allow a script to backup/copy the database to a safe backup location. When a user access the db afterwords, the DB connections will be re-established.
If this is imposible, recommend an alternative. Note: I am working with what I have been given and authorized to use.
After seeing the Hanselman "You are doing it wrong" video I start to use the Web Publish feature of VS2010.
What I'm really missing is that the websites sometimes gives errors while the site is publishing because the feature does not copy the app_offline.htm file to the server.
I do not want to start using MSDeploy scripts, because I have several sites and want to keep it simple.
Maybe there is a simple tweak to tell the wizard to copy and then delete the file.
Invalid column name 'is_compressed'.
Invalid column name 'compressed_backup_size'.
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
Processed 264 pages for database 'E:ASP.NET4.0_CalculatorhicalcApp_DataASPNETDB.MDF', file 'ASPNETDB_1847a276f17a4e2cb63c95936431bc26_DAT' on file 1.
Processed 1 pages for database 'E:ASP.NET4.0_CalculatorhicalcApp_DataASPNETDB.MDF', file 'ASPNETDB_TMP_log' on file 1.
BACKUP DATABASE successfully processed 265 pages in 0.404 seconds (5.124 MB/sec).
[Code]....
in sql 2008 , itook a databse back up and i got message like "backup completed sucessfully".i gave the backup name as D123.
now the pblm is when i check that backup file, file name is coming without extension and not possible to restore also.
file name is D123 instead of D123.BAK and filetype is showing 03 instead of BAK
where is the problem?is it possible to restore this back up?
I expect that the export file will be backup.sql mysqldump --tables -u db_user_name -p db_name >> backup.sql Furthermore, is there any example for that we insert one record with one image file (from the local disk), to the DB table?
View 3 RepliesI am looking for Backup and Restore . mdf file utility. Is there any opensource application/code available?
View 12 RepliesI need to make a backup file(.bak) of a database(.mdf)
I learned I need to use MS SQL Server management studio Express to do so, but I can't figure it out how.
I don't know how to connect to the database using this program. In the "Connect to Server" dialogue window, I am supposed to choose a server name from the dropdown list, but nothing comes up. What am i doing wrong?
I want send backup statement from my c# code to sql server then sql server return same back up file to my application in varbinary(max). what code is necessary for that?
View 3 Replieswhen I make restore to backup database display this error :
The backup set holds a backup of a database other than the existing 'elib' database. (Microsoft.SqlServer.Smo)
how I can solve this error ?
ok i have a file link not in the vs 2010 project .basically i have a list page in which i want to show the files, one file each for different organization. how can i make a link to that xml file which exists outside the project
View 1 RepliesI have to copy a file from client machine to server folder without use file upload control.
i tried with WebClient().Like this
Dim onbjweb As New WebClient()
onbjweb.UploadFile(Server.MapPath(serverpath), "POST", LocalFilePath).
Its working fine in localhost.When its deployed in server its not working.
In our application, we allow user to upload documents which can be PDF, Doc, XLS, TXT. Uploaded documents will be saved on web server. We need to display link for each document user uploaded and when user click on that link, it should open relevant document. it is expected to have required software to open relevant documents.
To upload document, we use saveAs method of FileUpload control and it works absolutely fine.Now, how to view it?I believe, i need to copy/download file to local user machine and need to open it using Process.Start.For that i need to find user local temp directory. if i put path.GetTempPath(), it gives me web server directory and copy file there.
File.Copy(
sPath + dataReader["url"].ToString(),
Path.GetTempPath() + dataReader["url"].ToString(),
true);
making a file link
View 5 Repliesi am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server)
i am trying to restore back up database .bak into the new database i just created in sql server 2005i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message"You must select a restore source"
Here's the screen shot: (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)
How can i make a downlandable file links in asp.net mvc for downloading the files.Also how can i show the file as thumbnail in my page in asp.net mvc.
View 4 RepliesFor my project(in asp.net) i wrote near 1000 lines of c# code for one asp.net page.It includes so many functions.The problem is,it is going complicated while i am writing more codes on one page.How can i make multiple c# files for one asp.net page?? I tried by adding new class in VS2008.But calling a function from one file to other is making error(item is not present in current file).How can i do that??
View 6 RepliesMy goal is to take some form inputs and prompt the user to download a summary of everything once a certain button is clicked. I have no need for the file once it is downloaded and so I'd like to have a solution where the data is streamed directly to the user. My current solution doesn't even prompt the user for a download. Can anyone point out what I'm doing wrong?
I've got it wrapped as a webmethod and so I needed to add a definition of the _Default page class so I could access certain things.
[Code]....
this wasn't mentioned earlier but the webmethod is being called by an AJAX request!
i am coding fr taking databse backup frm my asp.net web application
i get the backfile in .bak form. how do i zip it. make it in zip form
I have an internet explorer shortcut on my desktop that I am trying to copy to other machines. I am getting a file does not exist error (source file). I know the source file is there, but I still get the error. Here is the line of code where I am getting the error. I have tried with lnk and without lnk extension.
File.Copy("C:Documents and SettingsadminDesktopEmergencyBreakDow... strPath, True)
I am trying to copy a picure fil(jpg) to another server. I am using this code but for some rezone is the file corupted once it arrives to the other server.
Code:
Dim myFtpWebRequest As FtpWebRequest
Dim myFtpWebResponse As FtpWebResponse
Dim myStreamWriter As StreamWriter
Dim filename As String = Request.QueryString("filename")
filename = filename.Replace("../incoming/mms/", "")
myFtpWebRequest = WebRequest.Create("ftp://bklmydomain/wwwroot/" & filename)
[code]...
the source file: [URL]
I want to save as this file as "eurofxref-daily-yesterday.xml" under the root directory..
using c#..how can I do that ?
i trying to copy data from excel file to sql db I am using sql BulkCopy for this pruposein c# the following statement keep producing an error:
for(i=0;i<DataSetRows;i++)
{
SqlBulkObj.ColumnMapping.Add(MappingDataSet.Tables[0].Rows[i]["Source"],MappingDataSet.Tables[0].Rows[i]["Source"]);
}
I have an ASp.net application using C#. I need to copy a file present on the web server machine to a remote machine on the network. Although this seems to be a trivial matter I am having difficulties copying the exe I am Trying
string Source = @"c: emp est.exe"
string Destination = @"Z: est.exe"
File.Copy(Source, Destination, true)
Z: is mapped to the Remote machine network drive. I am able to physically copy files to this drive from the Web Server machine, but when I try from ASp.net, I get the following error System.Io.Exception: Logon Failure: unknown user name or bad password
I think it has to do with the Web Server using the ASPNET user , which does not have the right credentials on the remote machine. I do not know how to solve this issue I tried using WMI too, I was able to copy files from one directory to another directory on the remote machine, but not from the Web Server machine to Remote machine
I am creating a PDF template file and I will want to use that to create other files. I have been looking around and found the following code:
[Code]....
The problem is that pdfreader, pdfstamper, acroreader are underlined and it says it is not declared so I couldn't test it, I wasn't sure what I had to import in order for it to work. In addition, if you have any other way that is easier to use let me know.
