Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-03-31 : 19:03:17
|
| Hi,We are rebuilding sql server 2005. After disaster new sql server instance will be installed, msdb will be restored from netbackup, Logins from previous instance will be restored on new sql server instance. Before we had cluster environment, now we build stand alone server.We also have some linked server on our previous instance. How we can recreate or copy linked servers from previous instance to new one. We just have backup of system databases. I think we have linked server info in master databases. Since we are changing the server name that will also change instance name, I don't want to restore master db from netbackup. I will just restore msdb and user databases.Any help will be appreciated.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-04-01 : 11:30:13
|
| Thanks. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-04-02 : 05:56:39
|
| You can also transfer from table to table . Ultimately the linked server information is stored in a table. I prefer the scripting method - as you can review prior to executing on new instanceJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
move linked servers