If SQL Server2000 - Use the enterprise manager and you can copy all or some of the databases to another SQL Server... There is a wizard to help you along. Right click the source SQL Server, choose All Tasks, choose Copy Database Wizard... will let you select all database and copy them to a Second SQL Server.
This of course assumes both are on the network and can communicate with each other. At 09:58 AM 11/18/02, you wrote: >At 08:23 AM 11/18/02, Stephen wrote: >> > Um - sure - so what is mirroring? ;) The most I've done w/ SQL Server >> > (outside of SQL) is backup, restore, migrate on one DB. >> > >>Ummm... I might have the wrong name/word for it, but basically the idea is >>that you set up another SQL Server as a slave, when someone updates data on >>the master server those changes are mirrored to the slave. > >Sounds like you are taking about database replication. Microsoft has some >nice water papers on their site that describe how to do this. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
