Viewing 15 posts - 1 through 15 (of 176 total)
Yes once initialised by the first full/diff, then any subsequent fulls/diffs are not required, only the rolling log chain.
As for the table not being present, I take it you...
January 16, 2020 at 11:29 am
Since copy_only was breaking LSN when run parallel with normal LOG backup I decided to use the same log backups and wrote a C# code to fetch the latest file...
January 15, 2020 at 4:51 am
The option of copy_only on the log backup wont mark the log as re-usable.
So your 20 minute log backup regularly is marking the log as reusable to which your...
January 13, 2020 at 6:22 pm
Guys,
Can I use SSMS 2014 Express edition to connect to a lower and higher SQL server? e.g sql server 2005,sql server 2016, sql server 2017.
Is there a difference between...
October 23, 2019 at 11:59 am
I agree with Jeff. If you want to change passwords, do so though be aware this might mean reboots or restarts. For service accounts, use group service accounts, or...
October 23, 2019 at 4:21 am
Thanks Michael, both the reasons you mentioned are valid for SQL Accounts but Service Account and Admin Accounts are strictly with DBAs and Windows Admins.
If you're...
October 23, 2019 at 4:16 am
Thanks Michael, both the reasons you mentioned are valid for SQL Accounts but Service Account and Admin Accounts are strictly with DBAs and Windows Admins.
If you're sharing the...
October 15, 2019 at 9:53 am
Sure, it's advisable.
I'm assuming that the reason for this is because the users and passwords have slowly got out to the people who shouldn't have them, or they do...
October 13, 2019 at 6:00 am
If you are doing updates, then SSIS works great. If this is a full migration each time, there is the SQL Server Migration Assistant that works well. A number...
August 25, 2019 at 6:04 am
Thanks Steve,
We need to do multiple times till the project goes live in SQL Server as we are removing Oracle for this.
August 21, 2019 at 5:03 am
This is a resource I trust very much talking about this topic. His suggestion is to change the keys every two years. Read the article for more details.
Thanks...
May 31, 2019 at 8:45 am
There's a difference (to me, anyway) between a table that suffers a whole lot of INSERTs and a table that suffers UPDATEs. Run logs (with only one exception that's...
May 1, 2019 at 8:43 pm
Taking a step back, if the table gets routinely updated, then it's probably more like a queue table or a run log table (ie: row gets insert with StartTime...
May 1, 2019 at 8:37 pm
If you have SQL Server Enterprise you can use ONLINE = ON on the create index statement. This is supposed to allow transactions to continue on the table while...
May 1, 2019 at 8:35 pm
Can anyone help me on this? Getting 300+ of the same ..How can I avoid this?
March 31, 2019 at 7:53 am
Viewing 15 posts - 1 through 15 (of 176 total)