September 16, 2008 at 7:18 am
I am new with DB. How do I know if it is enough space on the server. How many database I can have on the server? Thank you
September 21, 2008 at 5:46 pm
If it's disk space you're meaning, there are a number of ways.
I usually run
xp_fixeddrives
to check the available drive space. FYI It doesn't work if you use mount points on your server instead of drive letters.
The next step is to see the minimum new database size.
Run:
sp_helpdb model
Model is the "template" database that SQL Server uses to create new DB's. sp_helpdb is a stored procedure that shows you information about the specified database (model, in this case)
After that its up to you to figure out how much space the new database will evenually grow to... and also the recovery model. If you use full recovery model, then you'll need to allocate space for the transaction logs.
Good luck!
You might consider purchasing some Books on SQL Server. It's pretty complicated and I've spent many years of my life learning the ins and outs.
~Craig
Craig Outcalt
MCITP, MCDBA
Craig Outcalt
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply