Restricting database backup file size

Pekka Henttonen

Is there a way to limit the size of a database backup file (instead of one
huge file to have several smaller ones)? The command does not seem to have
any suitable options, as far as I can see.

Nov 12 '05 #1

Subscribe Reply

2073

Mark A

"Pekka Henttonen" <NO*********************@kolumbus.fi> wrote in message
news:1h*****************************@40tude.net...

Is there a way to limit the size of a database backup file (instead of one
huge file to have several smaller ones)? The command does not seem to have
any suitable options, as far as I can see.

You can specify multiple directories for the backup image, and DB2 will
split it that way. Not sure if that will work for you the way you want it
to.

Nov 12 '05 #2

Fred

"Mark A" <ma@switchboard.net> wrote in message news:<qn*****************@news.uswest.net>...

You can specify multiple directories for the backup image, and DB2 will
split it that way. Not sure if that will work for you the way you want it
to.

When multiple paths are provided, the backup utility does not enforce
a perfectly even distribution of data across all of the files. I've
taken backups where four paths were specified: two on RAID1+0, and two
on regular disks, and the files on the RAID arrays were bigger,
presumably because they took less time to write their extents.

Fred

Nov 12 '05 #3

Similar topics

21182

Database size question

by: dchow | last post by:

Our database size is currently 4G and is incrementing at a rate of 45M/day. What is the max size of a SQL database? And what is the size beyond which the server performance will start to go down?

Microsoft SQL Server

3476

Hourly batch process locking my database

by: Sam | last post by:

Hello everyone, I have around 20 reports in an ASP web-application which connects to a SQL Server 2000 dB, executes stored procedures based on input parameters and returns the data in a nice...

Microsoft SQL Server

11596

Database and Log maintenance

by: serge | last post by:

Running SQL Server 2000 Enterprise Edition SP3. The database is also used by Microsoft Project Server 2002 and also has OLAP views, so the database is being used to view/run cubes in the Analysis...

Microsoft SQL Server

2212

How to find the size of the database dump.

by: Nabhonil Sinha | last post by:

hi, There is facility to do backup of the database. I can use that facility to backup the database. But before i do a backup i want to check if the disk space available enough to backup that...

Microsoft SQL Server

3217

need to restore old database (database server 4.01 AIX)

by: HSP | last post by:

hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup...

DB2 Database

7138

MS Access Database File Size smaller then previous version

by: Knick via AccessMonster.com | last post by:

I am novice to MS Access Development, I regularly back my access database every 2, 3 days ...today when I was going to back my database I saw the access file on the network drive was only 9 MB...

Microsoft Access / VBA

5624

Database Tripled In Size!!

by: Neil | last post by:

Yikes! My database, which had been consistently 1 gig for a long time, went from being 1 gig to 3 gigs overnight! Looking at the nightly backups, the database increased on average about 5-15 MB per...

Microsoft SQL Server

2249

Is there anything else to gather database size info?

by: Laurence | last post by:

Hi folks, My database DB03 is circular logging. I called the db2 procedure: get_dbsize_info to get the database size as below: Parameter Name : SNAPSHOTTIMESTAMP Parameter Value :...

DB2 Database

3475

does this backup sequence commit all data to the database

by: Roger | last post by:

backup log testdb with truncate_only DBCC SHRINKFILE (testdb_log, 100) WITH NO_INFOMSGS backup database testdb to disk = '\\DC01\Backups\DB01\testdb.bak' with init and does the shrinkfile...

Microsoft SQL Server

7082

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

6953

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7105

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7144

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6813

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

4529

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3041

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

592

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

235

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General