Problema de limite de 2048 mb en la base datos

Gux (MVP)

2008-01-23 14:22:04 UTC

No hay mucho por hacer, usted ha excedido un limite establecido por la
edición de SQL Server que usa.

Las posibilidades son:

1. Construya otra base de datos y separe objetos de forma tal que cada base
de datos no exceda los 2 GB.

2. O bien adquiera una licencia de SQL Server Standard o Enterprise.
--
Gustavo Larriera, Microsoft MVP
https://mvp.support.microsoft.com/profile/gux
--
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.

Post by davids
Resulta que tengo sql server 2000 y se me ha excedido una de las tablas, el
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).
un saludo y gracias amigos.
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.