Post reply

want to format the pc before that i want to save the maintenance plan jobs and logins,backups and after formatting i vl install 2008 R2

  • January 31, 2013 at 12:02 am

    #273476

    HI all,

    want to format the pc before that i want to save the maintenance plan jobs and logins,backups and after formatting i vl install sqlserver 2008 Enterprise edition .

    1. if is format and after fresh installation of OS i want to restore all the saved logins and maintenance plan jobs and backups in the newly installed sqlserver 2008 enterprise edition is this possible to do so..

    Thanks
    Naga.Rohitkumar

  • January 31, 2013 at 1:27 am

    #1582789

    What edition is already installed on the PC now?

    If it is going to be the same edition, version and service pack level, just backup master and msdb and any other databases, put them on the network then when re-installed restore them

    http://msdn.microsoft.com/en-gb/library/ms190190.aspx

  • January 31, 2013 at 3:45 am

    #1582857

    sqlserver 2008 R2 same edition, version and service pack level,

    "If it is going to be the just backup master and msdb and any other databases, put them on the network then when re-installed restore them "

    1. up to backing up the master and msdb and all databases is ok

    2. then what about the logins created and maintenance plan job ?

    3. if we format and freshly install the OS in the pc after that if i install the sqlserver 2008R2[same version] I can restore the databases from the backups

    4. then !how can i get the logins and maintenance plan jobs which were created before formatting the PC??

    Thanks
    Naga.Rohitkumar

  • January 31, 2013 at 3:47 am

    #1582860

    They will be stored in the master and msdb database

    Logins stored in master, jobs maintenance plans stored in msdb.

  • January 31, 2013 at 4:14 am

    #1582870

    thanks and i vl try this in my pc

    Thanks
    Naga.Rohitkumar

  • January 31, 2013 at 5:01 am

    #1582886

    There are always (usually) multiple ways to do things.

    If it were me I would

    1. Script out all the Agent Jobs using SSMS.

    2. Script out all users (logins and passwords) using sp_help_revlogin.

    see (http://support.microsoft.com/kb/918992)

    3. Copy the database backups to another server

    You scripts can then be retained as part of your disaster recovery plan.

    While you can certainly backup and restore all the databases when doing a clean install I like starting clean and only worry about the user databases.

    I am not saying other methods are wrong. This is how I would do it. (and do)

    Cheers

    ______________________________
    AJ Mendo | @SQLAJ

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

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