Hi, I tried using both.
I prefer to use scripts.
The only thing than may happens is that during the restore, that takes 15/20 minutes, some log backup is performed and SQL Server does not allow me to do a mirror session.
What I will do is to switch database to SINGLE_USER so that nobody can connect but me, it should work, even if it takes 24 hours, right ?
There should be a way to do a mirror for big databases.
Originally Posted by rdjabarov
Did you use a script to turn mirroring on, or you did it clicking through the wizard? After the last transaction log is taken on the principal, it needs to be immediately applied on the mirror, followed by turning the mirror on. If there are any transactions took place after the log was backed up and before you issued the last ALTER on the mirror, - you'll get an error. To avoid it, script the process starting with taking the last trx log backup on the principal.