Announcement

Collapse
No announcement yet.

SQL 2008 database location,

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL 2008 database location,

    Hello,

    May I ask You for help?
    I going to install new SQL server on the new hardware.
    On old server I have 4 databases located in the same folder.
    I want to put 2 databases in one folder (first partition), and next 2 in other folder (second partition).
    Can I set up 2 different location at installation process?? Or should do it after installation?

    Second question, Can I change instance name after database restore?. I want to have the same name.

    Regards
    michal

  • #2
    Are these the system databases? If so, they will all go into the location you specify for databases during setup, but you can move them afterwards

    According to MSDN changing the instance name is not supported, but apparently you can do it (https://sqldbpool.com/2008/09/03/how...instance-name/)
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Hi,

      Ok. thx for answer.
      But as You said, i can change location... Can I put for example 2 databases in one partition and next 2 databases in other partition ?

      regards
      m

      Comment


      • #4
        WHat databases are you wanting to move?
        If it is the system ones, do you really need to?

        The main performance gain you can get is separating logs from databases onto separate disk arrays
        Tom Jones
        MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
        PhD, MSc, FIAP, MIITT
        IT Trainer / Consultant
        Ossian Ltd
        Scotland

        ** Remember to give credit where credit is due and leave reputation points where appropriate **

        Comment


        • #5
          Hi,

          i want to change location of the ERP database.

          michal

          Comment


          • #6
            Yes, no problems in putting multiple databases in multiple locations.
            However, review guidance and best practice on separating databases and logs, and investigate how many disk spindles you have available (NOT partitions) before you start moving things.
            The biggest performance improvements are from separating databases from logs and placing the logs on the fastest possible (but still highly available) disk arrays.

            Basically, if you don't know exactly what you are doing, and the potential consequences, do NOT change anything - in SQL server, the potential to FUBAR things is much higher than in other products.
            Tom Jones
            MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
            PhD, MSc, FIAP, MIITT
            IT Trainer / Consultant
            Ossian Ltd
            Scotland

            ** Remember to give credit where credit is due and leave reputation points where appropriate **

            Comment


            • #7
              Everything completed successfully.
              Thanks for help.

              Comment

              Working...
              X