Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a production database server having sql server 2008r2. This is an old server and considering our load, we are moving to a better hardware configuration, Now the new environment is a cluster environment on Win Server 2012 with single installation of SQL SERVER 2012.

My understanding of failover cluster environment is that same instance of sql server is there on both nodes and they get data from a shared SAN. Primary node remains active while secondary node remains idle till the time the primary node fails. Once the primary node fails, windows brings the secondary node as active.

Now i want to restore backup of 2008r2 database to this new sql server 2012 environment. Does this failover cluster impose any restrictions on this backup restore or will it be a normal backup restore operation. Please share your thoughts.

share|improve this question
    
"Primary node remains active while secondary node remains idle..." Not quite, no. On the active node, SQL Server is running; on the passive node(s), it is not (there is no sqlservr.exe process). The failover process starts up the sqlservr.exe process on the new active node. –  Greenstone Walker Mar 27 at 20:42

1 Answer 1

up vote 2 down vote accepted

Does this failover cluster impose any restrictions on this backup restore or will it be a normal backup restore operation.

It will be a normal backup and restore operation (provided there are no other issues with the actual backup and/or restore).

The fact that you are going from a standalone instance to a failover cluster instance will not negatively affect an otherwise normal backup and restore.

The same rules will apply here, of course, as well as any other backup/restore operation regardless of standalone or FCI.

share|improve this answer
4  
The biggest complication will likely be that the restore will require WITH MOVE because the storage location(s) on the clustered instance most certainly will differ from the source system. –  Aaron Bertrand Mar 27 at 16:10
    
Yes that is true, i had to restore it using SQL QUERY and using with MOVE option. –  rohit Mar 28 at 5:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.