Tag Info

New answers tagged

2

The data should be "the same" as on my machine, that I can dismiss my server and point to new machine in the end. Based on your comments, your best option would be Database Mirroring or Log shipping. You have to evaluate your RPO and RTO. Since you are using VPN to your actual machine - meaning it is point-to-point connection : If you go with ...


2

It sounds like you're trying to setup a disaster recovery environment, so that if your local machine blows-up you can switch over to the Azure machine. There are a number of options, each with their own pros and cons. These are well documented elsewhere (see this link for an overview from Brent Ozar: ...


1

You are correct.. Install SQL Server on the new nodes Use SP_HELP_REVLOGIN to copy the user account to the secondary node Take a full backup and a single log backup of the primary server and restore on the secondary with no_recovery Break the mirror and remove the secondaries from the primary server Create the endpoints with TSQL or use the Mirroring ...



Top 50 recent answers are included