Post reply

Server Migration

  • October 29, 2009 at 7:28 am

    #156357

    I am a n00b not gonna pretend im not.

    I was wondering if anyone could help me understand the differences between user databases and system databases, apparently they operate differently especially when migrating.

    I have Googled the topic for 2 days and have yet to find a thread or article, that gives me alot of detail on this process.

    I am interning and they are doing a server migration SQL2005 - to SQL2005 same OS. I have read quite a bit, but still looking for more info. Any feedback would be quite appreciated.

    Thanks in advance.

  • October 29, 2009 at 8:47 am

    #1072491

    Just FYI, you'll have better responses if you post your questions to a different heading - this is the SSIS forum.

    System databases are a core part of the database engine, storing logins, SQL Server agent jobs and their history, backup information, and other information and settings. System databases include master, msdb, model, and tempdb (there are a couple of others that are hidden). User databases are those that have been created by you (the DBA) and are where you store your application data.

    hth,

    Tim

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

  • October 29, 2009 at 8:55 am

    #1072499

    I absolutely appreciate the clarity Tim.

  • October 29, 2009 at 9:38 am

    #1072554

    Following on from Tim's response, you have to decide what is involved in your migration.

    If it's just all 'application' databases, you can forget the system databases - they already exist on the new SQL Server instance anyway.

    But if you want to transfer logons, jobs & any other system-related information too, you'll be extracting from the system databases (probably just transferring across bits of Master and MSDB). So ... confirm the scope of the migration & then find out where all the bits are.

    SSIS can help with this, if you want to script the migration, or parts of it.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • October 29, 2009 at 9:50 am

    #1072578

    Please do not post further in this thread

    reply to this thread http://www.sqlservercentral.com/Forums/Topic810850-1291-1.aspx

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply