The database file is larger than the configured maximum size

Compresses, encrypts, secures and monitors SQL Server backups.

The database file is larger than the configured maximum size

Postby raj_technoman » Tue Feb 18, 2014 6:25 pm

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)
raj_technoman
 
Posts: 7
Joined: Tue Feb 18, 2014 6:19 pm

Postby Manfred.Castro » Wed Feb 19, 2014 7:49 pm

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

The database file is larger than the configured maximum size

Postby raj_technoman » Tue Feb 25, 2014 1:50 pm

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

Thanks,
Rajendra
raj_technoman
 
Posts: 7
Joined: Tue Feb 18, 2014 6:19 pm

Postby raj_technoman » Tue Feb 25, 2014 4:28 pm

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]
raj_technoman
 
Posts: 7
Joined: Tue Feb 18, 2014 6:19 pm

Postby Manfred.Castro » Wed Feb 26, 2014 11:45 pm

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

The database file is larger than the configured maximum size

Postby raj_technoman » Thu Feb 27, 2014 6:36 pm

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
raj_technoman
 
Posts: 7
Joined: Tue Feb 18, 2014 6:19 pm

Postby Manfred.Castro » Thu Feb 27, 2014 6:59 pm

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests