Unsolved
This post is more than 5 years old
13 Posts
0
666
January 22nd, 2008 06:00
How to restore SQL database
Hi,
If I need to restore database SQL with AutoStart active/passive and module SQL2000 configured, this procedure is correct?
1) Stop monitor;
2) Offline Resource Group SQL;
3) Attach DataSources on primary node;
4) Start SQL outside of AutoStart;
5) Restore database;
6) When restore database finish, bring online Resource Group SQL.
Thank you.
Fernando
If I need to restore database SQL with AutoStart active/passive and module SQL2000 configured, this procedure is correct?
1) Stop monitor;
2) Offline Resource Group SQL;
3) Attach DataSources on primary node;
4) Start SQL outside of AutoStart;
5) Restore database;
6) When restore database finish, bring online Resource Group SQL.
Thank you.
Fernando
0 events found
No Events found!
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