Showing posts with label obtained. Show all posts
Showing posts with label obtained. Show all posts

Tuesday, March 20, 2012

Restore ReportServer

I keep getting this message when i try and restore the ReportServer "system.data.sqlclient.sqlerror: Exclusive access could not be obtained because the database in in use"

All the other databases restored successfully.

Any ideas?
just check if you are accidentally using the db in the management studio.....proceed as follows,
use master
go
then perform the restoration as usual....cool
fyi
http://technet.microsoft.com/en-us/library/ms156421.aspx