The database file is larger than the configured maximum size

raj_technomanraj_technoman Posts: 10
edited February 27, 2014 12:59PM in SQL Backup Previous Versions
Hi There,

When I try to connect one of my server via "SQL Backup", which is using SQL authentication . I always got error like

"Query error: The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [Required Max Database Size (in MB; 0 if unknown)=4092]"

Can you please help me to resolve it , because I want to implement Log Shipping for that server.

When I do RDP to that server , I can connect to SQL server via SQL server Management Studio.

Thanks,
Rajendra (Ryman, UK)

Comments

  • Hi Raj,

    Sorry you are experiencing this.

    The error you are receiving is likely because the SQL Server Compact Database we use to hold the backup history information has hit the maximum size allowed: "The database file is larger than the configured maximum database size."

    The simplest way to get the tool working again is to stop the backup service on the server issuing the warning, rename the data.sdf file, and then start the service again. This will create a new file.

    This file is located on the server in the following location:

    C:\ProgramData\Red Gate\SQL Backup\Data\instance_name

    Do you know how much history you're keeping? It's unusual for the DB to hit the maximum size, so maybe you haven't set it to ever delete any history. You can set the amount of history to delete in the File Management options of the server.

    http://documentation.red-gate.com/displ ... t+options#

    Alternatively you can use script in the following knowledge base article to manually delete the history.

    http://documentation.red-gate.com/displ ... +manually#

    Sincerely,
    Manfred
    Manfred Castro
    Product Support
    Red Gate Software
  • Hi Manfred,
    Thanks for solution. It is working for us.

    Thanks,
    Rajendra
  • Hi Manfred,
    It solve my one problem but still I am facing other problem.
    I am connect to one of our server suppose "XYZ"via "SQL authentication ".

    "SQL backup Agent " service run under "XYZ\administrator" user id at "XYZ" server.

    When I try to restore database via "Red Gate SQL Backup" , then it give me below error for all backup file.


    Readling Flielist of "H:\full_Backup\abc.sqd"

    SQL error 18456: Login Failed for user 'sa'.
    Server : TILL-DR
    SQL Authenticaton
    User Name:sa
    Failed to connect to SQL server instance: TILL-DR

    SQLBackup exit code:586
    SQL error code : 18456




    Can you please reply us as early as possible.

    Thanks,
    Rajendra[/img][/url]
  • Hi Raj,

    The error you are receiving indicates that the login failed for the SQL Server instance.

    Has the sa password changed since installing the server components on the server?

    Can you try running the following on your SQL Server?

    EXECUTE master..sp_addextendedproc sqbsetlogin, 'xp_sqlbackup.dll'
    EXECUTE master..sqbsetlogin 'sa', 'yourpassword'
    EXECUTE master..sp_dropextendedproc sqbsetlogin

    http://documentation.red-gate.com/displ ... +for+user#
    Manfred Castro
    Product Support
    Red Gate Software
  • Hi Manfred,
    Thanks for quick reply. and it solved my one problem but give me another problem.
    I try to set log shipping and on third step of my log shipping ,
    when I try to input any shared path in "Network Share" text box.
    It always say "Folder Does not exist" .

    That folder has read/write permission for "Everyone" and folder is browse from "Network Share"'s browse button only.

    I think it is very difficult for me to set Log Shipping through Red Gate.
    Because same folder can be valid folder from "SQL Log Shipping".

    Please reply us ASAP.

    Thanks,
    Rajendra
  • Hi Raj,

    Sorry you are having such a difficult time with the tool.

    Ideally each forum thread should only pertain to one issue.

    Since it appears that you are having multiple issues.

    I suggest you open an offical support request by sending the details of your issue to support@red-gate.com

    Manfred
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.