473,320 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

weird database back up sizes

I've got a 9gig DB which when backed up using the gui comes to 5gigs.
When backed using the SQL "backup database" command it comes to 20gigs.
Can someone suggest a good reason for the difference?

Oct 13 '06 #1
2 1313
Am 13 Oct 2006 12:38:34 -0700 schrieb d.******@gmail.com:
I've got a 9gig DB which when backed up using the gui comes to 5gigs.
When backed using the SQL "backup database" command it comes to 20gigs.
Can someone suggest a good reason for the difference?
I think you do not init the backup file so you always do an append. If you
open the 20gig Backup with GUI, i assume it will show you 4 backups in this
file (if one backup has normally 5 gig).

bye,
Helmut
Oct 14 '06 #2
You were absolutely right. Thanks

Helmut Woess wrote:
Am 13 Oct 2006 12:38:34 -0700 schrieb d.******@gmail.com:
I've got a 9gig DB which when backed up using the gui comes to 5gigs.
When backed using the SQL "backup database" command it comes to 20gigs.
Can someone suggest a good reason for the difference?

I think you do not init the backup file so you always do an append. If you
open the 20gig Backup with GUI, i assume it will show you 4 backups in this
file (if one backup has normally 5 gig).

bye,
Helmut
Oct 16 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: LRW | last post by:
I manage our mySQL database through putty (SSH terminal client). And whenever I do a select * from the table that contains ENCODEd passwords, the funky characters do funky things with the display....
0
by: Greenwich Support | last post by:
Hi All, I have a very weird problem which is occurring with a VB.Net app and PostgreSQL 7.3.1. There is a form that has a standard .Net datagrid on it that contains some data from a table in...
3
by: sql-db2-dba | last post by:
When I did db2batch to benchmark a query, it performance details came back with this reading ... "High water mark for database heap = 4291373408" Does this mean it would have caused memory...
5
by: Paul H | last post by:
How do you folks get a reliable and complete brief of what is required before development starts? I am forever going back to a client once a project has started saying "Hang on, now that I've...
1
by: Mythran | last post by:
I keep getting the exception, "Cannot open database requested in login 'dbblah'. Login fails. Login failed for 'domain\user'". I have ASPNET setup as the user in IIS, identity impersonate is true...
12
by: sparks | last post by:
My boss and I both have access 97 and access 2003 installed on our systems. Lately he has been having a lot of problems. Databases that won't close. The database looks like it closes but access...
6
by: xeqister | last post by:
Greetings, We are having a situation here whereby one of our staff created a very huge 32K buffer pool in a production database and caused the database to go down. When we try to reconnect to the...
5
by: John Williams | last post by:
I've been spending some time expanding my rather primitive knowledge of c++ through various exercises. One of them that I've been working on is learning a bit about how compression works. I've...
2
by: Edwin.Madari | last post by:
#your thought is right. ======================================================= def sizes2fields(sizes): d = begin = 0 for i in sizes: if begin: end = begin + i else: end = i...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.