March 10, 2011 at 8:48 am
Hi All, I'm looking for some help and advice please as to why i cannot backup the reportservertempdb.
Firstly there is no requirement for this db to have been installed on the server, but the network team do the installs. Now i have tried to carry out a full backup of all the production db's and the following error message is causing it to fail:
-----
Database 'ReportServerTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)
------
I checked disk space and its fine, i have also looked for the mdf and ldf files, but unable to locate them, whilst also trying to detach the db and this is not possible, refer to error message below also. I have checked through forums for what else could be causing this, and have not had much luck.
Your advice on this would be greatly appreciated!
-----------------------------
Alter failed for Database 'ReportServerTempDB'. (Microsoft.SqlServer.Smo)
Unable to open the physical file "P:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB.mdf". Operating system error 3: "3(failed to retrieve text for this error. Reason: 15105)".
Database 'ReportServerTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
ALTER DATABASE statement failed.
File activation failure. The physical file name "P:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB_log.LDF" may be incorrect. (Microsoft SQL Server, Error: 5120)
--------------------------------
March 10, 2011 at 9:32 am
It looks like your database files are missing. You may need to restart the SQL service to get SQL Server to realize that the database isn't there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 11, 2011 at 2:18 am
Thanks for your reply, i have rebooted server but this has done no good.
March 11, 2011 at 9:06 am
Ill add this for the purpose of future viewings.
I have un-installed the Reporting Services from Add/Remove programs and this still did not correct the problem. Just to clarify, i have a backup maint plan scheduled and i have selected all databases to be backed up. When it runs it fails due to the following errro message. I then changed the maint plan to just backup a specific user database and the error still occured. It seems that the reportservertempdb mdf & ldf files do not exist anywhere on this server.
I thought that by uninstalling the SSRS and re-installing it then this would have created these files.
Any advice would be of great help!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply