Solved

SQL 2000 database Restore error from TAPE

Posted on 2007-11-20
10
1,017 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:tech2010
Comment Utility
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
Comment Utility
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 18

Expert Comment

by:Yveau
Comment Utility
... 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
Comment Utility
yes :(
0
 
LVL 18

Expert Comment

by:Yveau
Comment Utility
... 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
Comment Utility
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
Comment Utility
thanks
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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 walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

728 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now