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)
-
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... -
Am sure lot's of people would be wondering how to hide menu items of a list eg document libraries "Send to " menu item . In o... -
I got this error for quite some time and i had no clue what was wrong in my page . Page consisted of only 2 panel controls . That's all ...
No comments:
Post a Comment