I have a SQL server that is used as a distribution server for all our replications. We have about 100 publishers and at least the same subscribers each with many articles. I want to move/migrate from this server, which is a 2k SQL server on an older box to a newer one with 2k5 SQL server.
Ist there an automated way to do this or do I have to do it manually for each publisher/subscriber?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed