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?



ADVERTISEMENT

Incrementally Backup MS SQL Server 2005 Database By Program That Uses The Database Also

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 View Related

Backup Ms Access Database In Program?

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 View Related

Take Backup Of Database From Sql Server2005 Using Program With Code?

Jun 12, 2011

How to take backup of database from sql server2005 using vb.net with the help of code

View 1 Replies View Related

File.Copy For Backup?

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 View Related

Backup Code ( Copy And Paste In Vb 2010)?

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 View Related

Backup Utility - Copy Modified Files

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 View Related

VS 2005 Make A Scheduled App That Will Backup(copy) Some Files At Specified Time/date?

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 View Related

Deployment :: Publish Program So That It Includes A Copy Of Database That It Needs To Function?

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 View Related

Backup And Restore A DB In Program?

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 View Related

Make A Little Backup Program?

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 View Related

Backup Database In VB?

Nov 2, 2010

create automatic backup of database in vb 6.0.Im using ms Microsoft SQL Server 2005 express edition..

View 1 Replies View Related

Database Backup Using .net?

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 View Related

Backup Access Database In .NET?

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 View Related

Backup An Access Database?

Jun 3, 2011

i want to sql database backup through the vb.net code.

View 2 Replies View Related

Backup And Restore The Database By Using .net?

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 View Related

Backup And Restore The Database?

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 View Related

Backup Database SQL SERVER?

Apr 16, 2008

"How to backup database SQL SERVER from VB NET?"

View 9 Replies View Related

Backup MYSQL Database Via .NET?

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 View Related

Backup Of Application Database?

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 View Related

Database Backup From .net Application?

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 View Related

How To Restore Backup Database

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 View Related

Method To Backup A Sql Database?

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 View Related

Oracle Database Backup Using VB

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 View Related

SMO Database Backup Fails

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 View Related

Take The Backup Of Database For After Each And Every Transactions?

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 View Related

Just After A Comp Is Done Booting

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 View Related

Proj From CD To Any Old Comp?

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 View Related

Running Exe On Another Comp?

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 View Related

Make A Auto Mysql Backup For Vb Program?

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 View Related

Using Program 2010 To Create A Data Backup Though Vpn?

May 24, 2012

I'm been searching for a while for a way to create a vb 2010 program that automatically checks and compare the files you have at a specific location in your hard drive and backup/update them securely though a vpn when a button is clicked.

View 1 Replies View Related

VB Databases - Backup The Data Stored In A Program?

Sep 29, 2010

I developed a program using Vb.Net that is data based enabled, it has a field for serial number etc. its working fine but the serial number failed to update when a record is deleted, its always keeps tracks of its formal numbering, even when the program is restarted, unless reinstalled.How do i also backup the data stored in such program.

View 6 Replies View Related

Auto Backup Database Sql Server?

Dec 18, 2009

Or anybody can tell me : HoW can create storeprocedure which contains this code.I created a store procedure but it cant be saved.If i create a storeprocedure which contains this code then problem will resolved.

[Code]...

View 3 Replies View Related

Backup And Restore Mysql Database Using .net?

Mar 17, 2012

I'm creating a program with database and it almost done. The only one thing that left is the backup and restore of database. I don't know how to do this.

View 9 Replies View Related

Backup Database Into Documents And Restore It?

Mar 10, 2012

is there a wat to backup my database into my documents and restore it,

(i am using datagrid to view my ms access as database)

View 1 Replies View Related

Backup Database To A Location And Restore It Afterwards?

Dec 31, 2009

I want to Backup my Database to a location and restore it afterwards. The problem is , i want to keep my program open. I seem to have a problem with this, the connection stays open. How can i do this , close connection and open it again without data loss?

View 7 Replies View Related

Backup My Sql Express Database Programmatically?

Jan 3, 2011

i want to backup my sql express database programmatically using vb.net,

View 1 Replies View Related

Backup SQL 2005 Database Using Code

Jun 21, 2010

I have designing a desktop application with SQL SERVER 2005. I have one form where user can take a full backup of SQL Database in one File.

I have following controls :

1. txtSQLServerName
2. txtSQLDBName
3. txtSQLSQUserID
4. txtSQLSAPassword
5. txtBackupLocation
6. btnStart
7. btnCancel

When user process the backup, it should take a backup in specified location. The backup file should be like "BKP_F_YYYYMMDDHHMMSEC" e.g. "BKP_F_20100406131523.BAK" (where 2010 = Year, 04 = Month, 06 = Date, 13 = HOur, 15 = Minute, 23 = Second). When user process a backup on next day the backup file name should be same as the above with the different date and time. And i want this backup should be encrypted with password so that other person cannot restore my database.

View 4 Replies View Related

Backup, Shrink And Delete SQL Database?

Aug 2, 2010

I need to backup sql database, below is my VB code to do backup, shrink and delete. But I have problem to shrink the database. Need your help to find what's wrong for the shrink potion. the error happened when execute CmdShrink.ExecuteNonQuery().


[code]...

View 2 Replies View Related

How To Take Backup Of Access Database Through Coding

Jun 22, 2010

Anyone know how to take backup of Access database through Coding in vb.net.Means when i click on button ,the folder should be automaticaly created and that folder contains Access database file with current entered records means updated database.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved