473,325 Members | 2,792 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

SQL SERVER BACKUP problem in different DEVICES


Hi there,
I need to take a backup with the following scanerio in mind:
At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in
c:\
Then at T2 I would like to take only the differential BACKUP of the
Transaction log called BACK_1_TRANSLOG.BACK and at T3 I would like to
take
only the differential BACKUP of the Transaction log called
BACK_2_TRANSLOG.BACK. At T4 my system fails and I need to bring the
database
to a point where my T3 state is in. I tried taking the backups in DEVICE
but
I always get an error from SQL Server Enterprise manager such as
Volume on Device 'Device2' is not part of a family media set. BACKUP
WITH NO
FORMAT can be used to form a new media set. BACKUP LOG is terminating
abnormally.

If someone can give suggestions on how to backup and restore in this
situation it will be really helpful.
Thanks
John


*** Sent via Developersdex http://www.developersdex.com ***
Jul 23 '05 #1
1 2075
John Rajendran (jo************@xiotech.com) writes:
I need to take a backup with the following scanerio in mind:
At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in
c:\
Then at T2 I would like to take only the differential BACKUP of the
Transaction log called BACK_1_TRANSLOG.BACK and at T3 I would like to
take only the differential BACKUP of the Transaction log called
BACK_2_TRANSLOG.BACK.
I don't think there is any real confusion here, but I like to straighten
out the terminology. In SQL Server you have three forms of backup:
1) Full backup
2) Differential backup
3) Transaction-log backup

The first two backs up what is in the data file, where as the last backsup
the transaction log. A translog backup permits you to restore the
database to about any point in time, not necessarily one at which you
took a backup.

Most backup scheme for production schemes includes a full backup and
a translog backup. Differential backups are not equally commonly used.
At T4 my system fails and I need to bring the database to a point where
my T3 state is in. I tried taking the backups in DEVICE but I always get
an error from SQL Server Enterprise manager such as Volume on Device
'Device2' is not part of a family media set. BACKUP WITH NO FORMAT can
be used to form a new media set. BACKUP LOG is terminating abnormally.


I don't know the dialogues in Enterprise Maanger well, as I mainly use SQL
command to backup and restore databases. But it appears as if you are
trying to use backup devices rather than just a plain filename. Backup
devices are mainly for tapes and that.

While using EM may be convenient for a while, you probaby make it
better in the long run, by reading about the BACKUP and RESTORE
commands in Books Online. Once you have scripts developed, you have
something which you can keep canned and easily use in case of a
disaster.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: peter wang | last post by:
Hi, Could anyone tell me the backup strategy for a 1000GB database? Thank you! Peter Wang *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in...
3
by: jaekim | last post by:
Hi. I am wondering if it is a good idea to replicate sql server db files using frs. I don't really know how the frs works, so does frs replicates the whole database from time to time or just...
2
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...
3
by: yoda | last post by:
Hi Guys, I've been used to deploying code to the production server by checking out of subversion and manually sorting out any kinks. (yes, I know, it sounds primitive) I realize I'm losing so...
5
by: David | last post by:
I am a little confused by DB2 Backup and Export. I used "db2 backup db QAS to /dev/rmt0" backuping 650GB database to a IBM LTO 3581 (1 drive) only 11 hours. But I used "db2 export to /dev/rmt0...
5
by: shenanwei | last post by:
I have a primary server and backup server located in different physical sites. The primary server is live and ship logs to backup site every 5 minutes. The primary server is being full online...
1
by: Catadmin | last post by:
I was told to post this in one of the dotnet groups. I hope this is the correct one. Several months ago, I took the official Microsoft 2733B course to upgrade my skills from SQL 2000 to SQL...
5
by: smoi | last post by:
Hi all, My manager ask me to do backup for 3 database and restore them in a new server. I did the backup for the 3 database into BAK file. Then in the new server, when I did the restore in SQL...
0
by: powernet88 | last post by:
I encountered a problem when I installed SQL server 2005, Can anyone help? There is a waring message in System configuration Check When I tried to install SQL server 2005: Warning: SQL Server...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.