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 |
|
mark1504
Posting Yak Master
103 Posts |
 Posted - 2005-03-01 : 10:07:53
|
| Currently my UK hosted site is down, and has been for many hours. Not happy as you can imagine.I have a similar site in Australia (i.e. shared machine) and want to copy some UK views to it so that UK users can view at least some of their data next time the server is down time. I imagine it's a case of copying some views via something in Transact-SQL. (i.e. I can't use Server Agent)Any ideas on where to start?ThanksMark |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-01 : 13:19:03
|
| So you'll need to script your database objects in order to copy them. Right click on the database inside Enterprise Manager, then all tasks, generate SQL script. Select the items that you want scripted. Then copy this script to your other server and run it inside Query Analyzer. If you want to move data, you can do this via linked servers with the four part naming convention of the remote object.Tara |
 |
|
|
mark1504
Posting Yak Master
103 Posts |
Posted - 2005-03-01 : 15:31:24
|
| Sounds too complicated and not specific enough for my level of skill and experience. I'll have to find a tutorial.Thanks anyway.RegardsMark |
|
|
|
|
|
|
How to copy stuff from one remote DB to another