dbTalk Databases Forums  

BCV restore of sql server 2000 to 2005

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss BCV restore of sql server 2000 to 2005 in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Linchi Shea
 
Posts: n/a

Default RE: BCV restore of sql server 2000 to 2005 - 09-02-2008 , 05:23 PM






That should work fine. I assume you would want to re-create some of the info
stored in the system databases.

Linchi

"Pedja" wrote:

Quote:
Hi,

We have sql server 2000 cluster, with 4 (active-passive) instances. Shared
drives (all system and user databases) are EMC. Since databases are large
(~1TB), we take only BCV backups of shared volumes.
We are installing sql server 2005 cluster on the new set of servers. We plan
to restore shared drives which means all databases (including system ones)
from BCV, because there is no way to restore them per database. That means
that all system databases will be overwritten (with sql server 2000 system
databases) as well. We plan to rebuild system databases with setup.exe, and
to attach database files afterwards.
Does that sound OK?
Thanks in advance,
Pedja

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.