SQL Online Backup...

Arijit Chatterjee

Dear Friends,
I don't know anybody has asked this question before or not.But I need
a support urgently.How to take online backup in MS Sql server 2000.
Thanks
Arijit Chatterjee

Jul 20 '05 #1

Subscribe Reply

5576

Simon Hayes

ar*****************@yahoo.co.in (Arijit Chatterjee) wrote in message news:<ea**************************@posting.google. com>...

Dear Friends,
I don't know anybody has asked this question before or not.But I need
a support urgently.How to take online backup in MS Sql server 2000.
Thanks
Arijit Chatterjee

What do you mean by an "online" backup? If you mean how to backup a
database without stopping MSSQL or taking the database offline, then
that is how all backups work. In other words, you can always do this,
even with active users connected to the database:

backup database MyDB to ...

There is a lot of information in Books Online about backup and restore
operations, so you might want to read up on this. If that doesn't
answer your question, perhaps you could give some more detail on what
your problem is, and what exactly you mean by an "online backup"?

Simon

Jul 20 '05 #2

Scott S.

On 17 Jul 2003 00:55:31 -0700, ar*****************@yahoo.co.in (Arijit
Chatterjee) wrote:

Dear Friends,
I don't know anybody has asked this question before or not.But I need
a support urgently.How to take online backup in MS Sql server 2000.
Thanks
Arijit Chatterjee

I know of a company that does online backups and specializes in open
source backups (MS Exchange and SQL Server). If you want more
information, contact me offline.

Scott

Jul 20 '05 #3

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

DB2 Database

Online Tablespace restore from incremental backups

by: Raj | last post by:

How can we do an online restore of a tablespace using the incremental backup's? we are on a partitioned database... Also, how could we use backup copy made by the load (using the copy to option...

DB2 Database

Online Backup

by: Gladiator | last post by:

Hai..... I have a database............ i took an online backup for tht..... After tht mistakenly i dropped the database.......... now i dont have the logs also....... now after i restore the...

DB2 Database

Online backup to restore onto another system (or for disaster recovery): how to?

by: Konstantin Andreev | last post by:

Hello, everybody. I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with Examples", but still unable to answer this simple...

DB2 Database

What is ONLINE BACKUP intended for ? Is it fake feature ?

by: Konstantin Andreev | last post by:

Hello. Some time ago I asked in this conference, - How to use an ONLINE BACKUP to restore database onto another system? - but got no answers. Therefore I can conclude it is not possible. But......

DB2 Database

Restore online backup and roll forward just the logs stored in it.How?

by: aj | last post by:

DB2 LUW v8.2 FP 14 RHAS 2.1 I have a DB2 online DB backup that was done w/ the INCLUDE LOGS option. I am interested in restoring that backup, and rolling forward ONLY the logs contained in the...

DB2 Database

Which transaction log files are obsoleted by BACKUP ONLINE?

by: Konstantin Andreev | last post by:

Hello, all. I can't figure out <subjectfrom documentation. I had configured LOGARCHMETH1 = DISK:/bak/logs so all full log files are copied *out* of the active log path. Let I issue | #...

DB2 Database

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

BAckup online with include logs fails !!!

by: alex250374 | last post by:

Hi all, db2 9.1 fixpak 0 aix 5.3 I have a big problem every time I start an online backup with include logs via veritas comes out an error!!! The db2diag shows:...

DB2 Database

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

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

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

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

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

php

by: muto222 | last post by:

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

PHP

Similar topics