Comments
Sort by recent activity
Hi Jessica,
I'm back from holiday so for the first moment check log files that you can find attached / comments
Hi Jessica,
I'm back from holiday so for the first moment check log files that you can find attached
Hi Jessica,
Please find attached file with logs. Once again, please keep in mind very specific environment. I set it up just a few weeks ago. SSMS is producing problems from the very first moment (upgrade Win7 to Win10). And I'm not sure it is related to Red Gate products. Sometime I'm getting SQL Prompt error but very often SSMS is getting stacked without Red Gate error or warning.
And finally, from tomorrow I'm on holiday and will be out of office until 7th August. If there is anything that I can do today I'm ready to answer asap.
Kind regards
Nebojsa Ilic (Boka), DBA, National bank of Serbia / comments
Hi Jessica,
Please find attached file with logs. Once again, please keep in mind very specific environment. I set it up just a few weeks ago. SSMS is producing problems from the very first moment (...
Hi there,
I'm not able to reproduce the problem but still have SSMS crashes from time to time. I'll run SSMS as administrator in the future to see if it makes a difference.
Toolbelt is installed so aside SQL Search I have also SQL Prompt, Tab, Source Control and Test integrated in SSMS. As well as Compare, Data Compare,... / comments
Hi there,
I'm not able to reproduce the problem but still have SSMS crashes from time to time. I'll run SSMS as administrator in the future to see if it makes a difference.
Toolbelt is installed so...
Hi Dan
Thanks for your reply. Your post and SQLBackupRestore give clear view on SQLBackup and AG. I suggest amending SQLBackup Documentation (using explanation in post for two backup parameters as well as highlighting tags cluster and availabilitygroup) also including example from this site.
BTW, you wrote ".. backup log... with... secondary_replica_copy_only". Is that done by mistake or it's my misunderstanding that you can't backup log with copy_only. / comments
Hi Dan
Thanks for your reply. Your post and SQLBackupRestore give clear view on SQLBackup and AG. I suggest amending SQLBackup Documentation (using explanation in post for two backup parameters as ...
Hi Dan,
SQL Backup log command is clear to me. What make me confused is that running sp sqlbackup to backup log with copy only option (or setting this option in gui) is producing error!
Anyway, looking at example on sqlbackuprestore I created scenario like this: We have 2 servers in cluster with AG. Server A is primary and B is secondary read-only replica as well as preferred for backup. I created jobs on both servers, one for full backup using command:
EXEC master..sqlbackup '-sql "BACKUP DATABASES [a, b] TO DISK = [<AUTO>] WITH SECONDARY_REPLICA_COPY_ONLY, CHECK_PREFERRED_AG_REPLICA"'
and second for log like:
EXEC master..sqlbackup '-sql "BACKUP LOGS [a, b] TO DISK = [<AUTO>] WITH CHECK_PREFERRED_AG_REPLICA"'
Please reply if you find any concern about this scenario? / comments
Hi Dan,
SQL Backup log command is clear to me. What make me confused is that running sp sqlbackup to backup log with copy only option (or setting this option in gui) is producing error!
Anyway, loo...
Hi Matthew,
First of all - installation is cluster aware.
I have two nodes, active - pasive mode.
I changed datapath following your instructions.
When I move group from node A to node B than datapath is reverted to old value on node B and vice versa. / comments
Hi Matthew,
First of all - installation is cluster aware.
I have two nodes, active - pasive mode.
I changed datapath following your instructions.
When I move group from node A to node B than datapa...
Hi Matthew,
Unfortunately, this is solution just until failover. After move group to another node registry is changed. Is there a solution or this is a bug? / comments
Hi Matthew,
Unfortunately, this is solution just until failover. After move group to another node registry is changed. Is there a solution or this is a bug?
Hi Matthew,
That was a key to solve this problem. Thank you. / comments
Hi Matthew,
That was a key to solve this problem. Thank you.
Hi Matthew,
Thanks for reply. That's exactly what I've done. If I start SQL Backup service nothing's happen. But in the moment when I bring SQL Backup cluster resource online windows revert reg value and recreate old path with new sdf file!
Any other idea? / comments
Hi Matthew,
Thanks for reply. That's exactly what I've done. If I start SQL Backup service nothing's happen. But in the moment when I bring SQL Backup cluster resource online windows revert reg val...
Hi Brian,
I'll keep in mind what you said but...
Choosing between 'users kicked out of the server' and 'stale data in database' is pretty difficult. The best solution is if we have restore operation working online. Any thoughts about this? / comments
Hi Brian,
I'll keep in mind what you said but...
Choosing between 'users kicked out of the server' and 'stale data in database' is pretty difficult. The best solution is if we have restore operatio...