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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2012-03-29 : 22:32:05
|
| I m planning to move few user database from server to new server.I have few things to know.1. Can i restore the db on to server without making the server to single user mode as there are other db exists on server.2.there are some linked server dependents procedures for the db how should I move or create on to new server3.if I scripted the user db and executed on target server how I find out the dependent job,linked server etc.Thanks for your help in advanced. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2012-03-30 : 16:28:16
|
| ThanksDo we have a script/query to verify and scripts the dependant jobs and Linked servers. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-30 : 19:51:00
|
| how do you name your job if it touches many databases? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
User db move