February 21, 2012 at 10:35 pm
Hi,
While tried to attach database it is prompts the following error:
Attach database failed for Server 'ECLIPSESERVER\SBSMONITORING'. (Microsoft.SqlServer.Express.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Could not allocate space for object 'PerformanceData' in database 'SBSMonitoring' because the 'DEFAULT' filegroup is full.
Error while undoing logged operation in database 'SBSMonitoring'. Error at log record ID (299717:46:257).
Could not open new database 'SBSMonitoring'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 1105)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=1105&LinkId=20476
Please help....
February 21, 2012 at 11:45 pm
- you posted on a sql2000 forum. Is your sqlinstance a sql2000 instance ?
- What's the size of the db ? ( sql2005 express -> max 4GB / sql2008r2 Express -> max 10GB)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 22, 2012 at 12:16 am
--Yes it is SQL server 2000(MSDE) instance and i know the in msde version database size is 2 GB
-- but after 1105 error database is inaccessible
-- and now I want to attach database but it prompts the above mentioned error.
--Database size is 2GB.
Thanks.
February 22, 2012 at 2:09 am
- 2GB is indeed the limit for SQL2000 MSDE
- did you detach this db ? If yes: Why ?
Can you post the errorlog.n file that was active at the time this all started ?
I never worked with msde, only with std/ent editions of sql2000.
Do you have other sql2000 instances available ?
Maybe a workaround is to attach to an other sql2000 instance, perform a shrink, detach and attach to the msde.
Be carefull to keep a file copy of your .mdf and .ndf files as a backup of your db in this state.
Don't attach it to a higher level of the db engine ! ( as there is no way back because of catalog changes ! )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply