Moving a database in SQL Server 2005

Minisweeper

So this might sound like a pretty retarded question, but I'm just trying to get sharepoint set up on a fresh SBS2003 Premium edition server install. I've got SQL server installed and running but i need to create a database for sharepoint to use. How do I actually go about doing such a thing? Do i need some additional management app or am i just completely missing something?

WallPhone

Its been over a year, and I have only done it once, but you have to go into a SQL server snap-in, in the treeview somewhere there is a databases folder... I believe its grouped allong with triggers views and such... and right-click->create database.

this may be more reliable than my memory.

Minisweeper

Yeah, turns out i didnt install the management componants when i installed the server. D'oh. Now i just need to work out how to get the rest of it running.. :D

Bergamot

I believe it's possible to execute SQL code from the command line, but I've forgotten how. The manager is much nicer.

barl0w

What version are you using? The free version of SS2005 uses Mangement Studio Express for admin.

The other versions use the SS2005 Management Studio, and by clicking on the instance name after logging in with the credentials you provided during install, you can Create a database through a wizard (right-click on the instance).

Take a look at this free lab on an explaination of how to use the SS2005 Management Studio: http://go.microsoft.com/?linkid=4267441

Here is a link to all of the virtual labs available for SS2005: http://msdn.microsoft.com/virtuallabs/sql/default.aspx

Thanks -

Scott

Minisweeper

Thanks for the links. I've got it creating databases now (it was an access/permissions problem after all) but it's putting them in a different (physical) location to where i want them. Is there any way to set a default database location? (I know you can choose where you want to put it if you make the database yourself but sharepoint creates them for me - ideally i want to seperate the entire DATA folder off from the sql server program files)

Minisweeper

Alright ignore me. I'm losing it today.