Tag Info

New answers tagged

1

have fixed sqldwdev01 the reason I couldn't connect to UAT instance is because of a couple of reasons 1st was there was a dynamic port specified for the instance under SSNetworkConfig\Protocols for UAT so had to remove that and specify 1435 (as 1434 is in use) restart the service still cant connect remotely to the instance name but can connect using the ...


4

I'm not sure I would advocate it as a good solution, neither performance wise nor as a best practice, but there actually is a possibility. In short, the steps would be Make a backup on a swap file on the server Create a temporary table with a varbinary field Insert the backup into the table Fetch column data using ADO.NET Save the stream in a file The ...


2

With that in mind, I've thought about creating a remote client that would run on my NAS server and that would connect to my different SQL Server instances and issue the job of backing up those databases on a regular basis. You can use SQLCMD - command line utility to backup your databases on multiple servers. Put SQLCMD in a .bat file and schedule it ...


1

Understanding of the specifications and proposed data model After mantaining very productive interactions via comments, reading your question and looking closely at your diagram, I have prepared the following assertions that I consider relevant in order to describe my understanding of your scenario and, therefore, share my personal approach to such: A ...


3

The /128 in the address is the NUMBER OF BITS to match... not a range. So you would want 10.8.101.0/24 (match the first 24 bits). As an additional example, if you wanted to restrict it to 10.8.101.128 to 10.8.101.255 then you'd do 10.8.101.128/25 Please see the address subsection in the documentation



Top 50 recent answers are included