Moving SQL Server to New System [Help needed]

  • hey budds...

    can anyone tell me the simpleast steps to move my sql server to another system,

    regards,

    NAvin Shetty


    Kindest Regards,

    Navin Shetty
    naveenshetty.cjb.net

  • 1.firstly take a backup of all teh dbs in your present system....install sql server in another system......and subsequently restore all your dbs with the backup you took from old system........while restoring master you need to start sql server in single user mode....use the below command,

    net start mssqlserver /c /m /T3608........

    2.second option is you can detach all the dbs in your old system and copy the ldf and mdf files to your new system and attach it there....while attaching and detaching sysytem dbs you need to start sql server with trace flag -T3608...use the same command as

    net start mssqlserver /c /m /T3608........

    after you complete any 1 of the above steps (Preferably 1) .......you need to change the originating server column in sysjobs table to reference the new sql server name which you installed recently in the new sql server........after that stop agent in old server as the jobs would duplicate.......

    [font="Verdana"]- Deepak[/font]

  • 1. Install SQL Server in new system.

    2. Script out all logins in the source and run against the destination.

    3. backup all user database and restore in destination.

    4. script all jobs and run against the destination.

    Resolve any orphan users in the databases.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • just refer the link for moving sysdatabases.....

    http://support.microsoft.com/kb/224071

    also i belive yours is default instance ......

    [font="Verdana"]- Deepak[/font]

  • the fastest and simplest is detach and attach. but follow the advise above in case anything happens


    Everything you can imagine is real.

  • hey frenzz...

    thanx fo ur replys...

    God Bless...ALL...


    Kindest Regards,

    Navin Shetty
    naveenshetty.cjb.net

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

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