July 10, 2007 at 4:02 am
hey budds...
can anyone tell me the simpleast steps to move my sql server to another system,
regards,
NAvin Shetty
Navin Shetty
naveenshetty.cjb.net
July 10, 2007 at 4:32 am
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]
July 10, 2007 at 4:34 am
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
July 10, 2007 at 4:35 am
just refer the link for moving sysdatabases.....
http://support.microsoft.com/kb/224071
also i belive yours is default instance ......
[font="Verdana"]- Deepak[/font]
July 10, 2007 at 4:50 am
July 10, 2007 at 8:31 am
hey frenzz...
thanx fo ur replys...
God Bless...ALL...
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