Riya_Roy Absent Member.
Absent Member.
6125 views

Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution

Hi Experts,

 

I am getting below error  "Table size of SQL Express Database exceeds 90% of the limit (04 GB)" in OMW.

 

Please suggest how we can increse database  size ?

 

Also is there any way to reduce database size ?

 

Please suggest.

 

 

Regards,
Riya Roy

Ship in harbor is safe -- but that is not what ships are built for …
Tags (1)
0 Likes
1 Solution

Accepted Solutions
Riya_Roy Absent Member.
Absent Member.

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution

Performed shrinking of log file from 1.2 GB to 200 MB.
Regards,
Riya Roy

Ship in harbor is safe -- but that is not what ships are built for …

View solution in original post

9 Replies
Absent Member.. Mascotte_Thomas Absent Member..
Absent Member..

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution
Riya Pls try this!!!
  1. In Object Explorer, connect to an instance of the SQL Server 2005 Database Engine, and then expand that instance.

  2. Expand Databases, right-click the database to increase, and then click Properties.

  3. In Database Properties, select the Files page.

  4. To increase the size of an existing file, increase the value in the Initial Size (MB) column for the file. You must increase the size of the database by at least 1 megabyte.

  5. To increase the size of the database by adding a new file, click Add and then enter the values for the new file. 

6.    Click OK.

 

Regards,

Mascotte

 

 

 

 

-/-\- Mascotte
"Assign the Kudos to the kind fellas to shew the appreciation"
http://h30499.www3.hp.com/t5/custom/page/page-id/hp.rulespage
Absent Member.. vforvarun Absent Member..
Absent Member..

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution
Hello Riya,

What is the version of SQL Express DB are you using?

If you are using Express 2005, then 4GB is the size limit. But in Express 2008 R2, the limit has been increased to 10GB**. Check if you can upgrade..!!

With regards,

VarunK

** http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx
Riya_Roy Absent Member.
Absent Member.

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution
Hi Varun,

Can I used SQL Server 2008 instead of SQL Express ?

Please suggest.
Regards,
Riya Roy

Ship in harbor is safe -- but that is not what ships are built for …
0 Likes
Absent Member.. vforvarun Absent Member..
Absent Member..

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution
Hello Riya,

I'm not about the OMW version you are using but check SUMA, if SQL Server 2008 is supported, then sure, by all means go ahead and use it.

The database size limit is only when using SQL Express, I don't there is any limit specified when using SQL Server 2008..!

Hope this helps.

With regards,

VarunK
Riya_Roy Absent Member.
Absent Member.

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution

Performed shrinking of log file from 1.2 GB to 200 MB.
Regards,
Riya Roy

Ship in harbor is safe -- but that is not what ships are built for …

View solution in original post

Absent Member.. Mascotte_Thomas Absent Member..
Absent Member..

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution

Riya,

 

You can even set the scheduler to automatically shrink the log file with no further manual intervention.

 

-- Mascotte

-/-\- Mascotte
"Assign the Kudos to the kind fellas to shew the appreciation"
http://h30499.www3.hp.com/t5/custom/page/page-id/hp.rulespage
0 Likes
Absent Member.. Chaman Absent Member..
Absent Member..

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution
Hi Mascotte,

Please suggest how to set the scheduler to automatically shrink the log file as suggested in last comment.

Thanks
Chaman
0 Likes
Absent Member.. Chaman Absent Member..
Absent Member..

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution
Hi Riya,

Please explain how you shrinked the logfile, I am facing the same issue.

Thanks,
Chaman
0 Likes
Riya_Roy Absent Member.
Absent Member.

Re: Table size of SQL Express Database exceeds 90% of the limit (04 GB)

Jump to solution

 

Hi Chaman,

 

Please find below stpes.

 

Shrink database logs file of OMW

 

F:\Program Files\HP\HP BTO Software\bin\win64>osql -S .\OVOPS -E -d openview -q

"EXIT(DBCC SHRINKFILE(openview_log,200))"

Cannot shrink log file 2 (Openview_log) because the logical log file located at

the end of the file is in use.

 DbId   FileId      CurrentSize MinimumSize UsedPages   EstimatedPages

 ------ ----------- ----------- ----------- ----------- --------------

      5           2       28608         128       28608            128

 

(1 row affected)

DBCC execution completed. If DBCC printed error messages, contact your system

administrator.

 

Cheers 🙂

 

 

 

Regards,
Riya Roy

Ship in harbor is safe -- but that is not what ships are built for …
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.