Post reply

sql server 2005: restore from one db to a failover cluster db

  • March 14, 2008 at 11:57 am

    #188043

    I need to restore a db (simple enviornment) to a failover cluster db....is this simple and straight forward? If not what are the considerations, concerns?

  • March 14, 2008 at 12:29 pm

    #789823

    It's just a server with databases on it as far as normal operations are concerned. You shouldn't have any issues of any kind running a restore.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • March 17, 2008 at 1:31 pm

    #790532

    Only thing to think about is that SQL Server in the Cluster may not be able to see all the disks that are in the server - it can only see the disks added as resources to the SQL Group in the cluster. So if copying a backup file to the cluster make sure you copy it to one of the disks that SQL Server can see and then you may have to restore the DB files to different locations as necessary.

Viewing 3 posts - 1 through 2 (of 2 total)

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