Viewing 15 posts - 31 through 45 (of 1,626 total)
Setup, administration and troubleshooting for AGs is much simpler than log shipping, especially on SQL2019. The place I worked at last had a SQL cluster at each of two...
November 29, 2022 at 7:23 pm
So again, how much pain do you want to be in when your up against it, and this will then drive the discussion about what technology and solution would...
November 29, 2022 at 6:46 pm
Thank you for the article.
Can I ask: when you day: Enter port number 1433, and enter the IP address for your listener. This should be an unused IP address on...
November 22, 2022 at 10:52 pm
Mirroring is still available in 2019.
Log backup has to be done in sequence , if you want the log backup files for primary server recovery too, take the folder...
November 22, 2022 at 9:09 pm
then create a DNS CNAME of name ServerA which points to the listener so then you don’t need to go change the applications either now or in a dr...
November 21, 2022 at 11:26 pm
Regardless of whether you have an AOG listener, you can connect directly to either the primary or secondary using a connection string similar to that below. If connecting to...
November 21, 2022 at 11:06 pm
Yes, thanks that is what I did, in SSMS I have to choose the full backup and differential,
then I generated the script, and comment out the full backup line, and...
November 21, 2022 at 9:00 pm
IF it is for a DR activity, why don't you user Log shipping or Mirroring?- Just for clarification.
The same code changes will apply here too.
I know mirroring is deprecated.
For...
November 21, 2022 at 7:47 pm
Thank you.
I found out if I use SSMS to do that, it failed with error: full backup not selected even I use the right LSN differential or transaction log backup.
But...
November 21, 2022 at 6:42 pm
I found this can be done from T_SQL, but error out by using SSMS, it seems a bug from SSMS, or it has to select full backup in the list...
November 18, 2022 at 9:38 pm
Thanks,
Then where are those transaction log backups from log shipping?
Are they in backup log chain with full backup and differential backup with my regular maintenance backup? Apparently not. Then how...
November 18, 2022 at 7:59 pm
Yes, that is what I did.
So first I restore the full backup with no recovery.
Then after an hour later I restore the database with diffrential only, then it errors out...
November 18, 2022 at 7:55 pm
This is for disaster recovery only, so we can have some down time and do manual failover.
Yes it is in another location.
Currently we have the SQL server running standalone ServerA,...
November 18, 2022 at 7:49 pm
Thank you,
What I meant is can I restore the full backup and then differential backup at different time?
For example,
I restore full backup from production to test server database on Sunday...
November 18, 2022 at 7:37 pm
We work on premise. The cluster is two nodes, one node is at our office building which is main data center, the other node is in another location in our...
November 18, 2022 at 4:27 pm
Viewing 15 posts - 31 through 45 (of 1,626 total)