backup of transaction log

Hello all,
Disaster recovery scenario ques: I am taking full backups of my SQL Server d
atabase each midnight on tape and moving it off-site. I then take differenti
al backups and also want to backup the transaction log. Assuming that my pro
duction database server is
on site and the site is burned down, how do I recover my transaction logs fr
om? Do companies usually move transaction logs off-site as well?
Where are transaction logs generally stored to facilitate in disaster recove
ry? Thanks in advance for the help!
- BillHi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pr...n/logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
> Disaster recovery scenario ques: I am taking full backups of my SQL Server
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
> Where are transaction logs generally stored to facilitate in disaster
recovery? Thanks in advance for the help!
> - Bill|||HI
Create Disaster recovery Plan
Create job for disaster recovery solution as disaster recovery plan describe
.
Step 1.
Backup the database(s) to backup device based on current time and weekday
(Physical file located on file server, this file backed up to tape)
Step 2
Copy backup file(s) to off site server
Step 3 (Optional)
Restore database(s) on off site server
Decrease the backup time:
-Full backup saturday or sunday only, another weekdays create differential b
ackup.
-Create the backup devices:
Use backup devices with INIT (overwrite) option (Tape backups from file serv
er store old versions as need)
DB_Name_full
DB_Name_diff
DB_Name_log1
DB_Name_log2
...
Create Stored Srocedures for Disaster Recovery for all cases.
You can on remote server restore the database manually, or from job (You mus
t create SP-s).
BOL: BACKUP and RESTORE
JBandi|||Hari and Andras, Thank you for the insights!
-- Hari wrote: --
Hi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pr...n/logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
recovery? Thanks in advance for the help!
> - Bill