I have a issue, we need to keep our production server using on other location by taking a cold/warm backup onto a standby server with transactional replication..
what is the best way to implement this.
How to take the cold/warm backups? How to move the databases to the standby server? and how to implement T-replication while the server is in standby mode,and how to prepare the standby server running in a Disaster Recovery scenario?
Thanks