Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Moving a database in SQL Server 2005

edited October 2006 in Vanilla 1.0 Help
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?


  • Options
    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.
  • Options
    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
  • Options
    I believe it's possible to execute SQL code from the command line, but I've forgotten how. The manager is much nicer.
  • Options
    edited October 2006
    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:

    Here is a link to all of the virtual labs available for SS2005:

    Thanks -

  • Options
    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)
  • Options
    Alright ignore me. I'm losing it today.
This discussion has been closed.