Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Server Migration

Author  Topic 

m_mussu
Starting Member

4 Posts

Posted - 2002-12-23 : 02:44:33
Hi
Our company is in the process of implementing the cluster server,so i need to ask with any body that
what is the best way to restore the user databases becoz the server down time has to be minimize i have two ideas suggest which one is good:
Plan I: perform full backup and rrestore and script the logins and create in cluster server (next day)
1.2 stop the server and perform the differential backup and restore upto the time
1.3 up the cluster server for users for production

Plan II:p2.perform full backup and rrestore and script the logins and create in cluster server (next day)
2.2 after full backup perform the transaction log backups and apply to the cluster server
2.3 up the server for users for production

If any body can help me

Thanks
Mohammed A.Musaddiq

MOhammed A.Musaddique
   

- Advertisement -