I got this error while i was trying to restore SSP SQL Backp from source farm to new target farm SSP DB. Obviously DB by used by different processes which caused this error.
I did following steps to get it working( Make sure you can afford SQL DB outage during the restore )
1) Run the following SQL Query on SSP DB
USE master
GO
ALTER DATABASE YOUR_SSP_DB_NAME
SET OFFLINE WITH ROLLBACK IMMEDIATE
2) Perform SQL Restore from Backup
3)
ALTER DATABASE YOUR_SSP_DB_NAME
SET ONLINE
Thats It .
This process is much simpler than the Central Administration Restore process. For some weird reasons i kept on getting errors while trying with Central Administration console .
Subscribe to:
Post Comments (Atom)
-
Note : In below scenario jenkins was deployed in Linux container Scenario: Jenkins build failed with error. java.io.IOException: error... -
Ever wanted to have a people picker kind of control in Infopath form and that too in browser mode. Did i heard yes :) , well there is a Acti... -
Simple concept but still pain in head if unable to figure out :) Response.Redirect("#");
No comments:
Post a Comment