Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 1 10
Impact
~12k people reached

Sep
7
comment Does Log-Shipping need Transaction Log Backup from Primary Server?
I guess technically you could argue that you shipped the log once, but the point of log shipping is to keep the secondary server up to date more often than the full backups (which are typically very large in comparison to periodic log backups). I just restored Full Backup and not the Transactional Log Backup and still it is updating the secondary database as per the schedule. I set it to 2 mins..as it contained just a table.
Sep
7
comment Does Log-Shipping need Transaction Log Backup from Primary Server?
Initialize the logshipping
Sep
7
comment Does Log-Shipping need Transaction Log Backup from Primary Server?
If you don't include the transaction log, then it's not really log shipping, is it? It is happening
Aug
30
comment SQL Server index / performance help needed (index scan and a sort taking 40 minutes)
Actually he is talking about 48 million rows. I had same issue before. I took same initiative (involved temporary tables). But this caused the situation worst. Why? The Hard Drive started to occupy 22GB space in a week due to .ldf file . In know this will fix the issue but temporarily.
Aug
30
comment SQL Server index / performance help needed (index scan and a sort taking 40 minutes)
Temp table can easily increase the log file very quickly?