I am assuming that you are using a mirrored data source.
I think this is OK but when you bring it online again, you need to mirror the data source again to ensure same data on both ndoes.
The only other thing that comes to my mind is why not restore database with Resource Group online and data source attached to primary node, it will mirror the database simultaneously. Recovery might be slightly slow.
I try restore database with Resource Group online but the job on SQL not finish because the disk where is database backup is not accessible. The disk where is database backup is the same disk configured on Data Source.
To restore the databases you should be able to do it with the resource group online. Having the resource group online will give you access to the two partitions and the SQL server services. Taking the resource group offline and bringing the resources online manually would essentially put you in the same state as having the resource group online. If the backup drive (Disk2) is not accessible, then this indicates that it was not manually attached during your restore attempt.
I do suggest that the resource group monitoring be stopped during the restore to prevent a resource group failover during the restore. By default, the no response state of the data source will cause a relocation of the resource group, since there will be a high utilization on the two data source you can potentially see the data source go into a no response state.
amediratta
2 Intern
•
2K Posts
0
January 22nd, 2008 08:00
I think this is OK but when you bring it online again, you need to mirror the data source again to ensure same data on both ndoes.
The only other thing that comes to my mind is why not restore database with Resource Group online and data source attached to primary node, it will mirror the database simultaneously. Recovery might be slightly slow.
Check from your bckup utility as well.
amediratta
2 Intern
•
2K Posts
0
January 23rd, 2008 03:00
fborges1
13 Posts
0
January 23rd, 2008 03:00
I try restore database with Resource Group online but the job on SQL not finish because the disk where is database backup is not accessible. The disk where is database backup is the same disk configured on Data Source.
Thanks, Fernando.
fborges1
13 Posts
0
January 23rd, 2008 05:00
Disk1 is used for SQL data
Disk2 is used for SQL logs
The files of backup are bred on the same disk2.
Fernando
ecervant
63 Posts
0
January 23rd, 2008 10:00
To restore the databases you should be able to do it with the resource group online. Having the resource group online will give you access to the two partitions and the SQL server services. Taking the resource group offline and bringing the resources online manually would essentially put you in the same state as having the resource group online. If the backup drive (Disk2) is not accessible, then this indicates that it was not manually attached during your restore attempt.
I do suggest that the resource group monitoring be stopped during the restore to prevent a resource group failover during the restore. By default, the no response state of the data source will cause a relocation of the resource group, since there will be a high utilization on the two data source you can potentially see the data source go into a no response state.
Regards,
Emilio