exceed your licensed limit of 2048 MB per database

i have a problem with my datebase ( wsus ).
my log said :
008-01-22 10:10:48.79 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-01-22 10:10:48.79 server All rights reserved.
2008-01-22 10:10:48.79 server Server Process ID is 952.
2008-01-22 10:10:48.79 server Logging SQL Server messages in file
'c:\WSUS\MSSQL$WSUS\LOG\ERRORLOG'.
2008-01-22 10:10:48.80 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2008-01-22 10:10:48.83 server SQL Server configured for thread mode
processing.
2008-01-22 10:10:48.83 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2008-01-22 10:10:48.85 spid3 Starting up database 'master'.
2008-01-22 10:10:48.94 server Using 'SSNETLIB.DLL' version '8.0.880'.
2008-01-22 10:10:48.96 server SQL server listening on Shared Memory.
2008-01-22 10:10:48.96 server SQL Server is ready for client connections
2008-01-22 10:10:48.96 spid5 Starting up database 'model'.
2008-01-22 10:10:48.97 spid3 Server name is 'BNS33\WSUS'.
2008-01-22 10:10:48.97 spid3 Skipping startup of clean database id 4
2008-01-22 10:10:48.97 spid3 Starting up database 'SUSDB'.
2008-01-22 10:10:49.27 spid5 Clearing tempdb database.
2008-01-22 10:10:50.11 spid5 Starting up database 'tempdb'.
2008-01-22 10:10:55.57 spid3 180 transactions rolled forward in database
'SUSDB' (5).
2008-01-22 10:10:55.61 spid3 CREATE/ALTER DATABASE failed because the
resulting cumulative database size would exceed your licensed limit of 2048
MB per database.
2008-01-22 10:10:55.63 spid3 Could not allocate space for object
'tbEventInstance' in database 'SUSDB' because the 'DEFAULT' filegroup is full.
2008-01-22 10:10:55.64 spid3 Error: 1105, Severity: 17, State: 2
2008-01-22 10:10:55.64 spid3 Could not allocate space for object
'tbEventInstance' in database 'SUSDB' because the 'DEFAULT' filegroup is
full..
2008-01-22 10:10:55.64 spid3 Error while undoing logged operation in
database 'SUSDB'. Error at log record ID (479784:308:122).
2008-01-22 10:10:55.64 spid3 Error: 3314, Severity: 17, State: 3
2008-01-22 10:10:55.64 spid3 Error while undoing logged operation in
database 'SUSDB'. Error at log record ID (479784:308:122)..
2008-01-22 10:10:55.64 spid3 Recovery complete.
2008-01-22 10:10:55.64 spid3 SQL global counter collection task is
created.
help me , friends .
kind regardsFree up some space in your database? MSDE is limited to 2 GB, sorry, that
is a pretty basic problem you have, with a pretty basic solution...
"davidss" <davidss@.discussions.microsoft.com> wrote in message
news:883A4C75-A45D-42C7-BC76-DB9FF13C2B3F@.microsoft.com...
> i have a problem with my datebase ( wsus ).
> my log said :
>
> 008-01-22 10:10:48.79 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2008-01-22 10:10:48.79 server All rights reserved.
> 2008-01-22 10:10:48.79 server Server Process ID is 952.
> 2008-01-22 10:10:48.79 server Logging SQL Server messages in file
> 'c:\WSUS\MSSQL$WSUS\LOG\ERRORLOG'.
> 2008-01-22 10:10:48.80 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2008-01-22 10:10:48.83 server SQL Server configured for thread mode
> processing.
> 2008-01-22 10:10:48.83 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2008-01-22 10:10:48.85 spid3 Starting up database 'master'.
> 2008-01-22 10:10:48.94 server Using 'SSNETLIB.DLL' version '8.0.880'.
> 2008-01-22 10:10:48.96 server SQL server listening on Shared Memory.
> 2008-01-22 10:10:48.96 server SQL Server is ready for client
> connections
> 2008-01-22 10:10:48.96 spid5 Starting up database 'model'.
> 2008-01-22 10:10:48.97 spid3 Server name is 'BNS33\WSUS'.
> 2008-01-22 10:10:48.97 spid3 Skipping startup of clean database id 4
> 2008-01-22 10:10:48.97 spid3 Starting up database 'SUSDB'.
> 2008-01-22 10:10:49.27 spid5 Clearing tempdb database.
> 2008-01-22 10:10:50.11 spid5 Starting up database 'tempdb'.
> 2008-01-22 10:10:55.57 spid3 180 transactions rolled forward in
> database
> 'SUSDB' (5).
> 2008-01-22 10:10:55.61 spid3 CREATE/ALTER DATABASE failed because the
> resulting cumulative database size would exceed your licensed limit of
> 2048
> MB per database.
> 2008-01-22 10:10:55.63 spid3 Could not allocate space for object
> 'tbEventInstance' in database 'SUSDB' because the 'DEFAULT' filegroup is
> full.
> 2008-01-22 10:10:55.64 spid3 Error: 1105, Severity: 17, State: 2
> 2008-01-22 10:10:55.64 spid3 Could not allocate space for object
> 'tbEventInstance' in database 'SUSDB' because the 'DEFAULT' filegroup is
> full..
> 2008-01-22 10:10:55.64 spid3 Error while undoing logged operation in
> database 'SUSDB'. Error at log record ID (479784:308:122).
> 2008-01-22 10:10:55.64 spid3 Error: 3314, Severity: 17, State: 3
> 2008-01-22 10:10:55.64 spid3 Error while undoing logged operation in
> database 'SUSDB'. Error at log record ID (479784:308:122)..
> 2008-01-22 10:10:55.64 spid3 Recovery complete.
> 2008-01-22 10:10:55.64 spid3 SQL global counter collection task is
> created.
> help me , friends .
>
> kind regards
>|||Aaron please,
how to free up some space in my database ?
kind Regards
"Aaron Bertrand [SQL Server]" wrote:
> Free up some space in your database? MSDE is limited to 2 GB, sorry, that
> is a pretty basic problem you have, with a pretty basic solution...
>
> "davidss" <davidss@.discussions.microsoft.com> wrote in message
> news:883A4C75-A45D-42C7-BC76-DB9FF13C2B3F@.microsoft.com...
> >
> > i have a problem with my datebase ( wsus ).
> >
> > my log said :
> >
> >
> > 008-01-22 10:10:48.79 server Copyright (C) 1988-2002 Microsoft
> > Corporation.
> > 2008-01-22 10:10:48.79 server All rights reserved.
> > 2008-01-22 10:10:48.79 server Server Process ID is 952.
> > 2008-01-22 10:10:48.79 server Logging SQL Server messages in file
> > 'c:\WSUS\MSSQL$WSUS\LOG\ERRORLOG'.
> > 2008-01-22 10:10:48.80 server SQL Server is starting at priority class
> > 'normal'(1 CPU detected).
> > 2008-01-22 10:10:48.83 server SQL Server configured for thread mode
> > processing.
> > 2008-01-22 10:10:48.83 server Using dynamic lock allocation. [500] Lock
> > Blocks, [1000] Lock Owner Blocks.
> > 2008-01-22 10:10:48.85 spid3 Starting up database 'master'.
> > 2008-01-22 10:10:48.94 server Using 'SSNETLIB.DLL' version '8.0.880'.
> > 2008-01-22 10:10:48.96 server SQL server listening on Shared Memory.
> > 2008-01-22 10:10:48.96 server SQL Server is ready for client
> > connections
> > 2008-01-22 10:10:48.96 spid5 Starting up database 'model'.
> > 2008-01-22 10:10:48.97 spid3 Server name is 'BNS33\WSUS'.
> > 2008-01-22 10:10:48.97 spid3 Skipping startup of clean database id 4
> > 2008-01-22 10:10:48.97 spid3 Starting up database 'SUSDB'.
> > 2008-01-22 10:10:49.27 spid5 Clearing tempdb database.
> > 2008-01-22 10:10:50.11 spid5 Starting up database 'tempdb'.
> > 2008-01-22 10:10:55.57 spid3 180 transactions rolled forward in
> > database
> > 'SUSDB' (5).
> > 2008-01-22 10:10:55.61 spid3 CREATE/ALTER DATABASE failed because the
> > resulting cumulative database size would exceed your licensed limit of
> > 2048
> > MB per database.
> > 2008-01-22 10:10:55.63 spid3 Could not allocate space for object
> > 'tbEventInstance' in database 'SUSDB' because the 'DEFAULT' filegroup is
> > full.
> > 2008-01-22 10:10:55.64 spid3 Error: 1105, Severity: 17, State: 2
> > 2008-01-22 10:10:55.64 spid3 Could not allocate space for object
> > 'tbEventInstance' in database 'SUSDB' because the 'DEFAULT' filegroup is
> > full..
> > 2008-01-22 10:10:55.64 spid3 Error while undoing logged operation in
> > database 'SUSDB'. Error at log record ID (479784:308:122).
> > 2008-01-22 10:10:55.64 spid3 Error: 3314, Severity: 17, State: 3
> > 2008-01-22 10:10:55.64 spid3 Error while undoing logged operation in
> > database 'SUSDB'. Error at log record ID (479784:308:122)..
> > 2008-01-22 10:10:55.64 spid3 Recovery complete.
> > 2008-01-22 10:10:55.64 spid3 SQL global counter collection task is
> > created.
> >
> > help me , friends .
> >
> >
> > kind regards
> >
>|||> Aaron please,
> how to free up some space in my database ?
Well, what tables do you have? I have no idea what data is taking up 2 GB.
But find some data you don't need and delete it. If you need > 2 GB of data
then you will need to use a better edition of SQL Server, or splitting some
of your data into multiple databases. Again, I can't tell you how to do
that... those are decisions you're going to have to make.|||Or... possibly the application that uses the database has some option to "purge old data" or
similar.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uvf5DhcXIHA.1164@.TK2MSFTNGP02.phx.gbl...
>> Aaron please,
>> how to free up some space in my database ?
> Well, what tables do you have? I have no idea what data is taking up 2 GB. But find some data you
> don't need and delete it. If you need > 2 GB of data then you will need to use a better edition
> of SQL Server, or splitting some of your data into multiple databases. Again, I can't tell you
> how to do that... those are decisions you're going to have to make.