Post reply

Moving/copying database from stand alone SQL2005 to NEW 2 node 2005SQL cluster?

  • February 19, 2009 at 11:30 am

    #200498

    Hello all,

    New to the environment. Just set up a cluster, 2005 SQL, 2 node. Trying to copy/move database through management studio and scripting fails.

    How does one move a DB from a stand alone to a cluster. I saw one post earlier where a gentlemen lists the steps...one of which is copy DB.....how??

    Please advise.

    Thanks in advance!

    Greg

  • February 19, 2009 at 2:17 pm

    #947155

    this is from one of my previous posts

    For DB:

    Option 1: If Downtime is permitted and db is of medium size --> put source DB in read only mode --> Full backup and restore on new server.

    Option 2: If Downtime is limited and db is large --> take a full backup at time T1 --> Restore db on new server. Next --> Put source db in read only mode --> Transition log backup --> apply transaction log to new server.

    Option 3: If downtime is permitted --> Take source db offline --> Move data and log file to new location --> Bring online/reattach on new server (sp_detach_db/sp_attach_db)

    In all the above cases instead of using UI its best to have a set of scripts ready to speed up the process.

    ---- [font="Tahoma"]Live and Let Live![/font] ----

  • February 20, 2009 at 1:28 am

    #947346

    Getting a database into the clustered instance is the same as it would be on an unclustered instance. Jagadishrashmi has listed various methods of moving/copying a database. One thing to be aware of is that the SQL Server instance on the cluster will only be able to see the clustered drives so if copying a backup file or the datafiles across they need to go on the shared drive.

  • February 20, 2009 at 6:47 am

    #947454

    Thnaks for the replies..

    We have done all above options but 3. It fails. We have copied the DB to the drive on the array of the cluster. It fails. this has been done via script and management studio with the same result. We get 2 different errors.......but more 1534, that the file is not in correct format? On one restore from GUI, it applied almost all, but failed midway through......

    Any advice is appreciated!!

    Thanks again!!

    G

  • February 20, 2009 at 9:09 am

    #947597

    Restore Failed for server XXXXXX (Microsoft.SqlServer.SMO)

    Only formatted files on which the cluster resource of the server has a dependency can be used.(Microsoft.SqlServer.SMO)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply