Viewing 15 posts - 16 through 30 (of 39 total)
Thanks for the reply, These databases do exist and it all worked up until recently, plus the fact that accounts that once worked no longer work to access the instance...
November 8, 2019 at 12:01 pm
Sorry i just used a standard instance name so as not to give away the real information I am using the named instance with the port number. for example /INSTANCENAME=MSSQLSERVER,...
October 23, 2019 at 8:37 am
The following script can be used to set up log shipping standard and Disconnected log shipping but for the purpose of Disconnected log shipping, I have modified it slightly.
I recommend...
October 16, 2019 at 8:44 pm
I fear you believe my question to be simplistic in nature hence the response. I have reviewed posts many in fact and the script you mention is not really what...
October 4, 2019 at 8:41 pm
Hi Steve,
So the background is the log files are being Tlog shipped from an external company once a day to a file share. This external company has provided us with...
August 14, 2019 at 9:15 am
Agree with you comments relating to the secondary node being read only will incur additional licensing costs as the SA purchased with the primary server will give you one free...
July 9, 2019 at 9:17 pm
Hi there. I am in agreement with the rest about adding a third node however I am guessing that your reason for suggesting this is down to cost which is...
July 9, 2019 at 8:05 pm
That seems like a lot for a 60gb dB. That said the most I have migrated was around 30 file groups per database. I simply restored a backupof the said...
July 9, 2019 at 7:43 pm
Not really a problem but there are 5 access databases and one SQL Server on prem. A job has been created on the SQL Server to export data from these...
July 9, 2019 at 12:59 pm
I believe that is all you require. As per Steve Jones's Post go 2017 if you can however it all depend on what you will be hosting on an availability...
July 9, 2019 at 8:39 am
Hi sue,
That at is correct however the issue is that when you assign available storage to a role it no longer appears in the cluster storage as a volume that...
July 8, 2019 at 10:59 pm
Thanks for the Reply, The Backup Volume is a CSV presented from a SAN so I am hoping consecutive writes would not cause to much of a bottle neck.
May 13, 2019 at 1:16 pm
I have isolated a number of DBS where there backup process is taking along time. I believe there maybe wait issues that will need resolving but i did as advised...
May 13, 2019 at 10:27 am
Thanks for your reply.
To be honest i dont have the ability to write the backups to multiple locations but the backups are located on a completely separate volume that is...
May 8, 2019 at 8:48 am
Viewing 15 posts - 16 through 30 (of 39 total)