Viewing 15 posts - 46 through 60 (of 1,626 total)
Hi, As Jeff Williams said: "If DR is more important then you can setup a secondary in the other data center, configure a BAG for each database with manual failover. ...
November 14, 2022 at 6:35 pm
For my case, we are planning to setup the secondary node node2 in another data center in another location away from our main data center. Mostly for disaster recovery purpose,...
November 14, 2022 at 6:27 pm
I found they have multiple access database with different purposes. And some of the Access databases have only forms, tables are connected with another Access mdb databases. and some tables...
November 10, 2022 at 6:36 pm
Thank you all.
In that case, I think I can use the developer edition for testing Alwayson Availability instances.
Hope that no any difference, regarding other tools for example to install SSMS,...
October 24, 2022 at 3:18 pm
I think for the second one - the dynamic query, I forgot to use a set key word.
September 26, 2022 at 10:58 pm
Thank you so much Jeff, that is good information, I will read and look into it. Thank you for providing the links !
August 16, 2022 at 10:03 pm
Thank you Kaj, that was a great and easy trick.
Thank you so much!
August 15, 2022 at 4:57 pm
Thanks,
I was just curious if they are using same transaction log backup chain. It looks like they do.
I can think of a scenario, for example my log shipping set the...
July 1, 2022 at 3:36 pm
Thanks, the tail log backup makes sense now for me.
Additionally can I confirm the following statement is true?
When doing full backup in SQL server , It will include all data...
May 7, 2022 at 5:04 pm
That make sense. For this situation I asked is to restore database to the point that I start do the last full backup. So as I understand now it should...
May 6, 2022 at 9:31 pm
my total job takes 2 minutes if it is a successful run. so very quick. The ado.net source is a sql select query, it then goes to SQL server destination...
April 25, 2022 at 8:35 pm
That is a marvelous idea to get addresses. Thanks much, that gives me some ideas.
But what we need now is to create fake addresses for testing environment, not using real...
February 26, 2022 at 12:34 am
Thank you, I just want to generate some random fake data that look like street names, one word. 2000 or so. This is for testing DB that cannot have real...
February 25, 2022 at 4:47 am
No, my addMasterAddress table could have gaps for AddressID, that is why I am not using it, I use generated row_number,
like this:
with cteMasterAddressRow as
(SELECT *, row_number () OVER (ORDER BY...
February 16, 2022 at 9:16 pm
I think the row_number it generate as long as gurantee each address row is only used once , address it is unique, it is OK. there is no specific order...
February 16, 2022 at 7:54 pm
Viewing 15 posts - 46 through 60 (of 1,626 total)