The database file is larger than the configured maximum size

raj_technoman

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)

Manfred.Castro

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

raj_technoman

Hi Manfred,
Thanks for solution. It is working for us.

Thanks,
Rajendra

raj_technoman

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]

Manfred.Castro

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#

raj_technoman

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

Manfred.Castro

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