Attach DB > 2 GB

I understand that there is a 2GB limit in MSDE so that
databases can't be created or expanded past 2GB. However,
if the database has come from SQL Server 2000 and is over
2GB (15GB)and is for reference only, is it possible to use
within MSDE?
Thanks for your help.
Hi Jake,
I haven't tried it but have heard from others that it will attach. However,
they had a variety of problems later. Wouldn't recommend it except to
perhaps extract some data.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake Levington" <anonymous@.discussions.microsoft.com> wrote in message
news:1fda01c47d34$abde4ae0$a301280a@.phx.gbl...
> I understand that there is a 2GB limit in MSDE so that
> databases can't be created or expanded past 2GB. However,
> if the database has come from SQL Server 2000 and is over
> 2GB (15GB)and is for reference only, is it possible to use
> within MSDE?
> Thanks for your help.
|||Or use SQLExpress which has a 4GB limit.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23J9cnfTfEHA.632@.TK2MSFTNGP12.phx.gbl...
> Hi Jake,
> I haven't tried it but have heard from others that it will attach.
However,
> they had a variety of problems later. Wouldn't recommend it except to
> perhaps extract some data.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jake Levington" <anonymous@.discussions.microsoft.com> wrote in message
> news:1fda01c47d34$abde4ae0$a301280a@.phx.gbl...
>

Attach database to SQL2005 from old MSDE database

I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which the company says works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.

Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get an error:

Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.

Or... is there a way to attach the databases to SQLExpress manually?

Help pls?The instance of SQL Express needs to be run as "Local system" which is not the default. Once this is changed, the SQL Express database attaches to the old MSDE SQL 2000 database just fine, and the program appears to run without problems.

Thanks to anyone looking at my post, and hopefully, this will help others.

David|||1> use master
2> go

** close the database johandb

1>exec sp_dboption N'johandb',N'autoclose',N'false'
2>go

1>checkpoint
2>go

** detach database johan
1> exec sp_detach_db johandb, true
2> go

** attach with files

1> exec sp_attach_db @.dbname = 'johandb',
2> @.filename1='d:\mssql7\data\johandb_data.mdf',
3> @.filename2='d:\mssql7\data\johandb_log.ldf'
4> go

Regards,
Johan|||Does anyone use Lytec and SOAPware together?

MD in Texassql

Astonishing slowly

hi everyone,

Primary platform XP Sp2 RAM 2gb. Sp2 for sql25k not applied yet.

Does anyone have any tip about how to speep up the development when you have plenty of tasks? My dtsx owns several loop container, for each, and ten tasks between sql and script tasks.

Indeed, is difficult work this way.

TIA,

You don't describe what is slow or how slow it is, but your astonishment leads me to think that it may be a validation problem that was introduced in SP1. See Jamie's post here or install SP2.