I am trying to add Appset and getting this error:
Error message:There is insufficient free space on disk volume 'C:\' to create the database. The database requires 4140564480 additional free bytes, while only 3137065984 bytes are available.
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE DATABASE is terminating abnormally.
Any suggetion why I am getting this error??
I am also getting this error - this means the same solution (allocating a space) for the both errors?? Thanks in advance.
Error message:A nonrecoverable I/O error occurred on file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempOutlookSoftDatabase.bak:" 112(There is not enough space on the disk.).
BACKUP DATABASE is terminating abnormally.
Thanks for the response.
The Appset supposed to be copy or add to the E: drive where all the appsets are located or configured. Why it is pointing to the C: Drive?? Why it is saying C:\ didnt have enough space??
Please clarify me if I am wrong, So, when we say copy or add Appset, it is going to copy on C:\ and then, restore or move to the drive where it is configured?? thats the reason we allways need enough space in C:\ drive??
Edited by: Raju on Apr 12, 2010 3:30 PM
It looks like the SQL settings (for sql data and log files is pointing to C drive), maybe on E drive you have the BPC file folder.
In order to have SQL and data files on E drive as well, you ave to Open Management Studion, select Database Settings ad change the path for Data and Log file to E drive, then restart the SQl services and try to restore again.
Thanks for your quick response.
As you suggested, I have looked the database settings (Right Click on Server->Properties->Database Settings) at SQL Server and they are pointing to E:\ Drive (NOT C:\ Drive). But It still giving me the errors mentioned above .... etc., doesnt have enough space on the C:\.
Just found another new message when I am trying to create or add AppSet from BPC Admin:
Detail Message Status:
Check environment information
Validate calucalted members
Connecto to DB Server
Copy the application set's FileDB folder and files
Copy application set's Webfolders folder and files
Error message:The tail of the log for the database "<APPSET_NAME>" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.
RESTORE DATABASE is terminating abnormally.
Any suggession or solution - how to fix this??
Edited by: Raju on Apr 12, 2010 8:15 PM
Have a look at the following threads, we discussed about the appset restore with SQL Server 2005 : SAP BPC 7 APPSet Restore SQL 2005
So far, personal testing show that BPC does not take care of the SQL Server default data and default log folder. It's linked to the SQL Server installation process.
Thank you all for the responses.
My bad, this is all happening now - I used to create or take a copy of AppSets till last week and it is suddently behaving now and giving those errors. Does it mean if anybody changed or modified any settings at server??
I also notified and looked at the C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data - all the .MDF and .LDF files are creating here. All these files supposed be at Server (E: Drive).
This link says - some settings needs to be modified at REGEDIT (I already looked here and everything looks fine for me) or reinstall the BPC again
Best way is to move your *.mdf and *.LDF fmanually to your E: drive.
This need to be done while the BPC application is stopped (IIS / COM+ and sendgovernor / Insight services). Also stop SSAS and SSRS. Then you could detach your DB and move data files then attach again. It's a DBA task.
To my knowledge it's "by design" ! Even if it's not perfect.
The only thing you can do is to reinstall SQL Server 2005 and change the default data path (click advanced after services choice). You may also change the registry key after the installation, but i would not recommend this because it may impact other SQL server functionnality.
The problem is - all the AppSets (Databases) targeted to C:\ Drive.
Yes - finally got solved, ofcourse by taking your suggestions too. Moved all the AppSets to E:\ Drive including AppShell by using Detach/Attach options from SQL Server.
Here are the Steps:
->Make the services off - OutlookSoft Services
->Detach the Appsets including Extra from SQL Server (Right Click on AppSet (Database) Alltasks->Detach)
->Move mdf and ldf files from C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to destination (MDF Files: E:\BPC\Data and LDF Files: E:\BPC\Log)
->Attach the AppSets by right clicking on the Databases (Right Click on Databases->Attach)->Add->(MDF Files: E:\BPC\Data and LDF Files: E:\BPC\Log)
->Start the services on