June 12, 2008 at 8:17 am
Trying it on a laptop may give you an idea of how to do it, but while doing it on a production server with a different edition of SQL server and Windows Server can have different issues. In my opinion, Backup and Restore is the simplest and safest solution possible. If you don't want any downtime, you can try setting up mirroring between the current server and the new server. Once, you are up and running, you can remove the mirroring and setup the cluster.
June 13, 2008 at 4:35 am
if u r going for SAN there might b some error comes like ur database might go in suspect mode, plz check ur drives .... and restart ur sql services and try to move ur mdf and ldf file to different disk ...
June 14, 2008 at 1:43 am
Hi all,
And more over ...the Database clusterd ...
How to move clustered Database files then?
Thanking you
[font="Arial"]Naga Raju Appani[/font]
June 14, 2008 at 6:51 am
Backup and restore will allow you to move databases that exist on a cluster. Note that there other items to attend to such as creating and sync'ing up logins. You REALLY should get a qualified DBA to assist and guide you here.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply