Solved

SQL 2000 database Restore error from TAPE

Posted on 2007-11-20
10
1,026 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
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.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
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…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

828 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