[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 <=
|
|
|