Program To Backup Database And Copy To Another Comp
Nov 8, 2010
i have i problem when making some program to backup database sql server 2000. i have task to develop program with requirement like this:
1. this program must backup database from sql server 2000 (success).
2. this program must compress the backup to the smaller size (Not success,because the backup file is more than 3,9 Gb. i am using SharpZip Wrapper and not succes because the size exceeded.)
3.Copy the backup file or compress to another computer (Succes but take a long time because the size of file is more than 3,9 Gb. That's why I want compress the file.)
any one can give me solution for compress large file with size more than 3,9 Gb. This file will continue to grow in size,so i need compress it so i can copy more quickly?
or any one can reference some freeware can do the task?
View 5 Replies
ADVERTISEMENT
Oct 19, 2009
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
[Code]...
View 2 Replies
Dec 28, 2009
How to backup ms access database in vb.net?We're gonna make a system for a certain company but our teacher doesn't teach us at all
View 1 Replies
Jun 12, 2011
How to take backup of database from sql server2005 using vb.net with the help of code
View 1 Replies
Dec 15, 2010
I am trying to do a back up of files and was needing to know how to do something like
[Code]...
View 6 Replies
Nov 29, 2011
i want to make a small application about backup so i want to make two buttons , the first one for choosing the source file and show in text box no(1) secondly, i mean a second button for place of new path for that file ( destination for backup file)
View 6 Replies
Oct 29, 2009
Im trying to create an incremental backup utility on a web form using vb.net for code behind.
So far i can copy files from directories including sub directories and that part works fine, my main problem is copying only the most recent / modified files to the backup folder, currently it is moving all the files each time.
Below is my code so far.
CODE:
View 5 Replies
Mar 18, 2009
How can i make my app execute some code at specified day/time (Day/minutes/secconds)?I need to make a scheduled app that will backup(copy) some files at specified time/date.
View 4 Replies
Jan 25, 2010
ive created a program in VB 2008 and i cant remember how to publish it in such a way that it includes the database that the program uses. At the moment when i publish it, it only works on my system because i have the database on my PC, if i delete the database from my pc the program messes up because it doesnt have a copy of the database in its program resources etc.how do i publish the program so that it includes a copy of the database that it needs to function?
View 6 Replies
Oct 13, 2011
I'd like to know how to restore my database in visual basic. the code i used for backing up is[code]...
View 2 Replies
Jan 7, 2010
Is it possible to make a little backup program that can backup from one folder to another, is this much work? With a calender also that can be picked up so you can chose when the backup starts.
Im thinking about f.example 10 lines where you can chose where to backup from (different folderes) And one line where the backup shall be saved. All this with browse folder off course. And with a button backup now and a button backup from the date. A very little program with an easy use.
View 1 Replies
Nov 2, 2010
create automatic backup of database in vb 6.0.Im using ms Microsoft SQL Server 2005 express edition..
View 1 Replies
Jan 18, 2010
I am using vb.net and sql server 2000 for developing windows applications. I want to know how to take the backup of database for after each and every transactions. is it possible? if possible,
View 6 Replies
Jun 21, 2010
First off I am programming a hotel booking system for my college computing project. This consists of a bunch of windows forms coded in Visual Basic, and an Access database stored locally. The application gets information for the forms about customers, bookings etc... from the database.I would just like a way of making a complete copy of the database (.mdb) file and placing it into a user selected destination.
View 2 Replies
Jun 3, 2011
i want to sql database backup through the vb.net code.
View 2 Replies
Jun 3, 2011
I want to backup and restore the database by using vb.net.I have a problem here..This dialogue box appear.
"
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'C:Documents and SettingsSMy Documentssales.Bak'. Operating system error 5(Access is denied.).
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
"
View 3 Replies
Apr 29, 2010
I am writing a database application with Access 2007 and VB.net 2008.Is there a way in VB.net to backup and restore the database?
View 3 Replies
Apr 16, 2008
"How to backup database SQL SERVER from VB NET?"
View 9 Replies
Jun 21, 2008
I am visual studio 2005(VB.NET) and MYSQL 5.0 as Database. I want to Backup my Database. I am using the following but the result is in 0 KB.Process.Start("C:Program FilesMySQLMySQL Server 5.0
inmysqldump.exe", "--user=root --password=root --host=3306 --databases MySQL hospitality -r ""C:BackUpDataBase.sql""")
View 3 Replies
Nov 15, 2010
My application has an access2007 db as its database. I am trying to create a backup/restore utility in my application that allows the user to take the backup or restore the database file "StudentsData.accdb" which is in the application folder. I tried the filecopy method but it gives me an error saying that the "file is not accessible, as it is being used by a process." I believe it is my application process that is using the file.
How do I stop my application accessing the database? I have database connections which i have written in code and all of them close with their respective forms.
View 6 Replies
Jun 5, 2011
i have a problem with using vb.net application, i want to take backup of my database from my vb.net application so that user clicks the button and backup can be copied in a drive .
View 1 Replies
Jun 1, 2009
I'm working on a Warehouse Item locator. I use an Access database for all the information and I made a backup so after all the change are made, I can keep a copy of the database in case something happen.
View 1 Replies
Jun 5, 2008
What is the best method to backup a sql database.Would it be simply to copy over the database to a seperate location or is there a proper sql way of doing this?
View 2 Replies
Jun 10, 2011
how can i take backup on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example.
View 11 Replies
Jan 13, 2012
I am using the following function to backup a SQL Server database using SMO.. but the backup fails... I have no idea, why does it fail...
[Code]....
View 1 Replies
May 22, 2009
I am using vb.net and ms access for developing windows applications. I want to know how to take the backup of database for after each and every transactions.
View 2 Replies
Apr 16, 2009
I want to find out the time at which the system is done booting and want to retrieve that time and write it into a text file. I know how to write into a text file, I just need to know the other part-the keyword, if thats what it's called.Is it possible to find out every time a new window is opened ( it can be a n application, an .exe or any ordinary file), to retrieve the name of it and the source ?
View 1 Replies
Jul 28, 2009
Here is the problem in a nutshell I made a prog using newest freebie (vb express)I made my autorun.inf I want this prog to run from a cd, not to install, but to just run.however, some of the old computers around the office do not have the latest .net framework therefor they won't play.as this cd will be redistributed to clientell and i cant go upgrade their comps it is not feesable to just say "well upgrade the computer dummy"I need to know if it's possible to run a starter prog or even a line of code in my main prog that will check their .net ver and if it's not uptodate, i want it to update before running my prog from cd (so that my prog will run on their comp, even if its old)dont kare where update comes from, prefably from cd
View 3 Replies
Oct 14, 2011
I have built a browser, and it runs fine on my computer. I built it using framework 3.5I am trying to put it on my wife's laptop, and I verified that she has the framework 3.5 on her comp. It wont run. It just crashes. Do you know how to fix this?
View 6 Replies
Feb 23, 2012
im trying to make a auto mysql backup for my vb program. this code is working but i want to hide the console window so the user will never notice that something happened.
Process.Start("C:/wamp/bin/mysql/mysql5.5.16/bin/mysqldump.exe", "-uroot coop usertrails --skip-add-drop-table -r ""C:ackup.sql")
View 3 Replies
