Veritas-bu

[Veritas-bu] SQL restore (move) failed with code 5

2007-02-27 04:53:20
Subject: [Veritas-bu] SQL restore (move) failed with code 5
From: rolfcolmer at hotmail.com (Rolf C)
Date: Tue, 27 Feb 2007 09:53:20 +0000
Is it possible to restore a SQL database to the same SQL instance using a move 
template? Thus, we do a backup of a Virtual SQL database called 'example' which 
runs on a virtual instance SQL-V2. At this time this instance physically runs 
on node SQL-N0. This runs without problems. Then we use the Move template below 
which moves the database to the same Virtual instance (SQL-V2) but with a new 
name (27feb) All the tests we run ends with status code 5. Is it supported to 
use the move template to copy/rename a database to the same SQL instance? #  #  
This is a template for the database MOVE command.#  OPERATION RESTOREOBJECTTYPE 
DATABASERESTORETYPE MOVE#  #  Replace the database name in the following line 
with the name of the database that you#  want to move to. Also remove the hash 
mark <#> which precedes the keyword <DATABASE>.#  DATABASE '27feb'# #  Replace 
the file path <S:\MSSQL\DATA\example.mdf>#  with a new file path. Also remove 
the hash mark <#> which precedes the keyword <TO>.#  The target of the MOVE 
keyword must be 'Sharepoi1_SITE'. MOVE  'example'TO  'T:\27feb.mdf'# # #  
Replace the file path <S:\MSSQL\DATA\example_log.LDF>#  with a new file path. 
Also remove the hash mark <#> which precedes the keyword <TO>.#  The target of 
the MOVE keyword must be 'Sharepoi1_SITE_log'. MOVE  'example_log'TO  
'T:\27feb.ldf'#  
_________________________________________________________________
Connect to the next generation of MSN Messenger?
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070227/321fa7aa/attachment.htm

<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] SQL restore (move) failed with code 5, Rolf C <=