Moved MSDE Db to SQL 2000?

[pinkpanther56]

Hi all

Our MSDE Db recently reached 2Gig so we moved it over to SQL server, when i look in Enterprise Manager it lists the Db as still having a 2Gb limit.

In Db properties it says size 1902Mb and space available 94Mb, is there a way to change this so the Db isn't restricted or will SQL server just increase the limit once it gets there?

Also is there a way to check the DB health someone told me that MSDE Db's become slow when they get to the limit and need maintenance. Is this the case now i've moved it to SQL server?

Thanks.

 

[onpnt]

how did you move the db to the new server?

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[Catadmin]

If you actually detached & reattached the database, right-click the DB and go into the properties. See if you have a Data and Transaction tab. Usually, on those tabs, you can change the maximum size of a SQL Server DB. However, since I'm not sure if the database actually got "upgraded" during such a procedure, I'm also not sure if you'll be able to change the sizes here.

Secondly, verify what increments the database is set to grow as. The available space in the database may not be an actual hard limit now that you've moved it to SQL Server so much as a "This is how much space the database currently has in the pages allocated to it" kind of message. If there hasn't been enough activity to make it grow recently, it'll stay like that until it needs to grow.

Thirdly, database health can be checked with the DBCC commands. Check them out in Books Online. There's lots of them, but you can start out with DBCC CheckDB.

Lastly, have you verified that you have enough room on the new hard drive for future growth?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[pinkpanther56]

The Db stayed on the same server i just uninstalled MSDE then installed SQL then attached the Db.

I looked on the Data Files tab and i can now see that the unristricted growth button is checked and i can also see a Trasaction log tab. On the data tab it say 10% automatic growth so i suppose it hasn't got there yet? The drive has 15Gb free space.

I'll take a look at the DBCC commands thanks.

 

[Catadmin]

From the description you just posted, yes, the database simply hasn't had a reason to grow yet. However, it's not stuck at the 2GB limit. That's only how much space it has from the pages which were previously allocated.

Let us know if you need anything else.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[pinkpanther56]

Ok thanks.