Filegroup is Full - During Import Data

Hi,

I am getting below error while importing data in SQL 2005 Express:

"error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Could not allocate space for object 'dbo.HistoryLog'.'PK_HistoryLog' in database 'HistoryData' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.".
"

I have select :

Enable Autogrownth = Yes

Filegrowth = 1 MB

Maximum File Size = Unrestricted File growth

I don't know what else I am missing?

Please help

thanks

AA

How much empty space was on the disk when you received the error message.

Check the Log files.

|||

there is only one Log file by the name of "HistoryData_log"

Initial size is: 1,747

Enable Autogrownth = Yes

Filegrowth = 10%

Maximum File Size = Unrestricted File growth

Empty Space on C: is 149 GB

Total database Size : 5843.00 MB

Space Available : 128.21 MB

Please note:

I just noticed when I was increasing initial database size:

"Create Database Or Alter DataBase failied becasue the resulting cumulative database size would exceed your licence limit of 4096 MB Per Database"

Please advsie is this the licencing issue?

Thanks

|||

I meant to look in the computer application logs. However, you 'stumbled' upon an explanition.

Yep, You have SQL Server Express, and SQL Server Express is limited to a maximum 4 GB database size.

|||

Is there any way to increase it?

Please advise which version is good for unlimited data base space?

Thanks for your help

Amir

|||

Any Edition you purchase, from Workgroup to Enterprise, has 'unlimited' database size.

Check here for the best Edition for your needs.

SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||Thanks for hep Arnie.

File system rights

I have setup a test IIS box and would like to use that as my development platform. I have installed sql express 2005 for my database on the box as well.

I can setup new pages on the file server just fine.. But when I try and setup a login page and use the asp.net configuration web page to setup security which create a user DB it will not let me create it...

I get the following:

The following message may help in diagnosing the problem:An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 5110 and the SqlException message is: The file "J:\INETPUB\NBSRECAP\APP_DATA\ASPNETDB_TMP.MDF" is on a network path that is not supported for database files. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Creating the ASPNETDB_4a9331c5903148ca92e3ffbee7d29976 database...

Can someone let me know.

Are you trying to create a database on a network path? This is not supported by default, however you can open a trace flag to allow this:

dbcc traceon(1807,-1)
go
create database testUNC on (name='testUNC_data',
filename='\\iori\xxx\testUNC.mdf')
log on (name='testUNC_log',
filename='\\iori\xxx\testUNC.ldf')

File Not Found error.

I downloaded and installed sql express yesterday. After I rebooted I get a File not Found error.

Any Help would be great.

ThanksWe'd need more info to do anything with this. Please post again if you're still having a problem here.

File Not Found error.

I downloaded and installed sql express yesterday. After I rebooted I get a File not Found error.

Any Help would be great.

ThanksWe'd need more info to do anything with this. Please post again if you're still having a problem here.

File Headers SQL Express

I apparently have corrupted my file header on my database, and then copied it to my backup database.

Is there some way

1. to have the machine recreate the file header automatically? and fix it so that I can use the database

or

2. a back door into the database so that I can get the text files of my database to reconstruct the database from scratch.

The error mesage I receive is:

Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the datase is online.

the header for fil c:\inetpub\wwwroot\nappapfinal\APP_Data\ASPNETDB.MDF is not a valide database header. The File Size property is incorrect.

Thank you

Unfortunately, if the header records within a database file are corrupt, that database is toast.

I'd ask about your most recent backup, but from your question I'm guessing there isn't one.

|||

well the problem was that I was backing up the db when this happened so both were toast. I had a third back up which will have to do however when I uploaded that one I developed a problem with adding users to the db through the web interface... below is my error message: do you have any ideas? thanks in advance for you help.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure or Function 'aspnet_Membership_CreateUser' expects parameter '@.TimeZoneAdjustment', which was not supplied.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

|||

It looks like a mismatch between the web interface and the stored procedures in the database.

Have there been any updates to the application since the time of the backup you were able to restore?

If so, you may just need to re-apply them, or at least the portion that modified the database contents/procedures.

|||

I tried to update the users through the web admin tool also, but that wouldn't let me add users, just roles and manage rules in the web admin tool which I believe may have locked me out of adding users somehow? throws a different error message see below:

An error was encountered. Please return to the previous page and try again.

The following message may help in diagnosing the problem: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Web.Administration.WebAdminMembershipProvider.CallWebAdminMembershipProviderHelperMethodOutParams(String methodName, Object[] parameters, Type[] paramTypes) at System.Web.Administration.WebAdminMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) at System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() at System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) at System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.Wizard.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

thanks for your insights.

File Headers SQL Express

I apparently have corrupted my file header on my database, and then copied it to my backup database.

Is there some way

1. to have the machine recreate the file header automatically? and fix it so that I can use the database

or

2. a back door into the database so that I can get the text files of my database to reconstruct the database from scratch.

The error mesage I receive is:

Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the datase is online.

the header for fil c:\inetpub\wwwroot\nappapfinal\APP_Data\ASPNETDB.MDF is not a valide database header. The File Size property is incorrect.

Thank you

Unfortunately, if the header records within a database file are corrupt, that database is toast.

I'd ask about your most recent backup, but from your question I'm guessing there isn't one.

|||

well the problem was that I was backing up the db when this happened so both were toast. I had a third back up which will have to do however when I uploaded that one I developed a problem with adding users to the db through the web interface... below is my error message: do you have any ideas? thanks in advance for you help.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure or Function 'aspnet_Membership_CreateUser' expects parameter '@.TimeZoneAdjustment', which was not supplied.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

|||

It looks like a mismatch between the web interface and the stored procedures in the database.

Have there been any updates to the application since the time of the backup you were able to restore?

If so, you may just need to re-apply them, or at least the portion that modified the database contents/procedures.

|||

I tried to update the users through the web admin tool also, but that wouldn't let me add users, just roles and manage rules in the web admin tool which I believe may have locked me out of adding users somehow? throws a different error message see below:

An error was encountered. Please return to the previous page and try again.

The following message may help in diagnosing the problem: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Web.Administration.WebAdminMembershipProvider.CallWebAdminMembershipProviderHelperMethodOutParams(String methodName, Object[] parameters, Type[] paramTypes) at System.Web.Administration.WebAdminMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) at System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() at System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) at System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.Wizard.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

thanks for your insights.