|
by: Andrew E |
last post by:
I just took over DBA responsibilities for an Oracle 8i database
running on Linux. Although I've been working with relational
databases for some time, I'm a bit green on Oracle so forgive me.
My first task was to implement a backup strategy (currently there is
none). I did a great deal of research both on this board and using
the Oracle...
|
by: newbiegca_sqlsever2000 |
last post by:
Question 1
3 GHZ CPU (Intel pentium 4) single cpu + 2 GB Memory + SCSI HDD
Database size 10 GB - How long will full database backup take if the
backup is writing a file to the hard disk (separate hard disk)
Question 2
during this full backup are users and application able to access the
|
by: newbiegca_sqlsever2000 |
last post by:
SQLServer 2000 Backup question.
Let us say we have a database where data is stored in filegroup F1 and
Filegroup F2
Backup of this is done on alternate days
Day 1 - Full backup of file group F1 at 10 pm
Day 2 - Full backup of file group F2 at 10 pm
Day 3 - Full backup of file group F1 at 10 pm
|
by: Louis |
last post by:
This is maybe a dumb question but I couldn't find a definitive answer
on BOL.
Looking at my backup script. If I issue a CHECKPOINT, does this truly
force all transaction log entries to the data file? Therefore, making
it unnecessary to BACKUP log (just BACKUP database is needed).
Louis
|
by: jane |
last post by:
HI,
I had a question on incremental backup.
We had an incremental backup every weekend. We did full backup every
other week. That is one week incremental + full , the other week is
incremental only. My question is for the first weekend incremental
backup, it took for example 1h, but the second weekend incremental
took almost 3 hours. It...
|
|
by: Eric Herber |
last post by:
I've a question regarding db2 (V8.1) and database backups
going to a storage manager like TSM for example.
As I can see in the storage manager if I backup the complete
database over the TSM API (no tablespace backups) the backup
images is stored as a single backup object.
Later I will be able to restore the complete database from
this...
|
by: Trent |
last post by:
Hello, all.
I have the following production DB2 environment.
DB2 8.1.4 (fp4) WG edition with 2 production databases on Windows 2003
standard edition.
My first question is regard with locking. I found some escalations for
X lock on some tables. How do I work out an appropriate MAXLOCK &
LOCKTIMEOUT settings to optimize the lock...
|
by: uthuras |
last post by:
Hi all,
I have DB2ESE version 8.1 with FP 4 on AIX 5.2. My database used to be
1.1TB. When the DB size is 1.1TB, it takes approximately 7 hours to
backup the entire database (online backup). The backup is directed to
disk and not tape.
Recently, we did data archival by purging some of the records. Now, the
size of the database is 500GB...
|
by: manwiththeaxe.70 |
last post by:
I have recently begun to migrate our DB2 UDB v7.2 enterprise databases
up to DB2 UDB v8.2.
One question I can't seem to understand is why would I want to run an
offline backup for a database now that the online backup includes the
necessary log files.
Is there a reason why I would need or want to go through the hassle of
getting...
|
by: jag |
last post by:
hi,
I am thinking about backup strategy. I have couple of questions for my
db2 community brothers.
1. Can i use full online or offline database backup as base for
incremental backup for tablespace? For example, if i take backup of
database A which contain tablespace X1,X2, can i take full offline or
online backup of A and then take...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|