Create New SQL Database

[wamason]

Please excuse my ignorance for such a basic question, but I have taken on a SQL DB responsibility. I am using SQL Enterprise Manager 8.0.
My question is how do I create I blank SQL database? The database will be 15GB in size.

 

[SQLBill]

Nope. First let's understand some terms:

An instance is 'an install of SQL Server'. It can be a default instance or a named instance.

An instance has 4 system databases and can have one or more user databases.

So each instance you install will have a Master, Model, MSDB, and TempDB database.

Each instance has it's own port assigned. Databases do not use ports, the instance does. Yes, you can change the port.

-SQLBill

Posting advice: FAQ481-4875

 

[SQLBill]

Before you ask...you can ONLY change the port on the server itself. (In other words, you can't do this from Enterprise Manager on a remote system).

So, go to the server, open Enterprise Manger. Right click on the INSTANCE that you want to check or change. Choose Properties. On the General tab, click on Network Configuration. Select (highlight) TCP/IP in the right pane. Click on Properties. That's where you change the port.

I believe you need to restart services when you change the port.

-SQLBill

Posting advice: FAQ481-4875

 

[wamason]

Thanks, my THICK head has got it. I really do apprecite the everyone has taken to respond and in such a timely manner.

 

[Catadmin]

Glad we could help.

I do highly recommend grabbing some cheap books (SQL Server 2000 books should be on sale / clearance at your local bookstore right around now) and reading Books Online to help you in your quest for more information. There's a lot out there and it never hurts to know enough SQL to put it on your resume. @=)



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"