March 14, 2008 at 11:57 am
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
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 17, 2008 at 1:31 pm
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