Can users be connected during a SQL backup?

esource

We have a existing backup, re-index job that runs at night on an
existing database that is now accessed by web users 24/7.
Problem is that one of the steps is to kill all users before backup
starts so it kills any transactions that are happening at that time
question is... Can users be connected during a backup? Will removing
the kill users step slow the backup alot?
any other suggestions would be appreciated.
thanks

Mar 19 '08 #1

Subscribe Reply

3510

Russell Fields

esource,

Backups run fine with people logged in and working. Users will not slow the
backup a lot much and backups should (in fact) be done without requiring
clearing out the users.

RLF

"esource" <da********@shaw.cawrote in message
news:87**********************************@s13g2000 prd.googlegroups.com...

We have a existing backup, re-index job that runs at night on an
existing database that is now accessed by web users 24/7.
Problem is that one of the steps is to kill all users before backup
starts so it kills any transactions that are happening at that time
question is... Can users be connected during a backup? Will removing
the kill users step slow the backup alot?
any other suggestions would be appreciated.
thanks

Mar 19 '08 #2

by: Joseph | last post by:

Hi I'm writing a commercial program which must be reliable. It has to do some basic reading and writing to and from files on the hard disk, and also to a floppy. I have foreseen a potential...

Java

Page fault during backup

by: alex | last post by:

Hi ! I couldn't make backups with our new system using db2 8.2. Every time I trigger a backup I get this error message: BACKUP DATABASE EBUERO2 ONLINE TO "/raid/backup/ebuero2/part1",...

DB2 Database

"Bad container path" during Backup?

by: Norbert Munkel | last post by:

Hi, System: 8.1.5 UDB on SuSE Linux I created a new SMS tablespace with following ddl: CREATE REGULAR TABLESPACE ASNCTL IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY...

DB2 Database

Multiple Users

by: Berj | last post by:

i have a novice question. is Access multi-user? can multiple users access the same database?

Microsoft Access / VBA

Users not connected query

by: Andy Davis | last post by:

I have a two tables, Users and Requests, the latter which displays the daily log on's of 20 users. Both tables are related by a one-to-many relationship in the Requests table via the UserId field....

Microsoft Access / VBA

DBHEAP usage during backup

by: Joachim Klassen | last post by:

Hi all, Env: DB2 ESE/DPF 8.1.6 64 Bit on AIX 5.2.0 we recently had problems with an offline backup of a database with 5 partitions that fails with SQL0956 - Not enough storage in dbheap....

DB2 Database

Backup users

by: Kittikun | last post by:

I am currently using the BACKUP DATABASE method to backup my database. Everything works fine, except for users. I created various users with sp_addlogin to access this database and they are located...

Microsoft SQL Server

Lock waits during online backup

by: michael.spoden | last post by:

Hi, how can I fix lock-waits during an online backup? Is an online backup in DB2 V8.2 not realy online? I'm using DB2 V8.2 Fixpak 15 on Linux. The command to perform the backup is: db2 backup...

DB2 Database

DB2 9.7 High response time on 50 concurrent users

by: sanjupommen | last post by:

I am in the process of exploring the possibility of providing our products on databases other than Oracle.I am able to migrate the data, procedures etc without too much effort (latest version of DB2...

DB2 Database

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

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++

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

AI Job Threat for Devs

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,...

Career Advice

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

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

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

Can users be connected during a SQL backup?

Similar topics