April 22, 2011 at 7:47 am
I'm setting up and testing a new SQL Server 2008 R2. I'm testing backup/restore of the ReportServer database using Management Studio.
For an attempted restore I have the "Overwrite the existing database (with replace)" and "Leave the database ready to use by rolling back uncommitted transactions" options selected.
I get this error message: "Restore failed for server: Exclusive access could not be obtained because the database is in use." I'm attempting to restore from full and differential backups. No transaction log backups.
Can someone tell me the proper way to restore the ReportServer database?
April 23, 2011 at 12:13 am
USE [MASTER]
GO
ALTER DATABASE REPORTSERVER SET OFFLINE WITH ROLLBACK IMMEDIATE;
GO
then restore it
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 23, 2011 at 11:01 am
database probably in use by reporting services, stop this service before doing the restore, restart reporting services afterwards
---------------------------------------------------------------------
April 24, 2011 at 3:32 am
that was understood to stop the reporing services first then if he has any problem like as he mentioned then do that
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 25, 2011 at 4:28 am
Thanks. That was it. I needed th stop reporting services, perform the database restore, and then start reporting services.
April 28, 2011 at 8:08 am
If u get database in use means that database is currently in use so we need to kill the users in that particular database and then do a restore and give a try thanks
August 20, 2013 at 10:00 am
Thanks!! Actually I was mad looking for a solution and your post gave it to me.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply