Solved

SQL 2000 database Restore error from TAPE

Posted on 2007-11-20
10
1,024 Views
Last Modified: 2013-12-01
I am trying to restore SQL 2000 database called 'CBAS' from tape using backupexec 9.1 but i am getting following error message. I can restore others SQL databases on the same tape on the same server but it is just with this perticular database 'CBAS'. I think according to the following error it seems that this database backup contains more than one log files and while restoring, backupexe try to combine into one log file 'cbas_log.LDF' and fails.

I donot know how and where to use WITH MOVE clause under veritas backupexec.

Please help me to solve this issue and advise a working solution. thanks.

An error occurred on a query to database CBAS.
File 'T:\CBASLOG\cbas_log.LDF' is claimed by 'CBAS_1_Log'(4) and 'CBAS_Log'(2). The WITH MOVE clause can be used to relocate one or more files.


thanks & regards
Kamran
0
Comment
Question by:tech2010
  • 5
  • 4
10 Comments
 
LVL 18

Expert Comment

by:Yveau
ID: 20322617
First try to find out what is in the backup set using
    RESTORE FILELISTONLY (http://technet.microsoft.com/en-us/library/ms173778.aspx)
or
    RESTORE HEADERONLY (http://technet.microsoft.com/en-us/library/ms178536.aspx)

Then - as you stated - try to restore using the move clause (see code snippet).

hope this helps ...

RESTORE DATABASE [Yveau] 
FROM    <device> 
WITH    MOVE N'Yveau' TO N'Z:\Yveau.mdf'
,       MOVE N'Yveau_log' TO N'Z:\Yveau_log.ldf'
,       ...
GO

Open in new window

0
 

Author Comment

by:tech2010
ID: 20323316
Where you want me to run RESTORE FILELISTONLY command, as i have two seperate servers, one is SQL 2000 where i am trying to restore database and second which is my tape backup server from where i am trying to restore from?

Kamran
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20323564
SQL Server, and I asume you have a backup device defined that is connected to the backupexec 9.1 ? Or does Backupexec runs the backup ?

If the latter is the case, I have no experience with that ...
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:tech2010
ID: 20326419
Backupexec runs the backup for SQL via backupexec agent on SQL box. Do I need to define backup device on SQL box which then connect to backup tape server? Also how to define backup device ?

Regards
Kamran
0
 

Author Comment

by:tech2010
ID: 20326599
Please ignore my previous message.

I have one SQL 2000 server directly connected to backup device, i have created backup device under sql enterprise manager but when i clicked on 'view contents' it gives me error message "Error 3241 Media Family on device '\\.\Tape0' is incorrectly formed, SQL server canot process this media family. RESTORE HEADERONLY is terminating abnormaly"

please tell me how should i fix this issue, i have SQL SP4 already installed as well.

Kamran
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20330527
... as I said, I don't connect my SQL Servers directly to the BackupExec. I make a local backup to disk and than tell BackupExec (or currently NetBackup) to come and get the files in the backup folder as soon as I'm done making the backups.

... you get the error when the correct tape is loaded ?
0
 

Author Comment

by:tech2010
ID: 20331168
yes :(
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20331217
... sorry, really have no experience with your setup ... I hope some of the BackupExec guys will pick up from here ...
0
 
LVL 2

Accepted Solution

by:
DennisPost earned 500 total points
ID: 20721838
Hi Tech2010,

Just to let you know, I have a similar problem. Here's my question.
http://www.experts-exchange.com/Storage/Backup_Restore/Backup_Exec/Q_23090369.html
I also added a pointer in my question to this one.

Could you please post the tsql you used when your error occured.
I have not been able to restore any database from tape, I need to redirect and/or rename it.

Here's what I found about the MOVE cluase in BOL: (RESTORE DATABASE TSQL Reference)
MOVE 'logical_file_name' TO 'operating_system_file_name'
Specifies that the given logical_file_name should be moved to operating_system_file_name. By default, the logical_file_name is restored to its original location. If the RESTORE statement is used to copy a database to the same or different server, the MOVE option may be needed to relocate the database files and to avoid collisions with existing files. Each logical file in the database can be specified in different MOVE statements.
Note  Use RESTORE FILELISTONLY to obtain a list of the logical files from the backup set.
For more information, see Copying Databases.
n
Is a placeholder that indicates more than one logical file can be moved by specifying multiple MOVE statements.

EXAMPLE
D. Restore a database and move files
This example restores a full database and transaction log and moves the restored database into the C:\Program Files\Microsoft SQL Server\MSSQL\Data directory.

RESTORE DATABASE MyNwind
   FROM MyNwind_1
   WITH NORECOVERY,
      MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf',
      MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf'
RESTORE LOG MyNwind
   FROM MyNwindLog1
   WITH RECOVERY
0
 

Author Closing Comment

by:tech2010
ID: 31410181
thanks
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question