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 |
|
CanadaDBA
583 Posts |
 Posted - 2007-06-08 : 11:44:09
|
| I want to have all the databases on one instance available on another machine. Since the databases are being added or dropped, the number of DBs is being changed everyday or couple of days. This is not a transactional environment. Maybe a simple solution is to backup and restore every night; i.e.1. Generate BAK files from Source server2. Drop databases on Dest server3. Restore BAK files into Dest serverAny idea how this can be simplified? Canada DBA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-08 : 13:14:27
|
| I can't think of other easier way. |
 |
|
|
|
|
|
Copy an instance to another server