Veritas-bu

[Veritas-bu] Restore multiple SQL databases .... NB 5.1 MP4

2007-02-21 08:20:48
Subject: [Veritas-bu] Restore multiple SQL databases .... NB 5.1 MP4
From: Cameron.Kennedy at bovislendlease.com (Kennedy, Cameron)
Date: Wed, 21 Feb 2007 08:20:48 -0500
Looking for an opinion on the best (most efficient) way to restore 148
SQL databases that were backed up on a SQL2000 server and need to be
restored to a different server that has SQL2005 installed. The SQL2005
server has different path locations for the databases and it already has
some databases on it that can't be deleted (thus master DB cant be
erased).
 
I can use a move template to perform this operation successfully on
individual databases, but is there a way to script them without having
to touch the move template for each DB restore as this will indeed be
time consuming? 
 
thanks in advance for any advice. 


-----------------------------------------
This email (including any attachments) is confidential. If you are
not the intended recipient you must not copy, use, disclose,
distribute or rely on the information contained in it. If you have
received this email in error, please notify the sender immediately
by reply email and delete the email from your system.
Confidentiality and legal privilege attached to this communication
are not waived or lost by reason of mistaken delivery to you. Lend
Lease does not guarantee that this email or the attachment(s) are
unaffected by computer virus, corruption or other defects. Lend
Lease may monitor incoming and outgoing emails for compliance with
its Email Policy. Please note that our servers may not be located
in your country.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070221/9f6e5dc1/attachment.html

<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] Restore multiple SQL databases .... NB 5.1 MP4, Kennedy, Cameron <=