AppSet copy failed

[Former Member]

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??

Thank you.

[Former Member · Accepted solution]

Hi Raju,

As the message is indicating, there is not enough space on the drive where SQL is installed. You need to add some space to this drive.

[Former Member · Accepted solution]

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.

[i045436 · Accepted solution]

Hi Raju,

Yes, this error message is related to the same thing because first of all this file is copied there and after is restored.

Best regards,

Mihaela

[Former Member · Accepted solution]

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

[i045436 · Accepted solution]

Raju,

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.

Best regards,

Mihaela

[Former Member · Accepted solution]

HI Mihaela,

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

Copy File

Connecto to DB Server

Copy the application set's FileDB folder and files

Copy application set's Webfolders folder and files

Copy database

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??

Kind Regards,

Raju.

Edited by: Raju on Apr 12, 2010 8:15 PM

[i045436 · Accepted solution]

Raju,

You can try to restore manually the SQL backup from SQl folder to see exactly where is the proble,. It can be also a problem with the Log file, did you shrink the original database before to backup it?

Best regards,

Mihaela

[Former Member · Accepted solution]

Hi,

Have a look at the following threads, we discussed about the appset restore with SQL Server 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.

[Former Member · Accepted solution]

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

Kind Regards,

Raju.

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks again - I completly understand your way for the solution.

But it is behaving like this?? because it is not configured or installed it proparly??

[Former Member · Accepted solution]

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.

Sincerely,

[Former Member]

I can't locate the link right now, and I know this reply is 'late; but there is an Outlooksoft document out there that is entitled

Outlooksoft 5 - How to manually port an AppSet, it documents the procedure to get the files where you need them.

[Former Member]

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

Regards,

Raju.